Oracle: ORA-00020: maximum number of processes (10) exceeded [ID 1032127.1]
Applies to:
ATG eServer - Version: 5.2 - Release: 5Information 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) exceededCaught 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