How to recover a password in Oracle | Forgot Oracle Admin user password

---

To recover a password in Oracle, simply connect under command line mode on the server and execute below alter command.

#sqlplus /nolog SQL> connect / as sysdba SQL> Alter user <USER_NAME> identified by <PASSWORD>; Here <USER_NAME> - Name of the oracle user <PASSWORD> - New password that needs to set to oracle user

But even some cases we may forgot the sys user password, So this we can recover is as follows.

To reset your Oracle database password :

    Your password file should be under <orahome>\database\PWD.ora. Delete it and run the oracle password utility from the command prompt:

C:\Oracle\product\11.2.0\dbhome_1\database> ORAPWD file=PWD.ora password={password} entries={however many}

The {password} is your new sys password. After you login as sys you can change it and create new passwords for system.

---