How to recover or change Oracle sysdba password [closed]
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;