Recommended Number of Processes for an Oracle database on ZCM

  • 7006029
  • 18-May-2010
  • 27-Apr-2012

Environment

Novell ZENworks 10 Configuration Management Database

Situation

This error was showing up in the loader-messages.log file.
ERROR:
     ORA-00020: maximum number of processes 150 exceeded
   Died during process startup with error 20 (seq=14229) 
   OPIRIP: Uncaught error 20. Error stack:
   ORA-00020: maximum number of processes (150) exceeded

Resolution

The Oracle dba had set a limit of 150 processes for the ZCM database and there were 3 primary servers in the zone.  It is recommended to have 100 processes per primary server in the zone.