Lost Oracle SYS and SYSTEM password?‎

Method 1: SQLPLUS (Tested on Windows Oracle 9.2.0.1.0)‎
——————————————————————————————————–
‎C:\sqlplus “/ as sysdba”‎
SQL> show user
USER is “SYS”‎
SQL> passw system
Changing password for system
New password:‎
Retype new password:‎
Password changed
SQL> quit

Next, we need to change the password of SYS:‎
C:\sqlplus system/oracle
SQL> passw sys
Changing password for sys
New password:‎
Retype new password:‎
Password changed
SQL> quit

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

Method 2: Creating pwd file (Tested on Windows Oracle 9.2.0.1.0)‎
——————————————————————————————————-
‎1.‎ Stop the Oracle service of the instance you want to change the passwords ‎of.‎
‎2.‎ Find the PWD###.ora file for this instance, this is usuallly located at ‎C:\oracle\ora81\database\, where ### is the SID of your database.‎
‎3.‎ Rename the PWD###.ora file to PWD###.ora.bak for obvious safety ‎reasons.‎
‎4.‎ Create a new pwd file by issuing the command:
Orapwd file=C:\oracle\ora81\database\PWD###.ora password=XXXXX

Where ### is the SID and XXXXX is the password you would like to use for ‎the SYS and INTERNAL accounts.‎
5.‎ Start the Oracle service for the instance you just fixed. You should be able to ‎get in with the SYS user and change other passwords from there.‎

Login with /@### as sysdba and try this command.‎
SQL> ALTER USER SYS IDENTIFIED BY ORACLE.‎

Advertisements
Leave a comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: