Oracle : ORA-00020: maximum number of processes (150) exceeded

 

ORA-00020: maximum number of processes (150) exceeded

To resolve this error , please follow below steps:

$ sqlplus -prelim "/as sysdba"

   SQL> Conn sys as sysdba

 SQL> shutdown abort

 ORACLE instance shut down.

 SQL> exit

 Disconnected from ORACLE

After this point the database could once again be restarted:

sqlplus / as sysdba

Then run below commands:

sql> alter system set processes=500 scope=spfile;

sql> alter system set sessions=555 scope=spfile;

sql> alter system set transactions=610 scope=spfile;

sql> shutdown abort

sql> startup