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

Bir cevap yaz─▒n

E-posta hesab─▒n─▒z yay─▒mlanmayacak. Gerekli alanlar * ile i┼čaretlenmi┼člerdir