Thursday, 2 June 2011

Resetting Oracle XE 'SYSTEM' account password.

SYSTEM and SYS are the default accounts and you'll need to supply password at the time of installing Oracle express edition.
If you forgot your Oracle XE 'system' account password, follow these steps to reset. In fact, I forgot and reset it just now.


Windows: Open any DOS window and do the following.

C:\set ORACLE_SID=XE (or your service id)
C:\set ORACLE_HOME= (Eg: C:\oraclexe\app\oracle\product\10.2.0\server)
C:\sqlplus / as sysdba

You should see SQL> prompt with DBA privileges. Next, issue sQL command to alter the passwords for SYSTEM and SYS accounts.

SQL> alter user system identified by ;
SQL> alter user sys identified by ;

You need to reset password for both SYSTEM and SYS accounts.

5 comments:

  1. I've been searching on google, they answered same with you but they don't tell about this:
    C:\set ORACLE_SID=XE (or your service id)
    C:\set ORACLE_HOME= (Eg: C:\oraclexe\app\oracle\product\10.2.0\server)

    thank you so much!
    god bless you :)

    ReplyDelete
  2. I followed your steps, but after I typed the last sqlplus / as sysdba a ERROR message prompted like that: ORA-01031: insufficient privileges.
    Please help. Many thanks.

    ReplyDelete