Wednesday, March 6, 2013

Oracle XE problems

Had a few issues when trying to connect to oracle xe installed by another user

Getting sqlplus to work
set ORACLE_HOME=C:\oraclexe\app\oracle\product\11.2.0\server
set ORACLE_SID=XE
set PATH=C:\oraclexe\app\oracle\product\11.2.0\server\bin;%PATH%

Connecting as sysdba to change password (ORA-01031: insufficient privileges)
 Type Edit local users in your start menu search bar (Select the first one in the Control panel group)
 Click Groups
 Select ORA_DBA
 Add your user here
 sqlplus / as sysdba from the command prompt with all above variables set
 alter user SYS identified by "newpassword";

No comments:

Post a Comment