Sunday, February 21, 2010

Resetting password for System user in Oracle Express Edition

If you are running Oracle XE for your own development purpose and by any chance forgotten the password of the "system" user here are the simple steps to resolve the problem

Linux:
export ORACLE_SID=XE
export ORACLE_HOME=
sqlplus / as sysdba
SQL> alter user system identified by ;

Windows:
set ORACLE_SID=XE
set ORACLE_HOME= (E.g. This will look something like - "D:\oraclexe\app\oracle\product\10.2.0\server")
sqlplus / as sysdba
SQL> alter user system identified by ;

Hope this helps...

No comments:

Post a Comment