Uncategorised

Oracle Tutorials: How to reset Oracle sysdba Password

May 2, 2023 Leave a Comment

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
Follow me
Latest posts by Rajesh Kumar (see all)
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x