cancel
Showing results for 
Search instead for 
Did you mean: 

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

ashish_vikas
Active Contributor
0 Kudos

Hello frndz !

While taking backup of oracle db, we are getting problems .. This system has only JAVA stack.

I have already checked for oracle process and all seems to be fine. Also i am able to connect to oracle by conn "/as sysdba"

.. can you suggest something.

BR0051I BRBACKUP 7.00 (18)

BR0055I Start of database backup: beaxkjlp.anf 2009-06-30 09.54.57

BR0280I BRBACKUP time stamp: 2009-06-30 09.54.57

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

'CONNECT /'

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

BR0310E Connect to database instance S48 failed

BR0280I BRBACKUP time stamp: 2009-06-30 09.54.57

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

'CONNECT /'

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

BR0310E Connect to database instance <SID> failed

ashish

Accepted Solutions (0)

Answers (4)

Answers (4)

JPReyes
Active Contributor
0 Kudos

Increase the value of processes and session as per,

SAP Note 34432 - ORA-00020: maximum number of processes exceeded

Regards

Juan

ashish_vikas
Active Contributor
0 Kudos

thnx ! issue resolved.

Former Member
0 Kudos

Hi,

Increase the parameters 'processes' and 'sessions' by 50% in the profile /oracle/<SID>/dbs/init<SID>.ora.

Regards,

Sachin Rane.

sunny_pahuja2
Active Contributor
0 Kudos

Hi

> 'CONNECT /'

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

> BR0310E Connect to database instance S48 failed

> BR0280I BRBACKUP time stamp: 2009-06-30 09.54.57

> BR0301E SQL error -20 at location BrDbConnect-2, SQL statement:

> 'CONNECT /'

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

> BR0310E Connect to database instance <SID> failed

This shows that no. of processes at oracle level is very less. Increase no of processes.

you can check number of processes by command show parameter processes. Then increase it's value.

Check SAP Note 1221643 - Oracle Message: "ERROR system.database - ORA-00020: maximum number of processes (%s) exceeded"

Also implement SAP note 830576...

Hope it helps.

Thanks

Sunny

ashish_vikas
Active Contributor
0 Kudos

Sunny its not allowing me to use SQLs ..

I was checking Note 830576 - Parameter recommendations for Oracle 10g -

It says value of PROCESSES = #ABAP work processes * 2 + #J2EE server processes * <max-connections> + PARALLEL_MAX_SERVERS + 40

I can check initSID.ora ..and i can see these :

*.processes=80

*.parallel_max_servers=16

Also

#ABAP work processes = 0

#J2EE server processes = 1

PARALLEL_MAX_SERVERS =16

max-connections = ?????????????

Since this was running fine i think problem lies somewhere else and not in parameters .. This was working before ..

ashish

stefan_koehler
Active Contributor
0 Kudos

Hello Ashish,

> SQL> show parameter processes

> ORA-01012: not logged on

What is this? Please post the query results .. it seems like you was not successfully logged on to the database instance.

> Since this was running fine i think problem lies somewhere else and not in parameters .. This was working before ..

Yeah, but maybe something went wrong in your system or some processes are still hanging on the database. To verify the limits and the actual number of processes .. we need the query results from above.

To check the maximum number of simultaneous user processes on HP-UX - please perform these commands and post the output.


shell> kmtune -q maxuprc -l
shell> ps -fu ora<SID> | wc -l

Regards

Stefan

sunny_pahuja2
Active Contributor
0 Kudos

Hi,

If it is not allowing you to login to your database then do one thing:

Stop the SAP system and the start again but check when you are stopping the system all processes should be killed so that there will be no hanging process.

Go to brtools and from there change the parameter.

Thanks

Sunny

former_member204746
Active Contributor
0 Kudos

some external tools might be using other sessions. BRBACKUP, BRARCHIVE, SAPDBA and many others might use more sessions. so, please follow SAP note 830576 and increase value from 80 tio a higher value.

stefan_koehler
Active Contributor
0 Kudos

Hello Ashish,

on which platform is your JAVA system running?

I don't know how it works on windows, but on Unix you maybe reached the OS limit of user processes.

Please also post the output of the following commands


shell> sqlplus / as sysdba
SQL> show parameter processes
SQL> select count(*) from V$PROCESS;

Regards

Stefan

ashish_vikas
Active Contributor
0 Kudos

Hello Stephan !

Yeah its running on HP UX :

$#*&@#@$:ora### 2> sqlplus "/as sysdba"

SQL*Plus: Release 10.2.0.2.0 - Production on Sat Jul 4 14:01:31 2009

Copyright (c) 1982, 2005, Oracle. All Rights Reserved.

Connected.

SQL> show parameter processes

ORA-01012: not logged on

SQL> select count(*) from V$PROCESS;

select count(*) from V$PROCESS

*

ERROR at line 1:

ORA-01012: not logged on

ashish