ORA-00020: maximum number of processes (%s) exceeded

Try to check the process
ps -ef –sort start_time | grep LOCAL | grep $ORACLE_SID

You can do any one of the following depends on your Database usage
1. Wait until usage drops and you can log in.
2. Kill some connections i.e. those marked LOCAL=NO until you can log in.
3. Kill SMON! and restart the database after you’ve solved your max_procs issue.

Once you have connection please increase the number of process in init.ora

Comments are closed.