Lost SYS password Tips Oracle Error Tips by Burleson Consulting

 

Many times, users may find themselves with a lost SYS password when using Oracle.  Though it may appear difficult, there are many solutions to this issue.

 

For example, on Oracle DBA Forums, a user finds themselves troubled by a lost SYS password, and was given these solutions by various repliers:

• You can connect using the alter user privilege under any user, and change the password since it has been lost.
  

• If you have Oracle passwords as "identified externally", you can connect without a password and re-set your SYS password:

• Make sure that the database and listener services are started. Then open a command prompt and log in as / as sysdba. Then change the sys password.
  
  c:> sqlplus /nolog
  SQL> connect / as sysdba
  SQL> alter user sys identified by ,new password>;
  
  If you get asked for a password when you log in as / you need to create or recreate the password file using orapw. Check the $ORACLE_HOME/database directory for a file called orapw<SID>. That is the password file for the database. Create (or recreate) it using:
  
  c:\> orawpd file=$ORACLE_HOME/database/orapwd<SID> password=<password> entries=5
  
  Notice it is from the dos prompt

• You may also want to try the following when you are troubled by a lost SYS password:

• 1. login oracle user
  
  2. cd $ORACLE_HOME/network/admin
  
  3. ed(vi) file sqlnet.ora
  
  4. Remark by # at begining of line
  
  SQLNET.AUTHENTICATION_SERVICES = (NONE)
  => #SQLNET.AUTHENTICATION_SERVICES = (NONE)
  
  5. sqlplus /nolog or (svrmgrl) command
  
  6. connect sys as sysdba, or connect internal
  (not need input the password).