Sunday, February 28, 2016

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>;

<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.

1 comment:

back to top