Wednesday, March 28, 2012

Lost Oracle SYS and SYSTEM password?

Here are a few ways to reset those passwords once forgetting them:

Approach 1:  SQLPLUS

To change the password of SYSTEM:

$ sqlplus "/ as sysdba"

SQL> show user

SQL> passw system

SQL> quit

Next, to change the password of SYS:

$ sqlplus "/ as system"

SQL> passw sys
SQL> quit

Then you should be able to log on the SYS and SYSTEM users, with the passwords you just typed in.

Approach 2: creating password file

1) stop oracle instance service first

2) find the PWD<SID>.ora file for this instance, which is usually located at <ORACLE_HOME>\database\

3) rename the PWD<SID>.ora file to PWD<SID>.ora.bak for obvious safety reason

4) create a new pwd file by issuing the below command:
orapwd file=<ORACLE_HOME>\database\PWD<SID>.ora password=xxx
where <ORACLE_HOME> will be replaced by the exact path of it

5) start oracle instance server again.

Then you should be able to get in with the SYS user and change other passwords using the first way above.


sarah lee said...

In this world, it is too common for people to search for someone to lose themselves in. But I am already lost. I will look for someone to find myself in. See the link below for more info.


forrestcodilla said...

Can’t wait to share this site to some of my friends you never fail to overwhelm us, always got explanation that we didn’t expect. This may be probably the reason why you got more visitors. Keep us inform like this one. Cheers

Cindy Dy said...

Thank you for this post. Keep it up. Hope to read more post from you guys.


lee woo said...

Love it! Very interesting topics, I hope the incoming comments and suggestion are equally positive. Thank you for sharing this information that is actually helpful.

Cannibal Mtl said...

did n't me(( i restore DB from rman copy. try to reset sys passwort. IT says that user altered but do not accept the new password ((