How to recover or change Oracle sysdba password

Question

We are working with an oracle database, in which the person who configured it has "long gone" and therefore does not know the sysdba password, but needs it. We have root access to the box (it is on linux). Is there a way to recover or change sys passwords?

Answer 1

You tried to log into Linux as your installed Oracle user, then

sqlplus "/ as sysdba" 

When you log in, you can change your password.

 alter user sys identified by <new password>; 

Good luck :)

Answer 2

You can connect to the database locally using a combination of environment variables:

• ORACLE_HOME
• ORACLE_SID .

Depending on your OS :

Unix / Linux:

 export ORACLE_HOME=<oracle_home_directory_till_db_home> export PATH=$PATH:$ORACLE_HOME/bin export ORACLE_SID=<your_oracle_sid> SQLPLUS / AS SYSDBA 

Window

 set ORACLE_HOME=<oracle_home_path_till_db_home> set PATH=%PATH%||%ORACLE_HOME%\bin set ORACLE_SID=<your_oracle_sid> SQLPLUS / AS SYSDBA 

After connecting, you can change the user to change the password :

 ALTER USER username IDENTIFIED BY password;