ORA-00020: maximum number of processes (%s) exceeded

[Former Member]

Hi!

We are running SAP ECC 6.0 system with Oracle on windows.

We have some automatic oracle skripts for backup with tapes.

By executing of these skripts we have from time to time the following error:

CONNECT /'

ORA-00020: maximum number of processes (%s) exceeded

BR0310E Connect to database instance GTE failed

Question

How this error can be solved?

Thank you very much!

[srinivasan_vinayagam]

Hi,

you can find current values;

SQL>show parameter processes;

SQL>show parameter sessions;

Calculate the new value and alter the parameters;

SQL>ALTER SYSTEM SET "PROCESSES"=<NEW VALUE>  SCOPE=SPFILE;

SQL>COMMIT;

SQL>SHUTDOWN IMMEDIATE (BEFORE STOP SAP)

SQL>STARTUP

Start SAP.

PARALLEL_MAX_SERVERS = (NUMBER CPU CORES*10)  -> find no. of CPU in Device Manager - Processor

You can find the processes and session values from below parameter and set to initSID.ora and create spfile from pfile;

shutdown sap & oracle then start to Oracle & SAP.

PROCESSES	#ABAP work processes * 2 + #J2EE server processes * <max-connections> + PARALLEL_MAX_SERVERS + 40
SESSIONS	2 * PROCESSES

Reference:

830576 - Parameter recommendations for Oracle 10g

1431798 - Oracle 11.2.0: Database Parameter Settings

Regards,

V Srinivasan

[Former Member]

Hi,

This Oracle message indicates that an operation requests an unavailable resource.

The maximum number of processes is specified by the Oracle parameter "PROCESSES".

Once this number is reached, no new requests can be processed.

Please increase the PROCESSES value in the spfile or pfile (init<SID>.ora) and restart Oracle.

Please check the Current used and Max used number of PROCESSES from the view gv$resource_limit and decide for the number of PROCESSES accordingly.

Use the following SQL query:

select RESOURCE_NAME, CURRENT_UTILIZATION, MAX_UTILIZATION from gv$resource_limit where RESOURCE_NAME = 'processes';

Thanks,

Subhajit.

[Former Member]

Hi,

Change Processes by

SQL> alter system set processes=<Calculated Value> scope=spfile;

SQL>shutdown;

SQl>startup;

Processes Value depends on Session

Exact formula for session : SESSIONS = 1.1 * PROCESSES + 5

Thnx

SurendraJain

[fidel_vales]

Hi,

> Processes Value depends on Session

I think it is the other way around, the sessions value depend on the processes value

> Exact formula for session : SESSIONS = 1.1 * PROCESSES + 5

Sorry, but SAP recommends SESSIONS = PROCESSES * 2

therefore that formula is NOT exact.

Of course, SAP recommendations do NOT take into consideration NON SAP connections and the OP must take that into consideration, he should use the formula recommended by SAP and add the EXTERNAL connections to this calculation.

[Former Member]

Hi Vales,

ys might be ur r right. Session also depends on DML transactions so first have to calculate

sessions.

[sunny_pahuja2]

Hi,

Please run the script attached in note (Note 1171650 - Automated Oracle DB parameter check)..this will check all your database parameter and will suggest which parameter need to be changed as per SAP note 830576...you can run this script via DB02 transaction...

Please take care while running this script as it has separte script for OLTP and OLAP system and also for database release...

Thanks

Sunny

[former_member204746]

Sunny, this script is interesting, but will not take into account external connections like this is the case here.

[Former Member]

Hi,

You need to increase DB parameter PROCESSES.

Check below SAP notes & link for details.

34432 ORA-00020: maximum number of processes exceeded

539755 - ORACLE ERROR : Maximum Number of Processes(80) Exceeded

1188836 - Error: unable to logon ora-00020: maximum number of processes

Thanks

Sushil

[former_member204746]

Read SAP Note 830576 - Parameter recommendations for Oracle 10g.

Increase parameter "processes" to add connections that are non-SAP connections.