<<Back to DB Administration Main Page
ORA-00020: maximum number of processes (300) exceeded
............................................................................
............................................................................
Process m001 submission failed with error = 20Process m000 submission failed with error = 20
Process m001 submission failed with error = 20
Fri Aug 24 12:21:07 2018
ORA-00020: maximum number of processes (300) exceeded
ORA-20 errors will not be written to the alert log for
the next minute. Please look at trace files to see all
the ORA-20 errors.
Process m002 submission failed with error = 20
Solution:
Increase the value of processes parameter and restart the database
SQL>alter system set processes=900 scope=spfile sid='*';
System altered.
$ srvctl stop database -d ORCL
$ srvctl start database -d ORCL
Comments
Post a Comment