Site icon Bugra Parlayan | Oracle Database Blog

ORA-00020: Maximum Number Of Processes Exceeded

When i tried to connect to database, i got the ORA-00020: maximum number of processes (%s) exceeded error. Even from sysdba I was not able to connect.

Solution:

Step 1 : Connect to database with prelim option and shutdown abort.
 
$ sqlplus -prelim
SQL> shutdown abort.
 
exit
 
Step 2 : Change the processes parameter to a higher value in the init.ora file.
 
3. SQL> STARTUP
Exit mobile version