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
orapwdutility 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 theorapwdcommand 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 sysdbab. Run theALTER USERcommand 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 have worked at Cotocus. I share tech blog 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 TrueReviewNow , and SEO strategies at Wizbrand.
Do you want to learn Quantum Computing?
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 WIZBRAND
Find Trusted Cardiac Hospitals
Compare heart hospitals by city and services — all in one place.
Explore Hospitals