Oracle: ORA-00020: maximum number of processes (10) exceeded [ID 1032127.1]




In this Document
  Symptoms
  Cause
  Solution

Applies to:

ATG eServer - Version: 5.2 - Release: 5
Information in this document applies to any platform.
Product Name: eServer: Server
Product Version: 4.0, 5.0

Symptoms

ORA-00020: maximum number of processes (10) exceeded
Caught exception = pexPeerError - "svr-action-qmanager.cc", line #104
       pexDatabaseError - "db-iface-oci.cc", line #589
       pexDatabaseError::ErrorMessage ---> "ORA-00020: maximum number of processes (10) exceeded"
       pexDatabaseError::ErrorCode ---> "20"

Cause

All process state objects are in use.

Solution

Increase the maximum processes in the INIT.ORA file.  Modify the parameter "processes."  Below are some sample lines from an init.ora file:

processes = 50                                                          # SMALL
# processes = 100                                                     # MEDIUM
# processes = 200                                                     # LARGE

Refer to the documentation within the init.ora file for guidelines on what is considered small, medium, or large.

The process parameter determines the maximum number of operating system processes that can be connected to an Oracle instance concurrently.  The value of this parameter must be big enough to provide for all the Oracle background processes (such as DBWR,pmon,smon) plus 1 for each user process.

For example, if you have 100 concurrent users, set this parameter
to al least 100 + number of Oracle background processes.

See also: "Gather information about Oracle database errors": Document: 1031459.1.

Legacy ATG Properties
Category: Database, Installation / Configuration
Product Name: eServer: Server
Product Version: 4.0, 5.0
Advisory: No
Localization: English (US)
Database: Oracle 8.1.6, Oracle 8.0.6
Topics: Primus eServer, Knowledge Base Solutions, Product & Services
ATG Solution ID: primus5980

Comments

Popular Posts