How to recover or change Oracle sysdba password [closed] How to recover or change Oracle sysdba password [closed] linux linux

How to recover or change Oracle sysdba password [closed]


Have you tried logging into Linux as your installed Oracle user then

sqlplus "/ as sysdba"

When you log in you'll be able to change your password.

alter user sys identified by <new password>;

Good luck :)


You can connect to the database locally using the 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/binexport ORACLE_SID=<your_oracle_sid>SQLPLUS / AS SYSDBA

Windows

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

Once connected, you could then alter the user to modify the password:

ALTER USER username IDENTIFIED BY password;