Oracle: Reset forgotten / unknown SYSTEM password

Don't worry ,if you have forgotten the SYSTEM password for an oracle database server,you can reset the password once again by log in to the window system as administrator.

The steps are:

Open the Sqlplus command line interface via Start -> Programs ->Oracle -> Instance Name ->Application Development -> sqlplus.

A login page will come after you start the sqlplus and ask for the USER-NAME: In this field just type the  / as sysdba and press enter.

As you know SYSTEM having all the DBA privileges (ya there is some limitation also present with the SYSTEM as compared  to SYS account).

If you want to get what are the privileges a SYSTEM and SYS account have then please follow my blog's link.


So now you have connected to the oracle database server with SYSTEM account and having all the dba privileges.

To reset the password of the SYSTEM password pr any other user password ,please execute the below query in the sqlplus command line interface.

SQL> alter user system identified by Enter_New_Password;

 Note:   While giving the password , don't give any kind of single quotes or double quotes . No need  of it. 

When you press the Enter key you  get a message like USER ALTERED.  And you are all ready to login with the username(SYSTEM ) and the password that just you have created now.


Second Option: 

If you want to do it from command prompt. Then open the command line and following my path
START -> RUN -> TYPE 'cmd.exe' and followed by enter .




Now connect to the sqlplus by type the below command over here.

C:\>  sqlplus \ as sysdba

And do the same process as you have in the sqlplus command line interface.

Like:

SQL> alter user system identified by  new_password 

and you have done your part ..Now System will prompt you a message " user altered" .

By the way , the  password file is present in the location  <ora_home>\database\PWD<SID>.ora.


Thanks.....Have Fun.....