Oracle Tutorials: How to reset Oracle sysdba Password

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:

1. 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 the orapwd 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.
2. 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 the ALTER 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.

Rajesh Kumar

I’m Rajesh Kumar, a DevOps, SRE, DevSecOps, Cloud, and Platform Engineering expert passionate about sharing practical knowledge, real-world experiences, and industry best practices. I have worked at Cotocus and regularly write about technology, travel, investing, health, product reviews, and digital marketing through my various platforms.

I publish technical articles at DevOps School, travel stories at Holiday Landmark, stock market insights at Stocks Mantra, health and fitness guidance at My Medic Plus, product reviews at TrueReviewNow, and SEO and digital marketing strategies at Wizbrand.