Wednesday, June 01, 2011

ORA-00020: maximum number of processes (%s) exceeded

Solution:
If we couldn’t connect Database via SQLPLUS
1.        Stop all listeners           
2.        Start all listeners
Note: ( Do 1st and 2nd steps in multiple time up to get SQLPLUS )

3.       Connect to SQLPLUS
4.       Alter system set processes=300 scope=spfile;
5.       Create pfile from spfile;
Note: If necessary proceed with 6th and 7th steps

6.       Shutdown immediate
7.       Startup

If we  can access via SQLPLUS
1.       Alter system set processes=300 scope=spfile;
2.       Create pfile from spfile;
Note: If necessary proceed with 3th and 4th steps

3.       Shutdown immediate
4.       Startup
 
 
  Regards,
Sukhwinder Singh

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

There was an error in this gadget