How To Recover a Lost Password on Oracle

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 -
Published by aakai1056. Latest update on November 22, 2017 at 05:52 PM by owilson.
This document, titled "How To Recover a Lost Password on Oracle," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (
Oracle - Get information about the size of the database
Linux - Installing Oracle 11g on Ubuntu