Saturday, July 20, 2013

How Connect to Oracle when you forgot your Password

Reset Oracle Password
Step1: Open SQL Command Line  and enter the following command:

SQL> conn sys/manager as sysdba;

Step2: To reset the password of the SYSTEM password (or any other user password), run the following query:
SQL> alter user sys identified by manager;
User altered.


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