Reset sys password in Oracle DB

If you have forgotten the sys password for an Oracle Database, you can reset it by logging in as an OS user belonging to the dba group. Here is how to do it.

First you need to login to the Database server. In my case this was a Windows server and I logged in as the Administrator user though Remote Desktop.

Open a command prompt window and type in

C:\>sqlplus /nolog

you should get a sqlplus command prompt. type away the following commands to change the password.

SQL> connect /@POP as sysdba

SQL> alter user sys identified by newpwd;

the /@POP is to connect to the POP instance of the database. I had multiple instances on my Server.

“newpwd” is the new password for the sys user.