on 02-26-2009 1:07 PM
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
After kill tp able to run Archival backup.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
> 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
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
> 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
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
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.