DBA Tips for Oracle 10g Lost SYSOPER Password!!

Author: Frank Coladonato

SYSOPER is Oracle administrative privilege that is used to perform administrative tasks. A user with SYSDBA or SYSOPER privileges connect with a default schema instead of the schema generally associated with its username. SYSDBA uses SYS schema whereas SYSOPER uses PUBLIC schema.

While working with Oracle 10g we mostly face the scenario where we have lost the SYS password. It is really frustrating situation and seems difficult but it is not at all impossible to solve this problem. No more troubles as below tips will help you solve this problem.

Before trying any solution you must ensure that the database and listener services are started.

Solution - I:

Even if you have lost your SYSOPER password, still you are able to connect using the alter user privilege under any user. Once you are connected you can change the password and then connect as SYSOPER using new password.

Solution - II:

You can log in as SYSDBA via command prompt. Once it is done then you can change the SYS password.

c:> sqlplus /nolog
SQL> connect / as sysdba
SQL> alter user sys identified by ,new password>;

The $ORACLE_HOME /database directory has a file orapw<SID> . This is the password file for the database. If you are asked for password then you can create or recreate the password file using orapw by using below command.

c:\> orawpd file=$ORACLE_HOME/database/orapwd<SID> password=<password> entries=5

Solution - III:

This solution can help you out for a lost SYS password. First of all you will need to log in login oracle user.

The cd command is used to change the directory.

cd $ORACLE_HOME/network/admin

ed is short phrase of EDIT command in sqlplus. If no EDITOR is set then EDIT command will run Ed. The OS default editor can be set to vi .

ed(vi) file sqlnet.ora

Now remark “SQLNET.AUTHENTICATION_SERVICES = (NONE)” by adding ‘#' at beginning of line as follows.

#SQLNET.AUTHENTICATION_SERVICES = (NONE)

Then you need to run sqlplus /nolog or (svrmgrl) command.

Finally you can connect SYS as SYSDBA or connect internal without the need to input the password. Read Again!!

 More Oracle Articles, Database Articles and DBA Tips
   Database Security: Step by step guideline
   Beware of using Oracle RAC with Data Warehouse!!
   Amazing Tips to Fix Broken Oracle ASM Instance!!
   DBA Tips for Finding Oracle Log Files in Oracle R12!!
   Tricky Password Features in Oracle 11g!!