How To Recover a Lost Password on Oracle

Ask a question
It is important to recover your lost password on the Oracle database, as not having it would hamper your productivity and block your access to the database, resulting in security issues.

This tutorial will walk you through the process.

Recover Lost Password on Oracle

To recover a password in Oracle, simply connect under command line mode on the server:

#sqlplus /nolog      
SQL>conn / as sysdba
SQL>alter user Username identified by PASSWORD;

To reset your Oracle database password, the process is a bit different. Your password file should be under <orahome>\database\PWD<SID>.ora.


Delete it and run the Oracle password utility from the command prompt:

c\:Oracle\ora92\database>ORAPWD file=PWD<SID>.ora password={password} entries={however many}.

The <password> is your new sys password. After you log in as sys, you can change it and create new passwords for the system.

Image: © WaD - Shutterstock.com