on 07-04-2009 2:46 PM
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
Increase the value of processes and session as per,
SAP Note 34432 - ORA-00020: maximum number of processes exceeded
Regards
Juan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Increase the parameters 'processes' and 'sessions' by 50% in the profile /oracle/<SID>/dbs/init<SID>.ora.
Regards,
Sachin Rane.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.