Archival failed >> maximum number of processes (%s) exceeded

[mohsin_m3]

Hello All,

Archival failed with below reason

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

'CONNECT / AT PROF_CONN IN SYSOPER MODE'

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

BR0303E Determination of Oracle version failed

BR0007I End of offline redo log processing: adzzyuqh.svd 2009-02-26 10.51.36

BR0280I BRARCHIVE time stamp: 2009-02-26 10.51.36

BR0005I BRARCHIVE terminated with errors

plaixlps010:oraas5 4>

-

---

<DB01> following entries found

TRBATS __WAIT 134 2474210 2961568 plaixlps010 506967

TRBATS __WAIT 152 2945192 2932902 plaixlps010 508628

TRBATS __WAIT 133 2494592 2777254 plaixlps010 523113

TRBATS __WAIT 138 2818232 2506802 plaixlps010 593167

-

---

-

---

se16 > TRBAT > execute > following entries found.

TRKORR FUNCTION RETCODE TIMESTMP CLIENT LANGU VARIANT ARGUMENT LOGNAME

AD5K905452 R 0 20090108144042 008 14391400 :D:T:S:tmp:F:AD5R905452.AS5

AD5K905454 R 0 20090108144043 008 14391400 :D:T:S:tmp:F:AD5R905454.AS5

HEADER R F 20090108144043

But delete button is not active??

Please help me to resolve issue

Regards

Mohsin Mulani

[mohsin_m3]

After kill tp able to run Archival backup.

[donald_voorhees]

Glad to see you are up and running again, unfortunately you still didn't solve your problem.

Follow the advice on checking the processes and sessions in the Oracle init file.

[Former Member]

Hi,

First check value of DB parameter PROCESSES & SESSION in your system . Please refer SAP note 632556 for Oracle 9i & 830576 for Oracle 10g (whichever is applicable to you) & change the value of parameter PROCESSES & SESSION.

Thanks,

Sushil

[donald_voorhees]

You likely have a default install DB w/ the processes and session set at 80/96. this is not adequate for most SAP installs that see moderate use.

You need to increase this to at least 400/480, the rule is processes=1.2*sessions I believe.

Entries in TRBAT (transports) have nothing to do with the error at hand but they are a victim of the low parameterization of the database. Check the SAP notes for the current Oracle parameters.

You can also check this by doing a "select count (*) from v$sessions;" at the DB level, it should be at or near your init file setting. No new connections to the DB will be allowed until old ones log off or die.

[Former Member]

Hi,

Error code BR0303E means:-

Determination of Oracle RDBMS version failed.

BR0303E Ermittlung der Oracle RDBMS Version gescheitert.

Explanation: Before the database is accessed, SQLDBA determines the ORACLE version. This operation failed.

Program reaction: Processing terminates.

User action: Take into account any ORACLE error messages.

Here Oracle message is ORA-00020. Please check value of DB parameters PROCESSES & SESSIONS for your system & set it as per standard SAP note (e.g.sapnote 830576 for Oracle 10g)

You need to restart the DB once you change this parameter. Also see below SAP notes

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

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

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

If you have tried to change spfile then please check SAP note 917293 - BR*Tools fail with ORA-27046 at BrInitOraCreate-3.

Refer SAP Note 17163 - BRARCHIVE/BRBACKUP messages and codes for any BR*Tools related errors/warnings.

Hope this helps.

Thanks,

Sushil

[markus_doehr2]

I have no clue what you are trying to do... deleting a transport out of TRBAT won't free Oracle processes...

You may have to increase the PROCESSES parameter instead...

Markus

[mohsin_m3]

I have tried to run BRconnect and brarchival but got failed with error

maximum number of processes (%s) exceeded

I have checked in <St04> and found lot of oracle proccess are running.and found TRBAT tables

So I have checked in SE16 and found entries in that.....

regards

mohsin

[markus_doehr2]

> So I have checked in SE16 and found entries in that.....

So you think if you would delete the from SE16 would "free" the processes? Most likely there are OS processes running (tp/R3trans) that have connections to the database. I would not "kill" them but find out, why they lock the table or don't proceed...

Check in SM66 if you see anything obvious and also check the latest transport logs (/usr/sap/trans/tmp, /usr/sap/trans/log).

If you can't connect any more with brconnect you'd need to

sqlplus "/ as sysdba"
alter system set processes = <new number> scope=both;
shutdown immediate;
startup

Markus

[mohsin_m3]

I Have checked in SM66 No entries found.

ps -ef|grep -i tp lot of tp proccess are showing??

Plz help me.

Regards

Mohsin

[markus_doehr2]

> ps -ef|grep -i tp lot of tp proccess are showing??

As suggested - please check the latest logfiles in /usr/sap/trans/tmp and /usr/sap/trans/log (ls -lt | head)

Markus

[mohsin_m3]

Hello

ls-lt|head

more SLOG0908.AS5

WARNING: /usr/sap/apotrans/tmp/AS5.LOB is already in use (200), I'm waiting 1 sec (20090226130731). My name: pid 2646024 on pl

aixlps010 (as5adm)

WARNING: /usr/sap/apotrans/tmp/AS5.LOB is already in use (210), I'm waiting 2 sec (20090226130755). My name: pid 2646024 on pl

aixlps010 (as5adm)

Regards

Mohsin Mulani

[markus_doehr2]

> WARNING: /usr/sap/apotrans/tmp/AS5.LOB is already in use (200), I'm waiting 1 sec (20090226130731). My name: pid 2646024 on pl

> aixlps010 (as5adm)

>

> WARNING: /usr/sap/apotrans/tmp/AS5.LOB is already in use (210), I'm waiting 2 sec (20090226130755). My name: pid 2646024 on pl

> aixlps010 (as5adm)

one transport is blocking the file. I'd check on /usr/sap/apotrans/tmp in the logfile of the running transports, which PID is locking the file.

Markus

[mohsin_m3]

Can u plz help me for further action??

plaixlps010:as5adm 24> cd ../tmp

plaixlps010:as5adm 25> ls -lt|head

total 11536

-rw-rw-r-- 1 as5adm sapsys 36 Feb 26 12:51 AS5.LOB

-rw-rw---- 1 7118 sapsys 37 Jan 17 10:26 TMS_TEST.AQ5

-rw-rw-r-- 1 as5adm sapsys 36 Jan 12 16:32 AS5.LOB_130109

-rw-rw-r-- 1 as5adm sapsys 36 Jan 12 15:06 AS5.LOB.old

-rw-rw---- 1 as5adm sapsys 2148 Jan 08 14:40 AD5R905454.AS5

-rw-rw---- 1 7125 sapsys 37 Jul 24 2008 TMS_TEST.GA5

-rw-rw---- 1 7125 sapsys 278097 Jul 12 2008 SAPRUPGM.AP5

-rw-rw---- 1 7125 sapsys 134756 Jul 12 2008 AMODPROT.AP5

-rw-rw---- 1 7125 sapsys 7811 Jul 12 2008 CMODACT.AP5

plaixlps010:as5adm 26> more AS5.LOB

pid 2429128 on plaixlps010 (as5adm)

plaixlps010:as5adm 27> pwd

/usr/sap/apotrans/tmp

-

---

plaixlps010:as5adm 29> ls -lt|head

total 14335672

-rw-rw-r-- 1 as5adm sapsys 24160 Feb 26 15:07 SLOG0909.AS5

-rw-rw-r-- 1 7118 sapsys 26041 Feb 26 15:07 SLOG0909.AQ5

-rw-rw-r-- 1 7118 sapsys 6050 Feb 26 14:26 ALOG0909.AQ5

-rw-rw-r-- 1 7118 sapsys 57820 Feb 26 14:26 AD5I905781.AQ5

-rw-rw-r-- 1 7118 sapsys 15416 Feb 26 14:26 P090226.AQ5

-rw-rw-r-- 1 7104 sapsys 423928 Feb 26 14:26 ULOG09_1

-rw-rw-r-- 1 as5adm sapsys 17617 Feb 26 13:07 SLOG0908.AS5

-rw-rw-r-- 1 as5adm sapsys 7225 Feb 26 12:51 AD5R905452.AS5

-rw-rw-r-- 1 as5adm sapsys 24528 Feb 26 12:51 SLOG0906.AS5

plaixlps010:as5adm 30>

plaixlps010:as5adm 30> pwd

/usr/sap/apotrans/log

-

---

I have rename this file plaixlps010:as5adm 61> mv AS5.LOB AS5.LOB.260209

plaixlps010:as5adm 61> pwd

/usr/sap/apotrans/tmp

Edited by: mohsin m on Feb 26, 2009 3:56 PM