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

In this Document

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


ORA-00020: maximum number of processes (10) exceeded
Caught exception = pexPeerError - "", line #104
       pexDatabaseError - "", line #589
       pexDatabaseError::ErrorMessage ---> "ORA-00020: maximum number of processes (10) exceeded"
       pexDatabaseError::ErrorCode ---> "20"


All process state objects are in use.


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


Popular Posts