DB13 does not execute any activity.

[Former Member]

GOOD DAY

When I try to execute a UpdateStats, VerifyDB, CheckDB or an CleanupLogs from the TX DB13, in the calendar the status never change to in process, cancelled or completed, in the sm37 I see that the job is started but when I visualize the job log, it says:

Job log overview for job: DBA:CHECKDB_________@131244/2000 / 13124501

Job started

Step 001 started (program RSDBAJOB, variant &0000000000020, user ID ADMINSAP)

Execute logical command BRCONNECT On host SRMSAP00

Parameters: -u / -jid CHECK20060711131244 -c -f check

BR0801I BRCONNECT 7.00 (12)

BR0252W Function fopen() failed for 'd:\oracle\gr3\101\bin\oracle.key' at location ora_key_get-1

BR0253W errno 13: Permission denied

BR0806I End of BRCONNECT processing: cdtaiftl.log2006-07-11 13.12.45

BR0280I BRCONNECT time stamp: 2006-07-11 13.12.45

BR0804I BRCONNECT terminated with errors

External program terminated with exit code 3

BRCONNECT returned error status E

Job finished

After I check the log of the job I go to the st11 to see the trace logs. And I find that:

DEV_W11

******************************************************

L Tue Jul 11 14:04:41 2006

L *** ERROR => BtcAuthSet: dy_signi-call failed, rc: 1 [btcjcntl.c 1000]

M ***LOG R68=> ThIRollBack, roll back () [thxxhead.c 12988]

dev_xpg

*********************************************************

Trace file of External Program (trace level 3)

< Function: BtcTrcInit> Function: BtcXpgStart External program: brconnect -u / -jid CHECK20060711131244 -c -f check

dev_CP

*********************************************************

BR0280I BRCONNECT time stamp: 2006-07-11 13.12.45

< Function: BtcXpgLog > Function: BtcXpgLog Log message (40 byte): BR0804I BRCONNECT terminated with errors

< Function: BtcXpgLog Process executing external program has terminated

< Function: BtcXpgReadChild > Function: BtcXpgEnd > Function: BtcXpgLog Log message (44 byte): External program terminated with exit code 3

< Function: BtcXpgLog < Function: BtcXpgEnd Termination status of external program: program terminated with error code 3

StdOut/StdErr collected in memory

Line Text

1 BR0801I BRCONNECT 7.00 (12)

2 BR0252W Function fopen() failed for 'd:\oracle\gr3\101\bin\oracle.key' at location ora_key_get-1

3 BR0253W errno 13: Permission denied

4

5 BR0806I End of BRCONNECT processing: cdtaiftl.log 2006-07-11 13.12.45

6 BR0280I BRCONNECT time stamp: 2006-07-11 13.12.45

7 BR0804I BRCONNECT terminated with errors

8 External program terminated with exit code 3

< Function: BtcXpgEndXpgInt > Function: BtcXpgEndXpgExport > Function: BtcXpgParam < Function: BtcXpgParam > Function: BtcXpgParam < Function: Bt

2006-07-11 13-12-45 : End of BtcXpgEndXpg

< Function: BtcXpgEndXpg

2006-07-11 13-12-45 : After second call of RFCDispatch

2006-07-11 13-12-45 : After call of RfcClose (wait)

< Function: main

2006-07-11 13-12-45 : End of SAPXPG: main

ANYBODY HAS AN IDEA OF WHAT IS THE PROBLEM??

Regards

Henry

[Former Member]

Hello

I applied the dba_role.sql and the problem was no entirily solved, the job of the BRCONNECT, in sm37 change and after that it says

Execute logical command BRCONNECT On host GRAMSAP03

Parameters: -u / -jid CHECK20060713113408 -c -f check

BR0801I BRCONNECT 7.00 (11)

BR0252E Function CreateFile() failed for 'D:\oracle\GR3\101\BIN\SQLPLUS.EXE' at location BrFileStatGet-2

BR0253E errno 5: Access is denied.

BR0273E Determination of file status for D:\oracle\GR3\101\BIN\SQLPLUS.EXE failed

Process died with exitcode -1066598274

Job finished

I went to the file SQLPLUS.exe and add the user <sid>adm to the tab security in properties, and the log change to another file, and after doing that with other two files. this error appear:

Job started

Step 001 started (program RSDBAJOB, variant &0000000000020, user ID ADMINM)

Execute logical command BRCONNECT On host SAPNW0403

Parameters: -u / -jid CHECK20060713152357 -c -f check

BR0801I BRCONNECT 7.00 (11)

BR0999E Loading of SQL client library orasql10.dll failed - please check Oracle configuration

BR0310E Connect to database instance GR3 failed

BR0806I End of BRCONNECT processing: cdtasnak.log2006-07-13 15.23.59

BR0280I BRCONNECT time stamp: 2006-07-13 15.23.59

BR0804I BRCONNECT terminated with errors

External program terminated with exit code 3

BRCONNECT returned error status E

Job finished

I`m thinking that may it will be good to install the new oracle patchset 10.1.0.5??

Regards

Henry

[Former Member]

Henry,

It seems to be a cause of incorrect authorizations/roles. Please check the following two methods

1)Make sure that directory or executables like SAPDBA,

BRBACKUP, BRARCHIVE, BRRESTORE, BRRECOVER, BRCONNECT

and BRTOOLS have correct authorizations

Please refer the snote: 113747.

2)Run the sapdaba role to update the proper authorizations

Oracle 10g: sqlplus /nolog @sapdba_role <SID>

you can get it from \usr\sap\<SID>\SYS\exe\run folder

Please let me know the outcome.

Thanks,

Mohan