/usr/sap/GMR/SYS/exe/run/brconnect: error while loading shared libraries: libclntsh.so.11.1: cannot open shared object file: No such file or directory

[former_member686472]

Dear All ,

I am installing SAP Netviwer 7.2 on oracle 10.2 in Suse linux , but at the time of stage -perform ora post activity i a getting a error like  "/usr/sap/GMR/SYS/exe/run/brconnect: error while loading shared libraries: libclntsh.so.11.1: cannot open shared object file: No such file or directory" this is brconnect log .

If any one know the solution of the problem Please let me knw

Thanks & Regards

Arpit

[Former Member]

Check that you have correctly installed Oracle instant client and environment variables are set. For this start with 819829 - Oracle Instant Client Installation and Configuration on Unix.

[former_member686472]

Dear Roman ,

I a using latest one oracle client  and i am at post ora load activity , so i cant change again oracle client otherwise i need to start from scratch level again any way to resolve issue without change any thing

[Former Member]

Please provide:

1) environment variables for <sid>adm user;

2) version of brtools used;

3) oracle instant client installed.

[former_member686472]

Hi ,

Please find env of SIDADM.

TERM=xterm

HOME=/home/gmradm

SHELL=/bin/csh

USER=gmradm

LOGNAME=gmradm

PATH=/oracle/GMR/102_64/bin:/home/gmradm/bin:/usr/local/bin:/bin:/usr/bin:/usr/bin/X11:/usr/X11R6/bin:/usr/games:/usr/lib/mit/bin:/usr/lib/mit/sbin:/usr/sap/GMR/SYS/exe/uc/linuxx86_64:/usr/sap/GMR/SYS/exe/run:/home/gmradm:.

HOSTTYPE=x86_64

VENDOR=suse

OSTYPE=linux

MACHTYPE=x86_64-suse-linux

SHLVL=1

PWD=/home/gmradm

GROUP=sapsys

HOST=PRDSYSTEM

CSHEDIT=emacs

MAIL=/var/spool/mail/gmradm

CPU=x86_64

HOSTNAME=PRDSYSTEM.

INPUTRC=/etc/inputrc

LESS=-M -I

LESSOPEN=lessopen.sh %s

LESSCLOSE=lessclose.sh %s %s

LESS_ADVANCED_PREPROCESSOR=no

LESSKEY=/etc/lesskey.bin

PAGER=less

MORE=-sl

MINICOM=-c on

MANPATH=/usr/local/man:/usr/share/man

INFODIR=/usr/local/info:/usr/share/info:/usr/info

INFOPATH=/usr/local/info:/usr/share/info:/usr/info

XKEYSYMDB=/usr/share/X11/XKeysymDB

XNLSPATH=/usr/share/X11/nls

COLORTERM=1

JAVA_BINDIR=/usr/lib64/jvm/java/bin

JAVA_ROOT=/usr/lib64/jvm/java

JAVA_HOME=/usr/lib64/jvm/java

JRE_HOME=/usr/lib64/jvm/java/jre

JDK_HOME=/usr/lib64/jvm/java

SDK_HOME=/usr/lib64/jvm/java

CVS_RSH=ssh

XCURSOR_THEME=DMZ

QT_HOME_DIR=/usr/share/desktop-data

LANG=en_US.UTF-8

ORACLE_BASE=/oracle

ORACLE_HOME=/oracle/GMR/102_64

ORACLE_SID=GMR

ORA_CRS_HOME=/opt/oracle/product/11gR1/crs

ORA_ASM_HOME=/opt/oracle/product/11gR1/asm

FROM_HEADER=

NNTPSERVER=news

WINDOWMANAGER=/usr/bin/gnome

PYTHONSTARTUP=/etc/pythonstart

XDG_DATA_DIRS=/usr/local/share:/usr/share:/etc/opt/kde3/share:/opt/kde3/share:/usr/share/gnome/help

XDG_CONFIG_DIRS=/etc/xdg

G_BROKEN_FILENAMES=1

G_FILENAME_ENCODING=@locale,UTF-8,ISO-8859-1,CP1252

ENV=/etc/bash.bashrc

CSHRCREAD=true

LS_COLORS=no=00:fi=00:di=01;34:ln=00;36:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=41;33;01:ex=00;32:*.cmd=00;32:*.exe=01;32:*.com=01;32:*.bat=01;32:*.btm=01;32:*.dll=01;32:*.tar=00;31:*.tbz=00;31:*.tgz=00;31:*.rpm=00;31:*.deb=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.lzma=00;31:*.zip=00;31:*.zoo=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.tb2=00;31:*.tz2=00;31:*.tbz2=00;31:*.avi=01;35:*.bmp=01;35:*.fli=01;35:*.gif=01;35:*.jpg=01;35:*.jpeg=01;35:*.mng=01;35:*.mov=01;35:*.mpg=01;35:*.pcx=01;35:*.pbm=01;35:*.pgm=01;35:*.png=01;35:*.ppm=01;35:*.tga=01;35:*.tif=01;35:*.xbm=01;35:*.xpm=01;35:*.dl=01;35:*.gl=01;35:*.wmv=01;35:*.aiff=00;32:*.au=00;32:*.mid=00;32:*.mp3=00;32:*.ogg=00;32:*.voc=00;32:*.wav=00;32:

LS_OPTIONS=-N --color=tty -T 0

SAPSYSTEMNAME=GMR

DIR_LIBRARY=/usr/sap/GMR/SYS/exe/run

RSEC_SSFS_DATAPATH=/usr/sap/GMR/SYS/global/security/rsecssfs/data

RSEC_SSFS_KEYPATH=/usr/sap/GMR/SYS/global/security/rsecssfs/key

rsdb_ssfs_connect=0

LD_LIBRARY_PATH=/usr/sap/GMR/SYS/exe/run:/usr/sap/GMR/SYS/exe/uc/linuxx86_64:/oracle/client/10x_64/instantclient

SAPEXE=/usr/sap/GMR/SYS/exe/run

THREAD=NOPS

DB_SID=GMR

dbms_type=ORA

dbs_ora_tnsname=GMR

dbs_ora_schema=SAPGMR

TNS_ADMIN=/usr/sap/GMR/SYS/profile/oracle

NLS_LANG=AMERICAN_AMERICA.UTF8

SAPDATA_HOME=/oracle/GMR

2 ) Version of Brtools :-

oragmr> brtools -V

BR0651I BRTOOLS 7.20 (17)

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)

release note               1428529

kernel release             720

patch date                 2011-08-26

patch level                17

make platform              linuxx86_64

make mode                  OCI_112

make date                  Sep  3 2011

3 ) Oracle client Version :-

instantclient_10202

[Former Member]

Please attach output of commands:

1) ls -l /oracle/client/10x_64/instantclient

2) ldd brconnect (as <sid>adm user)

[former_member686472]

Dear Roman ,

Please find Attached output of command .

1)

lrwxrwxrwx 1 gmradm sapsys 41 Oct 14 12:44 /oracle/client/10x_64/instantclient -> /oracle/client/10x_64/instantclient_10202

2)

PRDSYSTEM:~/Desktop # su - gmradm

PRDSYSTEM:gmradm 5>  ldd brconnect

ldd: ./brconnect: No such file or directory

[Former Member]

Please run the following commands:

1) ls -l /oracle/client/10x_64/instantclient/

2) ldd `which brconnect`

[former_member686472]

Dear Roman ,

I have executed following command , output is below

1)

PRDSYSTEM:gmradm 11> ls -l /oracle/client/10x_64/instantclient/

total 97356

-rwxrwxrwx 1 oragmr dba  1593906 Feb 24  2006 classes12.jar

-rwxrwxrwx 1 oragmr dba 20653721 Feb 24  2006 libclntsh.so.10.1

-rwxrwxrwx 1 oragmr dba  3804313 Feb 24  2006 libnnz10.so

-rwxrwxrwx 1 oragmr dba  1664148 Feb 24  2006 libocci.so.10.1

-rwxrwxrwx 1 oragmr dba 70161719 Feb 24  2006 libociei.so

-rwxrwxrwx 1 oragmr dba   137777 Feb 24  2006 libocijdbc10.so

-rwxrwxrwx 1 oragmr dba  1540330 Feb 24  2006 ojdbc14.jar

2)

PRDSYSTEM:gmradm 12> ldd `which brconnect`

    linux-vdso.so.1 =>  (0x00007fffcd9ff000)

    libdl.so.2 => /lib64/libdl.so.2 (0x00007f00067ad000)

    librt.so.1 => /lib64/librt.so.1 (0x00007f00065a3000)

    libclntsh.so.11.1 => not found

    libpthread.so.0 => /lib64/libpthread.so.0 (0x00007f0006386000)

    libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x00007f000607b000)

    libm.so.6 => /lib64/libm.so.6 (0x00007f0005e02000)

    libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007f0005bec000)

    libc.so.6 => /lib64/libc.so.6 (0x00007f0005877000)

    /lib64/ld-linux-x86-64.so.2 (0x00007f00069e4000)

[Former Member]

You have installed brtools 7.20_EXT version which requires Oracle instant client 11.2. Please install Oracle instant client 11.2 and adjust environment to use it or install brtools 7.20.

[former_member686472]

Dear Roman ,

Problem is solved , i have installed oracle instance client rpm package for linux , now its working

Thanks for your support .

[divyanshu_srivastava3]

Is Oracle Up and running ?

[former_member686472]

Yes dear oracle and listener is up and running and i had changed BRtools files as well with latest one but i am getting same error .

[divyanshu_srivastava3]

Run the Oracle permission scripts again.

Regards,

[former_member686472]

I have executed ora permission script again but same error again .

[divyanshu_srivastava3]

Look at what Roman has suggest.

Also, share relevant log files