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.

• Author
• Recent Posts

Follow me

Rajesh Kumar

Mentor for DevOps - DevSecOps - SRE - Cloud - Container & Micorservices at Software AG

Join my following certification courses...
- DevOps Certified Professionals (DCP)
- Site Reliability Engineering Certified Professionals (SRECP)
- Master in DevOps Engineering (MDE)
- DevSecOps Certified Professionals (DSOCP)
URL - https://www.devopsschool.com/certification/

My Linkedin - https://www.linkedin.com/in/rajeshkumarin

Follow me

Latest posts by Rajesh Kumar (see all)

• Installing Jupyter: Get up and running on your computer - November 2, 2024
• An Introduction of SymOps by SymOps.com - October 30, 2024
• Introduction to System Operations (SymOps) - October 30, 2024