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.
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