brconnect: error while loading shared libraries

[Former Member]

Hi Friends,

I have upgraded my DB from 10.2.0.4.0 to 11.2.0.3.0 (directly).

SAP ECC 6.0 OS- Suse Linux11

Upgrade is success and Application is up.

DB13 when i run Update Stats and Check DB i get error

brconnect: error while loading shared libraries: libclntsh.so.10.1: cannot open shared object file:No such file or directory

##############################

I have maintained the below soft link

pagejd:/oracle/JID/11203/lib

libclntsh.so.10.1 -> /oracle/JID/11203/lib/libclntsh.so

libclntsh.so -> libclntsh.so.11.1

libnnz10.so -> libnnz11.so

#########################

oraSID

env

LD_LIBRARY_PATH=/usr/sap/JID/SYS/exe/run:/oracle/JID/11203/lib

#########################

SIDadm

env

LD_LIBRARY_PATH=/usr/sap/JID/SYS/exe/run:/oracle/client/11x_64/instantclient

#######################

old oracle client

pagejd:/oracle/client/10x_64 # ls -ltr

total 4

dr-xr-xr-x 2 jidadm sapsys 280 Mar 27  2006 instantclient_10202

-rwxrwxr-x 1 jidadm sapsys  33 Mar 27  2006 dbclient.lst

###################

pagejd:/oracle/client/11x_64 # ls -ltr

total 4

drwxr-xr-x 2 jidadm sapsys 440 Nov 26  2010 instantclient_11202

-rwxr-xr-x 1 jidadm sapsys 153 Nov 26  2010 dbclient.lst

lrwxrwxrwx 1 jidadm sapsys  19 Mar 20 20:22 instantclient -> instantclient_11202

###############

Kernel 700 relese patch 315

##########

Please help me to solve this issue and any corrections on the above settings.

Thanks,

Hari

[Former Member · Accepted solution]

Hi,

Execute "relink all"  under lib directory.

I did the same to resolve my issue following upgrade.

It gives some errors during relinking, but we can ignore them.

Regards,

Venkata S Pagolu.

[Former Member · Accepted solution]

Hi Venkat,

relink all command run without errors.

But still i get the same error from DB13.

But i can run the same in Brtools.

[Former Member · Accepted solution]

Hi,

Have you gone through this threads

http://scn.sap.com/thread/1975471

http://scn.sap.com/thread/913153

check this as well

http://www.dbforums.com/oracle/1645097-listener-error-error-while-loading-shared-libraries-libclntsh...

Regards,

Venkata S Pagolu.

[Former Member · Accepted solution]

Dear Friend

Kindly check whether  permission for ORA<SID> & SAP<SID> are same for the soft link location

[Former Member · Accepted solution]

Hi Venkat,

should i use only oracle 10 client for release 700 as per Br-tools for 11g.

i have oracle 11 client .Is this giving problem as per snote 849483,1449619.

please clarify.

[Former Member · Accepted solution]

Hi,

According to note 1449619, your issue is described in problem No:1

According to that you need to apply below note.

Note 1638356 - Additional information about BR*Tools Version 7.20 EXT

you are checking for solution of problem no:2 which is not relevant for your issue.

Regards,

Venkata S Pagolu.

[Former Member · Accepted solution]

Hi Shahnas,

No. I dont have same owner .

Under oracle_home/lib the soft link is orasid

Under oracle/client/11x_64 - sidadm

         oracle/client/10x_64 - sidadm

what should be maintained to correct this.please clarify.

Thanks.

[Former Member · Accepted solution]

Hi,

my release is 700

pagejd:orajid 51> brtools -V

release note	849483
kernel release	700
patch date	2011-03-02
patch level	52
make platform	linuxx86_64
make mode	OCI_102
make date	Mar  4 2011

You mean i shud go with 7.20 ext.

please clarify.

thanks

[Former Member · Accepted solution]

Hi,

Yes.. Note recommends to do that for resolution.

Regards,

Venkata S Pagolu.

[Former Member · Accepted solution]

Hi Venkat,

brtools 7.20_EXT works.

Issue resolved.

Thanks for your time.

[Former Member]

By changing the ownership & permission of the brtools binaries in /sapmnt/<sid>/exe solved my issue. Appreciate this thread.

[former_member503993]

It solve my problem too.

When I check br files on '/sapmnt/<SID>/exe/uc/linuxx86_64/' (brconnect , brbackup, brarchive),

those owner was ora<db sid>.

after change owner of those to <sid>adm, this error disappered.

(yet have some other error)

[Former Member]

This might be the issue with permission for the file,Please check the permission one more time,for the soft link