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:
1 2 3 4 5 6 7 8 9 10 | 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 |