on 02-20-2014 4:58 AM
Hello Expert,
Recently we updated our kernel to 720_EXT of patch 500. After upgrade we found that from DB13 no jobs are running and giving error as below:
Job started
Step 001 started (program RSDBAJOB, variant &0000000000208, user ID )
Execute logical command BRCONNECT On host
Parameters: -jid STATS20140220090543 -u / -c -f stats -t ALL
exec(): 0509-036 Cannot load program brconnect because of the following errors:
0509-150 Dependent module libclntsh.a(shr.o) could not be loaded.
0509-022 Cannot load module libclntsh.a(shr.o).
0509-026 System error: A file or directory in the path name does not exist.
External program terminated with exit code 255
BRCONNECT returned error status E
Job finished
Previously every thing was working perfect.
We are using ERP 6.0 EHP5, ORACLE 11.2, oracle client 11.2 and AIX 6.1
Kindly suggest.
Regards,
Tarun
Dear All,
Thanks for all you support. Problem has been solved.
Problem was we had installed oracle client 11.2 at path of /oracle/client/10x_64.
So if we installed new kernel (in our case 720_ext) 11.2 client must be at path of /oracle/client/11x_64.
This is hard coded.
I again installed same client at path 11x_64 and problem solved.
Tarun
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello
The problem is with the Oracle Instant Client configuration on the server.
LIBPATH=/sapmnt/SID/exe:/usr/sap/SID/SYS/exe/run:/oracle/SID/112_64/lib
The LIBPATH doesn't have the Oracle client installation reference.
Expected LIBPATH:
LIBPATH=/sapmnt/SID/exe:/usr/sap/SID/SYS/exe/run:/oracle/SID/112_64/lib:/oracle/client/11x_64/instantclient
ldd brconnect
brconnect needs:
/usr/lib/libc.a(shr_64.o)
/usr/lib/libpthreads.a(shr_xpg5_64.o)
/usr/lib/libC.a(ansi_64.o)
/usr/lib/libC.a(shr_64.o)
/oracle/SID/112_64/lib/libclntsh.a(shr.o)
The LDD command reads the libclntsh.a from the /oracle/SID/112_64/lib directory. It should be reading it from the /oracle/client/11x_64/instantclient location.
If you have installed the Oracle Instant Client then adapt the environment variables of the sidadm user.
If the Oracle Instant Client is not yet installed then follow this SAP note and set it up.
819829 - Oracle Instant Client Installation and Configuration on Unix
Regards
RB
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Tarun,
Have you followed SAP notes which i mentioned earlier to you.
1553301 - 7.20 EXT Kernel - Usage
1780629 - AIX: Minimal OS Requirements for SAP Kernel
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Please attach output of ldd brconnect command (run it as <sid>adm user). Check LIBPATH for <sid>adm user: it must contain path to oracle instant client.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
HI
Below is path:
LIBPATH=/sapmnt/SID/exe:/usr/sap/SID/SYS/exe/run:/oracle/SID/112_64/lib
AND
ldd brconnect
brconnect needs:
/usr/lib/libc.a(shr_64.o)
/usr/lib/libpthreads.a(shr_xpg5_64.o)
/usr/lib/libC.a(ansi_64.o)
/usr/lib/libC.a(shr_64.o)
/oracle/SID/112_64/lib/libclntsh.a(shr.o)
/unix
/usr/lib/libcrypt.a(shr_64.o)
/usr/lib/libC.a(shr3_64.o)
/usr/lib/libC.a(shr2_64.o)
/usr/lib/libC.a(shrcore_64.o)
/usr/lib/libC.a(ansicore_64.o)
/usr/lib/libdl.a(shr_64.o)
/usr/lib/libperfstat.a(shr_64.o)
/usr/lib/libodm.a(shr_64.o)
/usr/lib/libc.a(aio_64.o)
/usr/lib/libcfg.a(shr_64.o)
/usr/lib/liblvm.a(shr_64.o)
/usr/lib/libcorcfg.a(shr_64.o)
/usr/lib/libsrc.a(shr_64.o)
HI
below is env details:
USER=sidadm
LOGNAME=sidadm
LOGIN=sidadm
HOME=/home/sidadm
PATH=/oracle/SID/112_64/bin:/usr/java14_64/bin:.:/home/sidadm:/usr/sap/SID/SYS/exe/runU:/usr/sap/SID/SYS/exe/run:/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:/usr/java14/jre/bin:/usr/java14/bin
MAIL=/var/spool/mail/sidadm
SHELL=/bin/csh
TZ=IST-5:30:00
SSH_CLIENT=10.53.3.7 51160 22
SSH_CONNECTION=10.53.3.7 51160 22
SSH_TTY=/dev/pts/0
TERM=xterm
AUTHSTATE=compat
LANG=en_US
LOCPATH=/usr/lib/nls/loc
LC__FASTMSG=true
ODMDIR=/etc/objrepos
SAPSYSTEMNAME=SID
DIR_LIBRARY=/usr/sap/SID/SYS/exe/run
SECUDIR=/usr/sap/SID/DVEBMGS00/sec
JAVA_HOME=/usr/java14_64
IBM_JAVA_OPTIONS=-Xmx256M -Xj9
THREAD=NOPS
dbms_type=ORA
dbs_ora_tnsname=SID
dbs_ora_schema=SAPSID
ORACLE_PSRV=SID
ORACLE_SID=SID
DB_SID=SID
ORACLE_HOME=/oracle/SID/112_64
ORACLE_BASE=/oracle
ORA_NLS10=/oracle/SID/112_64/nls/data
NLS_LANG=AMERICAN_AMERICA.WE8DEC
SAPDATA_HOME=/oracle/SID
NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/%L/%N.cat
LIBPATH=/sapmnt/SID/exe:/usr/sap/SID/SYS/exe/run:/oracle/SID/112_64/lib
Hi Tarun,
Last i would like to suggest you to through these two SAP Note as per your environment.
1553301 - 7.20 EXT Kernel - Usage
1780629 - AIX: Minimal OS Requirements for SAP Kernel
Will help you to resolve the issue.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Tarun,
Please navigate with link Real Life Sysadmin: Dependent module libclntsh.a(shr.o) could not be loaded
Hope this document will help you in resolution.
Regards,
Gaurav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Share the version of your brtools by using command brtools -V.This issue relates with version of brtools as well as with brconnect.So i recommend you to please follow SAP note 1430669.
Regards,
Gaurav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
belwo is brtools version:
brtools -V
BR0651I BRTOOLS 7.20 (35)
Patch Date Info
1 2010-01-26 BR*Tools support for Oracle 11g (note 1430669)
9 2010-10-27 BR*Tools support for eSourcing databases (note 1523205)
18 2011-09-07 BR*Tools support for Oracle ASM and Exadata (note 1627541)
25 2012-06-28 Corrections in BR*Tools 7.20 patch 25 (note 1735811)
26 2012-09-12 Corrections in BR*Tools 7.20 patch 26 (note 1763972)
27 2012-09-12 Support for secure storage in BR*Tools (note 1764043)
28 2012-10-25 Corrections in BR*Tools 7.20 patch 28 (note 1780057)
29 2012-12-03 Corrections in BR*Tools 7.20 patch 29 (note 1795814)
30 2013-01-31 Corrections in BR*Tools 7.20 patch 30 (note 1816874)
31 2013-03-26 Corrections in BR*Tools 7.20 patch 31 (note 1838852)
32 2013-05-28 Corrections in BR*Tools 7.20 patch 32 (note 1865897)
33 2013-07-03 Corrections in BR*Tools 7.20 patch 33 (note 1882181)
34 2013-09-05 Corrections in BR*Tools 7.20 patch 34 (note 1909451)
35 2013-11-14 Corrections in BR*Tools 7.20 patch 35 (note 1940675)
release note 1428529
kernel release 720
patch date 2013-11-14
patch level 35
make platform rs6000_64
make codeline 720_EXT_REL
make mode OCI_112
make date Nov 20 2013
Hi,
Did you try with new latest DBA tools?
Regards,
Nick Loy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
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.