ORA-00020: maximum number of processes exceeded

Published by Ahmad on

Cause:

Connections to the database have caused the current number of operating system processes

associated with the Oracle Instance to exceed the PROCESSES database parameter

(All process state objects are in use).

Action:

Increase the value of the PROCESSES initialization parameter.

Solution:

This is a temporary solution.

If Prod is using spfile then do these steps.

SQL>show parameter processes

NAME TYPE VALUE

——————————–

processes integer 150

SQL>alter system set processes=300 scope=spfile;

SQL>shut immediate

SQL>startup

SQL>show parameter processes

NAME TYPE VALUE

———————————

processes integer 300

Please do the Like, Comments & Share in your circle.

Thanks

With Best Wishes!!!!

Ahmad

ACE Associate
Cloud Architect
Oracle Database Consultant

Certified in-: | 1XAzure | 6XOCI | 1XOCS (GG) | 1XOCE (RAC) | 3XOCP (11g,10g,9i) | 1XOCA (9i) |

My YouTube Channel (OracleRide)
http://www.youtube.com/c/OracleRide


0 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *