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