cancel
Showing results for 
Search instead for 
Did you mean: 

brconnect work with ora<SID> but not with <sid>adm - libclntsh.so.11.1: cannot open shared object file : No such file or directory

Former Member
0 Kudos

Hi,

i did a Upgrade of Linux (SLES10 -> SLES11) and Oracle (10.2.xx -> 11.2.0.3).

Now i have the Problem that brconnect did not work with <sid>adm

as User: <SID>adm

brconnect

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

LD_LIBRARY_PATH=/usr/sap/<SID>/SYS/exe/run:/oracle/client/11x_64

ls -la /oracle/client/11x_64/libclntsh.so.11.1

-rw-r--r-- 1 ora<SID> dba 52761218 Sep 17  2011 /oracle/client/11x_64/libclntsh.so.11.1

ls -la /usr/sap/<SID>/SYS/exe/run/brconnect

-rwsrwxr-x 1 ora<SID> sapsys 11530700 Nov 20 20:23 /usr/sap/<SID>/SYS/exe/run/brconnect

id

uid=3214(<SID>adm) gid=200(sapsys) groups=200(sapsys),201(dba),206(oper),1000(sapinst)

But brtools works als <SID>adm

brtools

BR0651I BRTOOLS 7.20 (35)

pwd

/oracle/client/11x_64

genezi -v

Client Shared Library 64-bit - 11.2.0.3.0

System name:    Linux

Release:    3.0.76-0.11-default

Version:    #1 SMP Fri Jun 14 08:21:43 UTC 2013 (ccab990)

Machine:    x86_64

Operating in Instant Client mode.

Small timezone file = timezone_14.dat

Large timezone file = timezlrg_14.dat

cd /sapmnt/WAQ/exe

ls -la dboraslib.so

-rwxrwxr-x 1 <SID>adm sapsys 1364366 Jan 11 00:32 dboraslib.so

ldd dboraslib.so

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

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

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

    libclntsh.so.11.1 => /oracle/client/11x_64/libclntsh.so.11.1 (0x00007fea3a729000)

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

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

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

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

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

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

    libnnz11.so => /oracle/client/11x_64/libnnz11.so (0x00007fea39632000)

    libnsl.so.1 => /lib64/libnsl.so.1 (0x00007fea3941a000)

    libaio.so.1 => /lib64/libaio.so.1 (0x00007fea39217000)

ldd brconnect

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

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

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

    libclntsh.so.11.1 => /oracle/client/11x_64/libclntsh.so.11.1 (0x00007f0ce223d000)

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

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

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

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

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

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

    libnnz11.so => /oracle/client/11x_64/libnnz11.so (0x00007f0ce1146000)

    libnsl.so.1 => /lib64/libnsl.so.1 (0x00007f0ce0f2e000)

    libaio.so.1 => /lib64/libaio.so.1 (0x00007f0ce0d2b000)

als User: ora<SID>

brconnect -v

BR0801I BRCONNECT 7.20 (35)

Accepted Solutions (0)

Answers (7)

Answers (7)

anoarul_islam
Explorer
0 Kudos

Hi,

Is this issue solved !!

I have similar problem, I am doing system copy for Enterprise Portal 7.0, from PRD to Sandbox by using SWPM 1.0

Export from PRD system is done successfully by SWPM 1.0.

Now I am doing import in Sandbox system. Everything is perfect till Create database statistics..

This phase is failing due to brconnect issue. As ora<sid> I am able to run brconnect and I can create the statistics also on OS level but it is not working for <sid>adm.

OS: IBM AIX 6.1

DB: oracle 10.2.0.4, using oracle client 10x..

Error Screenshot:

hostname: <sid>adm  > brconnect

Could not load program brconnect:

        Dependent module libclntsh.a(shr.o) could not be loaded.

Could not load module libclntsh.a(shr.o).

System error: No such file or directory


As <sid>adm > env

LIBPATH=/usr/sap/SID/SYS/exe/run:/usr/sap/SID/SYS/exe/uc/rs6000_64:/oracle/client/10x_64/instantclient

and

<sid>adm 😆 ls -ltr /oracle/client/10x_64/instantclient

-rwxrwxr-x    1 pcpadm   sapsys     70110326 Feb 25 2006  libociei.so

-rwxrwxr-x    1 pcpadm   sapsys      4796980 Feb 25 2006  libnnz10.so

-rwxrwxr-x    1 pcpadm   sapsys     24077164 Feb 25 2006  libclntsh.a

-rwxrwxr-x    1 pcpadm   sapsys      5972886 Feb 25 2006  libocci.a

-rwxrwxr-x    1 pcpadm   sapsys     22795273 Feb 25 2006  libocijdbc10.so

-rwxrwxr-x    1 pcpadm   sapsys      1540330 Feb 25 2006  ojdbc14.jar

-rwxrwxr-x    1 pcpadm   sapsys      1593906 Feb 25 2006  classes12.jar

-rwxrwxr-x    1 pcpadm   sapsys     23503095 Mar 27 2006  libclntsh.so

So as per my understanding, Environment is ok and files are also exists in place...

any expert can help please....

Anoarul

anoarul_islam
Explorer
0 Kudos

Issue Resolved  !!

Brtools 7.20 is intact with oracle 11x client.

I have created a symbolic link under /oracle/client

<sid>adm: ls /oracle/client

10x

<sid>adm: ln -s 10x_64 11x_64

<sid>adm: ls /oracle/client

drwxr-xr-x    2 root     system          256 Sep 16 04:55 lost+found

lrwxrwxrwx    1 pcpadm   sapsys            6 Oct 13 04:40 11x_64 -> 10x_64

drwxrwxr-x    3 pcpadm   sapsys          256 Oct 13 04:40 10x_64

Now it is working..

Former Member
0 Kudos

I can confirm this, AFAIK this is the correct setup.

Former Member
0 Kudos

Solution was install/extract the instantclient 11.2.0.4 from: 51047688.ZIP
do the symlink, and all is fine

0 Kudos

Hi,

I know it sounds general, but note 819829 is the perfect answer.

Also check the permissions of instant_client. Maybe check with other systems and look for any deviations.

Since BR*Tools working perfectly with ora<sid> (and this user is the owner of instant_client directory and files) it must be a permission issue.

Try do decompress the instantclient to another directory and check the default permissions.

Regards,

János

Former Member
0 Kudos

localhost:<sid>adm 53> ldd /sapmnt/<SID>/exe/brconnect

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

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

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

libclntsh.so.11.1 => /oracle/client/11x_64/instantclient/libclntsh.so.11.1 (0x00007ffd4e78e000)

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

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

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

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

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

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

libnnz11.so => /oracle/client/11x_64/instantclient/libnnz11.so (0x00007ffd4d697000)

libnsl.so.1 => /lib64/libnsl.so.1 (0x00007ffd4d47f000)

libaio.so.1 => /lib64/libaio.so.1 (0x00007ffd4d27c000)

localhost:<sid>adm 54> brconnect

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

localhost:<sid>adm 55> ls -la /oracle/client/11x_64/instantclient/libnnz11.so

-rwxr-xr-x 1 <sid>adm sapsys 7955322 Jul  3 13:26 /oracle/client/11x_64/instantclient/libnnz11.so

localhost:<sid>adm56> ls -la /sapmnt/WAP/exe/brconnect

-rwsrwxr-- 1 ora<sid> sapsys 11530700 Nov 20  2013 /sapmnt/WAP/exe/brconnect

Former Member
0 Kudos

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

important difference between the EXT version and the standard version of BR*Tools 7.20 lies in the version of the Oracle client to which the tools are linked. The EXT version is linked to Oracle client 11g, the standard version is linked to Oracle client 10g. This means that the EXT version of BR*Tools 7.20 is designed for a "homogeneous" Oracle 11g environment: Oracle server 11g and Oracle client 11g. If this is not the case, you must use the standard version of BR*Tools 7.20.

Reagan
Advisor
Advisor
0 Kudos

localhost:<sid>adm 53> ldd /sapmnt/<SID>/exe/brconnect

libclntsh.so.11.1 => /oracle/client/11x_64/instantclient/libclntsh.so.11.1 (0x00007ffd4e78e000)

libnnz11.so => /oracle/client/11x_64/instantclient/libnnz11.so (0x00007ffd4d697000)

I see it is able to locate libnnz11.so

Try to review the symbolic links created and see if they are created correctly.

If possible supply the environment variables of orasid and sidadm users.

Regards

RB

Former Member
0 Kudos

The  /oracle/client/11x_64/instantclient/libnnz11.so & /oracle/client/11x_64/instantclient/libclntsh.so.11.1

is no symbolic link

Former Member
0 Kudos

localhost:<sid>adm 53> 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              linuxx86_64
make codeline              720_EXT_REL
make mode                  OCI_112
make date                  Nov 20 2013

Reagan
Advisor
Advisor
0 Kudos

The  /oracle/client/11x_64/instantclient/libnnz11.so & /oracle/client/11x_64/instantclient/libclntsh.so.11.1 is no symbolic link

I am aware of that.

In fact I am speaking about these symbolic links (probably more) you have created.


lrwxrwxrwx  1 root   root   21 Apr 30 10:46 instantclient -> /oracle/client/11x_64

lrwxrwxrwx  1 ora<SID> dba   6 Apr 30 11:22 10x_64 -> 11x_64

That is the only thing I can suggest without seeing your system.

I don't want to misguide you with suggestions which I am not sure of. This is the reason I asked or the output of certain commands in my previous replies.

If I were you I would modify the environment variables of the sidadm user and create the Oracle Instant Client directory in the way it is mentioned in the SAP note 819829

Good Luck

RB

Former Member
0 Kudos

OK if i do a new install from the Client v11. (with runInstaller)

to /oracle/client/instantclient_11203

then do a link in /orcle/client

ln -s instantclient_11203 instantclient

fix the path in .dbenv_<hostname>.sh and .dbenv_<hostname>.csh

should it then work ?

Media:  51041940

OCL11264.SAR

Reagan
Advisor
Advisor
0 Kudos

Hello

Could you confirm under which user you ran those LDD command against brconnect ?

LD_LIBRARY_PATH=/usr/sap/<SID>/SYS/exe/run:/oracle/client/11x_64

The evnironment variable should be /oracle/client/11x_64/instantclient which is a symbolic link to a directory called instantclient_11203

ls -la /oracle/client/11x_64/instantclient_11203

Change the permission of the files under /oracle/client/11x_64/instantclient_11203 to sidadm:sapsys

Regards

RB

Former Member
0 Kudos

SAP has strict rules where to install an Oracle client; have a look at
819829 - Oracle Instant Client Installation and Configuration on
Unix

Afaik the paths are hardcoded in some SAP programs;
not sure about it, but it might be worth a try to move the instantclient to /oracle/client/11x_64/instantclient, and adjust LD_LIBRARY_PATH accordingly.

regards

Former Member
0 Kudos

i did a symlink (see blow), now i geht this error:

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

also if i change the LD_LIBRARY_PATH

from LD_LIBRARY_PATH=/usr/sap/WAQ/SYS/exe/run:/oracle/client/11x_64 to LD_LIBRARY_PATH=/usr/sap/WAQ/SYS/exe/run:/oracle/client/11x_64/instantclient

cd /oracle/client/11x_64

lrwxrwxrwx  1 root   root   21 Apr 30 10:46 instantclient -> /oracle/client/11x_64
Former Member
0 Kudos

I wouldn't have created a symlink like this; it may work though.
And probably you will need yet another symlink; I remember having read about libnnz11.so in a SAP note.
I haven't the number at hand; please do the search yourself!

regards

Former Member
0 Kudos

Have you created a symlink /oracle/client/10x_64 which points to /oracle/client/11x_64? And have you changed the logon scripts of all users?

PS: Check as well.

Former Member
0 Kudos

>Have you created a symlink /oracle/client/10x_64 which points to /oracle/client/11x_64?

no, but the same problem if i do the symlink

lrwxrwxrwx  1 ora<SID> dba   6 Apr 30 11:22 10x_64 -> 11x_64

>And have you changed the logon scripts of all users?

yes, ora<SID> and <SID>adm

0 Kudos

Br*Tools 7.20_EXT does not require a link from 10_2 to 11_2.

Former Member
0 Kudos

OK, good to know...

former_member182657
Active Contributor
0 Kudos

Hi,

Please update release with 720 EXT & try again .You can also refer SCN thread brconnect: error while loading shared libraries | SCN

Regards,

Gaurav

Former Member
0 Kudos

The older Version (35) was EXT too.

release note           1428529
kernel release         720
patch date             2013-11-14
patch level            35
make platform          linuxx86_64
make codeline          720_EXT_REL
make mode              OCI_112
make date              Nov 20 2013

Thanks, i downloaded the file: DBATL720O10_36-20006740.SAR

( from SAP KERNEL 7.20 EXT 64-BIT UC -> Linux on x86_64 64bit -> ORACLE )

extract it on: /usr/sap/<SID>/SYS/exe/run

an started the: saproot.sh <SID>

but the same problem

brtools

BR0651I BRTOOLS 7.20 (36)

release note          1428529
kernel release        720
patch date            2014-02-24
patch level           36
make platform         linuxx86_64
make codeline         720_EXT_REL
make mode             OCI_112
make date             Mar  4 2014

brconnect

BR0801I BRCONNECT 7.20 (36)

release note          1428529
kernel release        720
patch date            2014-02-24
patch level           36
make platform         linuxx86_64
make codeline         720_EXT_REL
make mode             OCI_112
make date            

Mar  4 2014

former_member185239
Active Contributor
0 Kudos

Hi DS,

Please check the below sapnote

819829 - Oracle Instant Client Installation and Configuration on Unix

With Regards

Ashutosh Chaturvedi