cancel
Showing results for 
Search instead for 
Did you mean: 

BRCONNECT unable to find oracle library

Former Member
0 Kudos

Hi

After SAP upgrade to Netweaver 7.0 with Oracle 10.2 on HP-UX system, the BRCONNECT program unable to execute DBA jobs. It is ending with following error with user <sid>adm

Execute logical command BRCONNECT On host <wxyz>

Parameters: -u / -jid CHECK20080812023451 -c -f check

/usr/lib/pa20_64/dld.sl: Unable to find library 'libclntsh.sl.10.1'.

Process died due to signal 9

_________________________

And if I run it using user ora<sid>, it ends with insufficient privileges.

BR0801I BRCONNECT 7.00 (32)

BR0301E SQL error -1031 at location BrLicCheck-14, SQL statement:

'SELECT COUNT(*) FROM SAP_SAPLIKEY'

ORA-01031: insufficient privileges

BR0804I BRCONNECT terminated with errors

_________________________

The roles granted to users OPS$<SID>ADM and OPS$ORA<SID> are RESOURCE, CONNECT and SAPDBA.

please provide your inputs on these issues i.e. how to make the oracle library available when running brconnect using <sid>adm user and how to remove the "ORA-01031: insufficient privileges" when running brconnect using ora<sid> user.

Thanks

Vinod

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hello Vinod,

for the library issue, check if the permissions are correctly set on the br* executables. They should be owned by ora and have the setuid bit set.

You can ensure they have the correct permissions by running the script saproot.sh as user root.

for the ORA-1031 error, re-run the script sapdba_role.sql corresponding to the version of SAP you have upgraded to (NW 7.0).

If these steps do not help, we'll go further on

Sébastien

Former Member
0 Kudos

Hi Sébastien

I have already executed saproot.sh script and brconnect is owned by user ora/lib where the required library resides.

Regards

Vinod

0 Kudos

Hi,

Authorization issue will not be solved.

The error happens because the user OPS$ora<SID> do not have authorizations.

And that is the correct situation as you are not supposed to have such user.

The library error is more tricky.

You mention you get the error running it as <sid>adm.

I can see that you are trying to execute it from inside SAP

could you try to execute it on the command line?

If you get the same error, then provide the environment variables and the output of the following commands

> ls -lR /oracle/client

> which brconnect

> pwd

> ldd brconnect

of course, this has to be done on the kernel directory (at least the last command)

Former Member
0 Kudos

Vinod,

the suggestions of Fidel are (as always) excellent. Please apply the instructions he gave you and post the results.

For the SHLIB_PATH values of user adm, I think that for Oracle 10g you have to specify the location of the Oracle InstantClient files and not the $ORACLE_HOME/lib

See note 830578 for more info.

Seb

Edited by: Sébastien Pondichy on Aug 12, 2008 11:14 PM

Former Member
0 Kudos

Hi All

I have tried executing it on <sid>adm commandline but it is giving same error.

>brconnect -u / -c -f check

/usr/lib/pa20_64/dld.sl: Unable to find library 'libclntsh.sl.10.1'.

Killed

_____________________________________________

The following are the env for <sid>adm

_=/usr/bin/env

THREAD=NOPS

SHLIB_PATH=/usr/sap/<SID>/SYS/exe/run:/oracle/client/10x_64/instantclient

ORACLE_PSRV=<SID>

PATH=/oracle/<SID>/102_64/bin:/home/<SID>adm:/usr/sap/<SID>/SYS/exe/run:/opt/sudo/bin:/opt/sudo/sbin:/usr/bin:/opt/ansic/bin:/usr/ccs/bin:/usr/contrib/bin:/opt/hparray/bin:/opt/nettladm/bin:/opt/upgrade/bin:/opt/fcms/bin:/opt/pd/bin:/usr/bin/X11:/usr/contrib/bin/X11:/opt/resmon/bin:/opt/perf/bin:/opt/prm/bin:/opt/mx/bin:/opt/ignite/bin:/opt/gnome/bin:/opt/mozilla:/opt/wbem/bin:/opt/wbem/sbin:/opt/langtools/bin:/opt/imake/bin:/opt/graphics/common/bin:/usr/sbin/diag/contrib:/opt/sudo/bin:/opt/networker/bin:/opt/hpnpl//bin:/opt/OV/bin/OpC:/opt/OV/bin:/opt/cfg2html:/opt/ssh/bin:/opt/java1.4/bin:.

NLS_LANG=AMERICAN_AMERICA.WE8DEC

COLUMNS=125

ORACLE_BASE=/oracle

EDITOR=vi

LOGNAME=<sid>adm

dbs_ora_tnsname=<SID>

ORACLE_SID=<SID>

ERASE=^H

PS1=

<sid>adm>

DB_SID=<SID>

DIR_LIBRARY=/usr/sap/<SID>/SYS/exe/run

ORA_NLS10=/oracle/<SID>/102_64/nls/data

dbs_ora_schema=SAP<SID>

SHELL=/usr/bin/sh

JAVA_HOME=/opt/java1.4/bin

SAPDATA_HOME=/oracle/<SID>

HOME=/home/<SID>adm

TERM=xterm

ORACLE_HOME=/oracle/<SID>/102_64

PWD=/home/<SID>adm

TZ=CST6CDT

dbms_type=ORA

SAPSYSTEMNAME=<SID>

LINES=44

__________________________________________________

The following is command outputs as requested by Fidel

ls -lR /oracle/client

drwxr-xr-x 3 ora<sid> dba 1024 May 30 11:32 10x_64

drwxr-xr-x 8 ora<sid> dba 1024 Jan 10 2007 9207

drwxr-xr-x 4 ora<sid> dba 96 Mar 12 2004 92x_64

/oracle/client/10x_64:

total 87438

-rwxr-xr-x 1 ora<sid> dba 44765594 May 30 11:28 OCL10264.SAR.1

-rw-rr 1 ora<sid> dba 100 May 4 2006 dbclient.lst

lrwxr-xr-x 1 ora<sid> dba 19 May 30 11:32 instantclient -> instantclient_10202

drwxr-xr-x 2 ora<sid> dba 1024 May 4 2006 instantclient_10202

/oracle/client/10x_64/instantclient_10202:

total 231858

-rrr-- 1 ora<sid> dba 1594191 Apr 20 2006 classes12.jar

-rwxr-xr-x 1 ora<sid> dba 36684488 Apr 20 2006 libclntsh.so.10.1

-rwxr-xr-x 1 ora<sid> dba 5231200 Apr 20 2006 libnnz10.so

-rwxr-xr-x 1 ora<sid> dba 3322720 Apr 20 2006 libocci.so.10.1

-rwxr-xr-x 1 ora<sid> dba 70117848 Apr 20 2006 libociei.so

-rwxr-xr-x 1 ora<sid> dba 201112 Apr 20 2006 libocijdbc10.so

-rrr-- 1 ora<sid> dba 1540457 Apr 20 2006 ojdbc14.jar

/oracle/client/9207:

total 2

drwxr-xr-x 5 ora<sid> dba 96 Jan 10 2007 jdbc

drwxr-xr-x 2 ora<sid> dba 1024 Jan 10 2007 lib

drwxr-xr-x 3 ora<sid> dba 96 Jan 10 2007 network

drwxr-xr-x 3 ora<sid> dba 96 Jan 10 2007 ocommon

drwxr-xr-x 5 ora<sid> dba 96 Jan 10 2007 oracore

drwxr-xr-x 3 ora<sid> dba 96 Jan 10 2007 rdbms

/oracle/client/9207/jdbc:

total 62

-rwxr-xr-x 1 ora<sid> dba 30654 Jan 10 2007 Readme.txt

drwxr-xr-x 2 ora<sid> dba 96 Jan 10 2007 demo

drwxr-xr-x 2 ora<sid> dba 96 Jan 10 2007 doc

drwxr-xr-x 2 ora<sid> dba 1024 Jan 10 2007 lib

/oracle/client/9207/jdbc/demo:

total 880

-rwxr-xr-x 1 ora<sid> dba 450560 Jan 10 2007 demo.tar

/oracle/client/9207/jdbc/doc:

total 14140

-rwxr-xr-x 1 ora<sid> dba 3619840 Jan 10 2007 javadoc.tar

-rwxr-xr-x 1 ora<sid> dba 3619840 Jan 10 2007 jdbcdoc.tar

/oracle/client/9207/jdbc/lib:

total 34090

-rwxr-xr-x 1 ora<sid> dba 1413613 Jan 10 2007 classes111_g.jar

-rwxr-xr-x 1 ora<sid> dba 1423863 Jan 10 2007 classes111_g.zip

-rwxr-xr-x 1 ora<sid> dba 1234433 Jan 10 2007 classes12.jar

-rwxr-xr-x 1 ora<sid> dba 1245538 Jan 10 2007 classes12.zip

-rwxr-xr-x 1 ora<sid> dba 1476640 Jan 10 2007 classes12_g.jar

-rwxr-xr-x 1 ora<sid> dba 1487705 Jan 10 2007 classes12_g.zip

-rwxr-xr-x 1 ora<sid> dba 1240587 Jan 10 2007 classes12dms.jar

-rwxr-xr-x 1 ora<sid> dba 1483154 Jan 10 2007 classes12dms_g.jar

-rwxr-xr-x 1 ora<sid> dba 1848170 Jan 10 2007 nls_charset12.jar

-rwxr-xr-x 1 ora<sid> dba 1878202 Jan 10 2007 nls_charset12.zip

-rwxr-xr-x 1 ora<sid> dba 37761 Jan 10 2007 ocrs12.jar

-rwxr-xr-x 1 ora<sid> dba 37785 Jan 10 2007 ocrs12.zip

-rwxr-xr-x 1 ora<sid> dba 1212964 Jan 10 2007 ojdbc14.jar

-rwxr-xr-x 1 ora<sid> dba 1427311 Jan 10 2007 ojdbc14_g.jar

/oracle/client/9207/lib:

total 52960

lrwxr-xr-x 1 ora<sid> dba 16 May 27 08:31 libclntsh.so -> libclntsh.so.9.0

-rwxrwxrwx 1 ora<sid> dba 25754472 Jan 10 2007 libclntsh.so.9.0

-rwxr-xr-x 1 ora<sid> dba 406606 Jan 10 2007 libocijdbc9.a

-rwxr-xr-x 1 ora<sid> dba 226656 Jan 10 2007 libocijdbc9.so

-rwxr-xr-x 1 ora<sid> dba 284592 Jan 10 2007 libocijdbc9_g.so

-rwxr-xr-x 1 ora<sid> dba 421258 Jan 10 2007 libocijdbcst9.a

-rwxr-xr-x 1 ora<sid> dba 18664 Jan 10 2007 libwtc9.so

/oracle/client/9207/network:

total 2

drwxr-xr-x 2 ora<sid> dba 1024 May 30 13:46 admin

/oracle/client/9207/network/admin:

total 8

-rw-rr 1 ora<sid> dba 24 May 29 15:38 snmp_ro.ora

-rw-r-xr-x 1 ora<sid> dba 277 May 29 15:38 sqlnet.ora

-rw-r-xr-x 1 ora<sid> dba 1332 May 29 15:38 tnsnames.ora.old

/oracle/client/9207/ocommon:

total 0

drwxr-xr-x 3 ora<sid> dba 96 Jan 10 2007 nls

/oracle/client/9207/ocommon/nls:

total 0

drwxr-xr-x 3 ora<sid> dba 96 Jan 10 2007 admin

/oracle/client/9207/ocommon/nls/admin:

total 28

drwxr-xr-x 2 ora<sid> dba 14336 Jan 10 2007 data

/oracle/client/9207/ocommon/nls/admin/data:

total 41676

-rwxr-xr-x 1 ora<sid> dba 721 Jan 10 2007 lx00001.nlb

-rwxr-xr-x 1 ora<sid> dba 124146 Jan 10 2007 lx607d01.nlb

/oracle/client/9207/oracore:

total 2

drwxr-xr-x 2 ora<sid> dba 96 Jan 10 2007 lib

drwxr-xr-x 2 ora<sid> dba 1024 Jan 10 2007 mesg

drwxr-xr-x 2 ora<sid> dba 96 Jan 10 2007 zoneinfo

/oracle/client/9207/oracore/lib:

total 4210

-rwxr-xr-x 1 ora<sid> dba 2155296 Jan 10 2007 libcore9.so

/oracle/client/9207/oracore/mesg:

total 116

-rwxr-xr-x 1 ora<sid> dba 8704 Jan 10 2007 lfiesa.msb

-rwxr-xr-x 1 ora<sid> dba 7168 Jan 10 2007 lfius.msb

-rwxr-xr-x 1 ora<sid> dba 27588 Jan 10 2007 lfius.msg

-rwxr-xr-x 1 ora<sid> dba 4608 Jan 10 2007 lrmesa.msb

-rwxr-xr-x 1 ora<sid> dba 4608 Jan 10 2007 lrmus.msb

-rwxr-xr-x 1 ora<sid> dba 4441 Jan 10 2007 lrmus.msg

/oracle/client/9207/oracore/zoneinfo:

total 1022

-rwxr-xr-x 1 ora<sid> dba 2297 Jan 10 2007 readme.txt

-rwxr-xr-x 1 ora<sid> dba 370494 Jan 10 2007 timezlrg.dat

-rwxr-xr-x 1 ora<sid> dba 148797 Jan 10 2007 timezone.dat

/oracle/client/9207/rdbms:

total 2

drwxr-xr-x 2 ora<sid> dba 1024 Jan 10 2007 mesg

/oracle/client/9207/rdbms/mesg:

total 8854

-rwxr-xr-x 1 ora<sid> dba 8704 Jan 10 2007 bbedus.msb

-

-rwxr-xr-x 1 ora<sid> dba 124079 Jan 10 2007 ulus.msg

/oracle/client/92x_64:

total 0

drwxr-xr-x 2 ora<sid> dba 96 Mar 12 2004 ietc

lrwxr-xr-x 1 ora<sid> dba 23 Mar 12 2004 jdbc -> /oracle/<sid>/920_64/jdbc

lrwxr-xr-x 1 ora<sid> dba 22 Mar 12 2004 lib -> /oracle/<sid>/920_64/lib

drwxr-xr-x 3 ora<sid> dba 96 Mar 12 2004 ocommon

/oracle/client/92x_64/ietc:

total 40

-rwxr-xr-x 1 ora<sid> dba 19961 Mar 12 2004 CROCLLNK

/oracle/client/92x_64/ocommon:

total 0

drwxr-xr-x 3 ora<sid> dba 96 Mar 12 2004 nls

/oracle/client/92x_64/ocommon/nls:

total 0

drwxr-xr-x 2 ora<sid> dba 96 Mar 12 2004 admin

/oracle/client/92x_64/ocommon/nls/admin:

total 0

lrwxr-xr-x 1 ora<sid> dba 41 Mar 12 2004 data -> /oracle/<sid>/920_64/ocommon/nls/admin/data

___________________

<sid>adm> which brconnect

/usr/sap/<SID>/SYS/exe/run/brconnect

<sid>adm> pwd

/sapmnt/<sid>/exe

<sid>adm> ldd brconnect

libnsl.1 => /usr/lib/pa20_64/libnsl.1

libpthread.1 => /usr/lib/pa20_64/libpthread.1

libm.2 => /usr/lib/pa20_64/libm.2

Unable to find library 'libclntsh.sl.10.1'.

_____________________________________________

Also it is not working even after adding oracle instant client path in SHLIB_PATH

Regards,

Vinod

0 Kudos

Hi,

Good.

First thing, I assume that you have replaced your real <SID> in the information.

Otherwise it makes not much sense to see so many "<SID>"

adm> ldd brconnect

libnsl.1 => /usr/lib/pa20_64/libnsl.1

libpthread.1 => /usr/lib/pa20_64/libpthread.1

libm.2 => /usr/lib/pa20_64/libm.2

Unable to find library 'libclntsh.sl.10.1'. <<<<<<<<<<<<<<<<

but on your instantclient directory you have:

/oracle/client/10x_64/instantclient_10202:

total 231858

-rrr-- 1 ora dba 1594191 Apr 20 2006 classes12.jar

-rwxr-xr-x 1 ora dba 36684488 Apr 20 2006 libclntsh.so.10.1 <<<<<<<<

-rwxr-xr-x 1 ora dba 5231200 Apr 20 2006 libnnz10.so

-rwxr-xr-x 1 ora dba 3322720 Apr 20 2006 libocci.so.10.1

-rwxr-xr-x 1 ora dba 70117848 Apr 20 2006 libociei.so

-rwxr-xr-x 1 ora dba 201112 Apr 20 2006 libocijdbc10.so

-rrr-- 1 ora dba 1540457 Apr 20 2006 ojdbc14.jar

The library that is searching for is not there.

Two options

1) your brconnect belongs to another OS

2) your client library belongs to another OS

to double check

1) What is your OS?

2) output of "file brconnect"

2) output of "file libnnz10.so"

Moreover, is the owner "ora" or maybe "ora<sid>"?

Former Member
0 Kudos

Hi Fidel

The OS name is HP-UX PA-RISC and below are the checks:

>file brconnect

brconnect: ELF-64 executable object file - PA-RISC 2.0 (LP64)

The following checks are in path /oracle/client/10x_64/instantclient_10202. But here it is not showing OS type/name

>file libclntsh.so.10.1

libclntsh.so.10.1: ELF-64 shared object file

>file libnnz10.so

libnnz10.so: ELF-64 shared object file

Also I have checked the required library in /oracle/<SID>/102_64/lib

>file libclntsh.sl.10.1

libclntsh.sl.10.1: ELF-64 shared object file - PA-RISC 2.0 (LP64)

Please suggest whether is there any other way to find oracle client OS name.

Regards

Vinod

markus_doehr2
Active Contributor
0 Kudos

Please check the effective user ID of the file brconnect:

ls -l brconnect

Markus

Former Member
0 Kudos

Hi Markus

The effective userid for brconnect is ora<sid> & group sapsys with permissions -rwsr-xr-x

Users <sid>adm & ora<sid> belongs to group sapsys

regards

Vinod

markus_doehr2
Active Contributor
0 Kudos

Ok.

so if you login as ora<SID>, does it contain the SHLIB_PATH/LD_LIBRARY_PATH to the instantclient?

Markus

Answers (3)

Answers (3)

Former Member
0 Kudos

After you upgrade to 7.0 (i know i'm upgarde from 640 to 7.0 on HP-UX v11.11) for SID"adm" user the

SHLIB_PATH=/usr/sap/SID/SYS/exe/run:/oracle/client/10x_64/instantclient

Try to check other variables,are you set it correctly ?

Regards.

Former Member
0 Kudos

See Oss note 1028220 if it helps.

Look out for the environment too.

Thanks

Amit

Former Member
0 Kudos

Check env variables for SID"adm" user are you see SHLIB_PATH or LD_LIBRARY_PATH ?

Regards.