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.

Getting over max processes exceeded error

Sometimes due to the default setting or limit on process, the server might hang up. To get over this problem, increase the number of processes to a more appropriate value.
login as sys in SQL Plus and type the following code

-- this will give you the list of all the processes along with their numbers
SQL> show parameter processes
-- this will give you the current setting for the number of processes
SQL> select count(*) from v$process;
-- change it to something higher
SQL> alter system set processes=100 scope=spfile; 

Don't forget to shutdown the database and restart it.

Similarly we can change the job queue processes too

SQL> show parameter job_queue_process 
SQL> ALTER SYSTEM SET job_queue_processes=20;