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 1^st and 2^nd 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 6^th and 7^th 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 3^th and 4^th steps

3.       Shutdown immediate

4.       Startup

 

 

  Regards,

Sukhwinder Singh