In DBA Planning Calendar CheckDB Job Failed

[Former Member]

Hello Guru's

In our Test Server DBA calendar jobs are frequently failing since yesterday , I am attaching the log for your reference

Job started

Step 001 started (program RSDBAJOB, variant &0000000000397, user ID CSCADMIN)

Execute logical command BRCONNECT On host bascop26

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

SXPG_COMMAND_EXECUTE(LONG)

COMMANDNAME = BRCONNECT

OPERATINGSYSTEM = ANYOS

TARGETSYSTEM = bascop26

DESTINATION =

BR0801I BRCONNECT 7.00 (33)

exec(): 0509-036 Cannot load program oracleQBW because of the following errors:

#0509-150 Dependent module libjox10.a(shr.o) could not be loaded.

#0509-022 Cannot load module libjox10.a(shr.o).

#0509-026 System error: A file or directory in the path name does not exist.

BR0805I Start of BRCONNECT processing: ceaawqqt.chk 2009-03-03 07.17.07

BR0484I BRCONNECT log file: /oracle/QBW/sapcheck/ceaawqqt.chk

exec(): 0509-036 Cannot load program oracleQBW because of the following errors:

#0509-150 Dependent module libjox10.a(shr.o) could not be loaded.

#0509-022 Cannot load module libjox10.a(shr.o).

#0509-026 System error: A file or directory in the path name does not exist.

BR0280I BRCONNECT time stamp: 2009-03-03 07.17.07

BR0301E SQL error -12547 at location db_connect-2, SQL statement:

'CONNECT /'

ORA-12547: TNS:lost contact

BR0310E Connect to database instance QBW failed

exec(): 0509-036 Cannot load program oracleQBW because of the following errors:

#0509-150 Dependent module libjox10.a(shr.o) could not be loaded.

#0509-022 Cannot load module libjox10.a(shr.o).

#0509-026 System error: A file or directory in the path name does not exist.

BR0280I BRCONNECT time stamp: 2009-03-03 07.17.07

BR0301E SQL error -12547 at location db_connect-2, SQL statement:

'CONNECT /'

ORA-12547: TNS:lost contact

BR0310E Connect to database instance QBW failed

BR0806I End of BRCONNECT processing: ceaawqqt.chk2009-03-03 07.17.07

BR0280I BRCONNECT time stamp: 2009-03-03 07.17.07

BR0804I BRCONNECT terminated with errors

External program terminated with exit code 3

BRCONNECT returned error status E

Job finished

Please guide me to resolve the issue

[Former Member · Accepted solution]

Hello,

Library resolution problems can be real pain in the neck, so you'll need to tackle this systematically:

1) Verify that the oracle executable has the set-user-ID bit set:

cd /oracle/QBW/102_64/bin
ls -l oracle
--> access mask shoule be "rws..." not "rwx"
-rwsr-s--x   ...

If this is not the case, then execute the command "chmod 6755 oracle" as user oraqbw or root

2) Check that the library libjox10.a exists; normally it is in /oracle/QBW/102_64/lib.

3) Make sure that (a) oraqbw has read access to libjox10.a, and (b) libjox10.a is in the library path of oraqbw (the library path is in the environment variable LIBPATH on AIX, SHLIB_PATH on pre-11.11 HP-UX and LD_LIBRARY_PATH on other Unix/Linux platforms)

Try these actions first and let me know the result.

Regards,

Mark

[former_member633852]

I've the same problem, executing the following command for link oracle libs witch ora<sid> solved our problem,

relink all

Regards

Atakan

[Former Member]

Just make sure SAP and Oracle are down before you issue relink command.

Pravin