TheinNews

How To Recover a Lost Password on Oracle?

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.

Kishore kumar

Add comment

Your Header Sidebar area is currently empty. Hurry up and add some widgets.