Hi all,
In our dataguard environment,even though the number of processes of the standby database was 2000(large enough) we are getting the error as below.
Process m000 submission failed with error = 20
Process m001 submission failed with error = 20
Process m002 submission failed with error = 20
Process m003 submission failed with error = 20
Process m004 submission failed with error = 20
Process m003 submission failed with error = 20
Process m002 submission failed with error = 20
Process m001 submission failed with error = 20
Process m000 submission failed with error = 20
Process m005 submission failed with error = 20
Process m000 submission failed with error = 20
Process m001 submission failed with error = 20
ORA-00020: maximum number of processes 2000 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.
At this time the listener went down and there was no log shipping/apply. After restart it was working fine. But even now if we check the no of processes it is keeping on increasing every 10 mins.
At first the number of processes was 1000.as we got the same error we increased it to 2000. But still we are facing this issue.
Kindly advice on this.