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.

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 password from the Oracle database, the process is a bit different. Your password file should be under databasePWDra.

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

c:Oracleora92database>ORAPWD file=PWDra password={password} entries={however many}.

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

Read Further

Image: © RawPixel - 123RFom