on 04-30-2014 9:23 AM
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)
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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..
Solution was install/extract the instantclient 11.2.0.4 from: 51047688.ZIP
do the symlink, and all is fine
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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.
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
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Please update release with 720 EXT & try again .You can also refer SCN thread brconnect: error while loading shared libraries | SCN
Regards,
Gaurav
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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 |
Hi DS,
Please check the below sapnote
819829 - Oracle Instant Client Installation and Configuration on Unix
With Regards
Ashutosh Chaturvedi
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.