The password for the SYSDBA account is stored securely in the Oracle database and cannot be retrieved. If you have forgotten the password for the SYSDBA account, you will need to reset it using one of the following methods:
- Use the password file: If the database has a password file configured, you can use the
orapwd
utility to reset the password for the SYSDBA account. Here are the steps: a. Connect to the database as the SYS user:sqlplus / as sysdba
b. Run theorapwd
command to reset the password:orapwd file=$ORACLE_HOME/dbs/orapw<database_name> password=<new_password>
Replace<database_name>
with the name of the database and<new_password>
with the new password you want to set.c. Exit SQL*Plus. - Use the password recovery process: If you have set up the password recovery process for the database, you can use it to reset the password for the SYSDBA account. This process involves answering a series of questions that you have previously set up to verify your identity.a. Connect to the database as the SYS user:
sqlplus / as sysdba
b. Run theALTER USER
command to set a new password for the SYSDBA account:ALTER USER SYS IDENTIFIED BY <new_password>;
Replace<new_password>
with the new password you want to set.c. Exit SQL*Plus.
I’m a DevOps/SRE/DevSecOps/Cloud Expert passionate about sharing knowledge and experiences. I am working at Cotocus. I blog tech insights at DevOps School, travel stories at Holiday Landmark, stock market tips at Stocks Mantra, health and fitness guidance at My Medic Plus, product reviews at I reviewed , and SEO strategies at Wizbrand.
Please find my social handles as below;
Rajesh Kumar Personal Website
Rajesh Kumar at YOUTUBE
Rajesh Kumar at INSTAGRAM
Rajesh Kumar at X
Rajesh Kumar at FACEBOOK
Rajesh Kumar at LINKEDIN
Rajesh Kumar at PINTEREST
Rajesh Kumar at QUORA
Rajesh Kumar at WIZBRAND