BR0301E SQL error -20 at location BrInitOraCreate-2, SQL statement: 'CONNECT / AT PROF_CONN IN SYSOPER MODE' ORA-00020:

[Former Member]

Problem:- We are receiving the below message frequently and having the issues for

backup,s, transports and other activities.

BR0301E SQL error -20 at location BrInitOraCreate-2, SQL statement:

'CONNECT / AT PROF_CONN IN SYSOPER MODE'

ORA-00020: maximum number of processes (450) exceeded

BR0303E Determination of Oracle version failed

[former_member289242 · Accepted solution]

Hi Manoj,

Ora-00020 error happen when you have too many database connections
(more than defined in parameter setting).
To solve error ORA-00020, you have to increase parameters processes
and sessions in your init<SID>.ora file (see attached SAP note 830576(10
g) and 1431798(11g))

Standard values for these parameters, are:
PROCESSES   =  #ABAP work processes * 2 +
               #J2EE server processes *
               <max-connections> +
               PARALLEL_MAX_SERVERS + 40
SESSIONS    =  2 * PROCESSES

As per SAP Note 1289199, information about Oracle parameters,
o  PROCESSES

   -  Defines the maximum number of Oracle processes that exist in
      parallel

   -  The component relating to ABAP work processes is only relevant
      in systems with ABAP stacks. The component relating to J2EE
      server processes is only relevant in systems with Java stacks.

   -  <max-connections> indicates the maximum number of connections
      (also called pool size) of the J2EE system DataSource
      (sysDS.maximumConnections). You can set the value of this
      parameter using the VisualAdmin tool or other J2EE
      administration tools.

o  SESSIONS

    -  Defines the maximum number of Oracle sessions that exist in
       parallel - must be configured larger than PROCESSES, since
       single processes can serve several sessions (for example, in
       the case of multiple database connections from work processes)

Kindly refer the below notes which looks relevant to your issue:-
===============================================================
830576 Parameter recommendations for Oracle 10g
34432 ORA-00020: maximum number of processes exceeded
398927 ORA errors because dimensions of parameters are too
1289199 Information about Oracle parameters
1431798 Oracle 11.2.0: Database Parameter Settings

Regards,

Gunjan

[Former Member · Accepted solution]

Thanks a lot Gunjan. Appreciate your detailed response ..