on 08-12-2008 1:26 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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)
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
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
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>"?
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
See Oss note 1028220 if it helps.
Look out for the environment too.
Thanks
Amit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Check env variables for SID"adm" user are you see SHLIB_PATH or LD_LIBRARY_PATH ?
Regards.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
23 | |
11 | |
9 | |
8 | |
5 | |
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.