unable to load libclntsh.so.10.1

[Former Member]

OS: HP-UX 11.23

SAP: NW2004s SR2

DB: Oracle 10.2.0.2

Hi,

I am trying to start SAP WebAS ABAP system using startsap script but it fails at DB startup phase. The log file suggests that startdb is unable to locate library libclntsh.so.10.1

SHLIB_PATH points to /oracle/client/10x_64/instantclient and I can see that libclntsh.so.10.1 is there. But ldd dboraslib.so says:

libnsl.so.1 => /usr/lib/hpux64/libnsl.so.1
libpthread.so.1 => /usr/lib/hpux64/libpthread.so.1 
Unable to find library libclntsh.so.10.1

The system was working fine until the root file system got full and some system admin acivity took place on the server. The oracle trace files were relocated. Thats about it. But now when I try to start the system, I keep on getting this error.

I have referred to various SAP notes (e.g 819829) and threads on SDN but none seem to be much helpful.

Thanks in advance for your time.

Regards

Edited by: Shehryar Khan on May 19, 2008 3:27 PM

[Former Member · Accepted solution]

I have run command ldd -s dboraslib and the output is:

...
  find library=libclntsh.so.10.1; required by /usr/sap/ERP/SYS/exe/run/dboraslib
.so
    search path=/usr/sap/ERP/SYS/exe/run:/oracle/client/10x_64/instantclient  (S
HLIB_PATH)
    trying path=/usr/sap/ERP/SYS/exe/run/libclntsh.so.10.1
    trying path=/oracle/client/10x_64/instantclient/libclntsh.so.10.1
    search path=/oracle/client/10x_64/instantclient:/oracle/client/10x_64/lib:/o
racle/db_sw/102_64/instantclient:/oracle/db_sw/102_64/software/lib:/usr/lib/hpux
64:/opt/langtools/lib/hpux64  (RPATH)
    trying path=/oracle/client/10x_64/instantclient/libclntsh.so.10.1
    trying path=/oracle/client/10x_64/lib/libclntsh.so.10.1
    trying path=/oracle/db_sw/102_64/instantclient/libclntsh.so.10.1
    trying path=/oracle/db_sw/102_64/software/lib/libclntsh.so.10.1
    trying path=/usr/lib/hpux64/libclntsh.so.10.1
    trying path=/opt/langtools/lib/hpux64/libclntsh.so.10.1
    search path=/usr/lib/hpux64  (default)
    trying path=/usr/lib/hpux64/libclntsh.so.10.1
        Unable to find library 'libclntsh.so.10.1'.

The directory /oracle/client/10x_64/instantclient is a symbolic link pointing to /oracle/client/10x_64/instantclient_10201 and the relevant libraries are in the actual directory. So I am stumped why these can't be located by dboraslib. Any hints???

Regards

[markus_doehr2 · Accepted solution]

Please execute the following:

file /usr/sap/ERP/SYS/exe/run/dboraslib.so
file /oracle/client/10x_64/instantclient /libclntsh.so.10.1

Markus

[Former Member · Accepted solution]

Thanks for the response.

file /usr/sap/ERP/SYS/exe/run/dboraslib.so returns

/usr/sap/ERP/SYS/exe/run/dboraslib.so:  ELF-64 shared object file - IA64

file /oracle/client/10x_64/instantclient/libclntsh.so.10.1 returns

/oracle/client/10x_64/instantclient/libclntsh.so.10.1:  cannot open

Regards

[markus_doehr2 · Accepted solution]

> file /oracle/client/10x_64/instantclient/libclntsh.so.10.1 returns

>

> /oracle/client/10x_64/instantclient/libclntsh.so.10.1:  cannot open
> 

you wrote the file is there - is it not?

Markus

[Former Member · Accepted solution]

It is there. When I open the directory instantclient, I see all the files available in instantclient_10201. I am unable to understand why the file is not accessible. Any ideas???

Regards

[markus_doehr2 · Accepted solution]

Then please issue a "file" command on it:

file libclntsh.so.10.1

What's the output?

Markus

[Former Member · Accepted solution]

In both directories, sym link and the actual one, file libclntsh.so.10.1 returns:

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

Should a find command work in both cases as well? I have tried issuing a find command on both directories and I get results in case of the original one but the not the from link.

Regards

[markus_doehr2 · Accepted solution]

HP-UX 11.23 on IA64 does use SHLIB_PATH only for backward compatible shared libraries (ending ".sl") - the new libraries (with .so) use LD_LIBRARY_PATH

So (in case of your shell being ksh) try

LD_LIBRARY_PATH=$SHLIB_PATH
export LD_LIBRARY_PATH

Then try an "ldd" again.

Markus

[Former Member · Accepted solution]

Thanks. System configuration was working fine until there was a space problem in root file system. From SAP note 819829, it says that LD_LIBRARY_PATH is for LINUX and SOLARIS. I have tried it though but same response. It still can't locate the file.

Thanks and regards

[Former Member · Accepted solution]

Ok, I have tried the file command by switching to root user and it shows the attributes. Seems there is a problem with sidadm user's authorization. Currently, when I issues ls -l for the directory instantclient, I get:

lrwxr-x--- 1 root sapinst 41 May 15 11:57 instantclient -> /oracle/client/10x_64/instantclient_10201

While the actual physical directory instantclient_10201 has the following attributes:

drwxrwxr-x 1 erpadm sapsys 1024 Mar 27 2006 instantclient_10201

Any ideas what the authorizations should be for linked directory?

Regards

[markus_doehr2 · Accepted solution]

> Thanks. System configuration was working fine until there was a space problem in root file system. From SAP note 819829, it says that LD_LIBRARY_PATH is for LINUX and SOLARIS.

This is not completely correct - see the blog at

http://administratosphere.wordpress.com/2007/10/19/shared-libraries-hp-ux/

> I have tried it though but same response. It still can't locate the file.

This is really strange. I can do that nicely:

testsyst:fooadm> ldd dboraslib.so 
        libnsl.so.1 =>  /usr/lib/hpux64/libnsl.so.1
        libpthread.so.1 =>      /usr/lib/hpux64/libpthread.so.1
        libclntsh.so.10.1 =>    /oracle/client/10x_64/instantclient/libclntsh.so.10.1
        libnnz10.so =>  /oracle/client/10x_64/instantclient/libnnz10.so
        libc.so.1 =>    /usr/lib/hpux64/libc.so.1
        libxti.so.1 =>  /usr/lib/hpux64/libxti.so.1
        libnnz10.so =>  /oracle/client/10x_64/instantclient/libnnz10.so
        librt.so.1 =>   /usr/lib/hpux64/librt.so.1
        libnss_dns.so.1 =>      /usr/lib/hpux64/libnss_dns.so.1
        libdl.so.1 =>   /usr/lib/hpux64/libdl.so.1
        libm.so.1 =>    /usr/lib/hpux64/libm.so.1
        libpthread.so.1 =>      /usr/lib/hpux64/libpthread.so.1
        libunwind.so.1 =>       /usr/lib/hpux64/libunwind.so.1
        libnsl.so.1 =>  /usr/lib/hpux64/libnsl.so.1
        libdl.so.1 =>   /usr/lib/hpux64/libdl.so.1
        libuca.so.1 =>  /usr/lib/hpux64/libuca.so.1

What we can try is to take the instantclient path out of both SHLIB_PATH and LD_LIBRARY_PATH since it's hardcoded (using -R).

Check with command

chatr dboraslib.so

if the instantclient path is there.

Then, after taking that out of the environment, try again.

Markus

[markus_doehr2 · Accepted solution]

I have here

testsyst:fooadm> ls -l /oracle/client/
total 0
drwxrwxr-x   3 fooadm     sapsys          96 Apr 23 05:01 10x_64
testsyst:fooadm> ls -l /oracle/client/10x_64/
total 4
-rwxrwxr-x   1 fooadm     sapsys         100 Mar 27  2006 dbclient.lst
lrwxr-x---   1 root       sapinst         41 Apr 23 05:01 instantclient -> /oracle/client/10x_64/instantc
lient_10201
drwxrwxr-x   2 fooadm     sapsys        1024 Mar 27  2006 instantclient_10201

Markus

[fidel_vales · Accepted solution]

Hello,

>The directory /oracle/client/10x_64/instantclient is a symbolic link pointing to >/oracle/client/10x_64/instantclient_10201 and the relevant libraries are in the actual directory. So I am >stumped why these can't be located by dboraslib. Any hints???

As you are using an old version of the instantclient (as per note 819829 it is recommended to use 10.2.0.2 version) I'd try to install (using the correct user) the version 10.2.0.2

I think you have an authorization problem, but lets try first installing a nwer version.

[Former Member · Accepted solution]

Thanks. It seems there is a difference in my /oracle/client authorizations. You have

ls -l /oracle/client/ 
total 0
drwxrwxr-x   3 fooadm     sapsys          96 Apr 23 05:01 10x_64

When I run ls -l /oracle/client as erpadm, I get

/oracle/client unreadable
total 0

But when I run ls -l /oracle/client as root, I get

total 2
drwxr-xr-x   4   root   root   1024  May 19  14:06 10x_64

Should I change authorization of the oracle/client or is there a workaround to this?

[markus_doehr2 · Accepted solution]

<sid>adm and group sapsys must be able to access that directory.

I'd change the permissions to <sid>adm:sapsys and try again.

Markus

[fidel_vales · Accepted solution]

> Thanks. It seems there is a difference in my /oracle/client authorizations. You have

>

>

> ls -l /oracle/client/ 
> total 0
> drwxrwxr-x   3 fooadm     sapsys          96 Apr 23 05:01 10x_64
> 

is the sapsid FOO or is this another system, it is not very clear

>

> When I run ls -l /oracle/client as erpadm, I get

>

> /oracle/client unreadable
> total 0
> 

>

> But when I run ls -l /oracle/client as root, I get

>

> total 2
> drwxr-xr-x   4   root   root   1024  May 19  14:06 10x_64
> 

>

> Should I change authorization of the oracle/client or is there a workaround to this?

change the aauthorizations to erpadm and group sapsys. only root can make that change.

Also, you should update to 10.2.0.2, but this change will allow you to use the instantclient.

[markus_doehr2 · Accepted solution]

> As you are using an old version of the instantclient (as per note 819829 it is recommended to use 10.2.0.2 version) I'd try to install (using the correct user) the version 10.2.0.2

Yes - I know - but the client on the installation DVD as well as the client downloadable from the SMP have that version for HP-UX IA64. I didn't check the latest ORCLR2 release.

Markus

[markus_doehr2 · Accepted solution]

>

> > Thanks. It seems there is a difference in my /oracle/client authorizations. You have

> >

> >

> > ls -l /oracle/client/ 
> > total 0
> > drwxrwxr-x   3 fooadm     sapsys          96 Apr 23 05:01 10x_64
> > 

> is the sapsid FOO or is this another system, it is not very clear

Yes the SID Is "FOO".

Markus

[fidel_vales · Accepted solution]

Ups,

I didn't check that

I know there is a file on the 10.2.0.2 instant client website, but i have not checked the version.

Thanks for the update

[markus_doehr2 · Accepted solution]

There's a new one (I just noticed) with change date May 7th - so that would be the new R2 version Means, 10.2.0.2.0 R2

Markus

[fidel_vales · Accepted solution]

Not sure, in theory the file should be called OCL10264_V2.SAR

Perhaps is the "normal" 10.2.0.2 that they forgot to upload

[markus_doehr2 · Accepted solution]

> Not sure, in theory the file should be called OCL10264_V2.SAR

> Perhaps is the "normal" 10.2.0.2 that they forgot to upload 😄

lol

I just downloaded and and installed on one of our testsystems:

<...>
M  kernel runs with dp version 235000(ext=110000) (@(#) DPLIB-INT-VERSION-235000-UC)
M  length of sys_adm_ext is 576 bytes
M  ***LOG Q01=> ThInit, WPStart (Workproc 0 1 19474) [thxxhead.c   1281]
M  ThInit: running on host testsyst
M  calling db_connect ...
C  Oracle Client Version: '10.2.0.2.0'
C  Client NLS settings: AMERICAN_AMERICA.UTF8
C  Logon as OPS$-user to get SAPFOO's password
<...>

So at least it's now 10.2.0.2.

I unpacked it using "fooadm" and recreated the link:

testsyst:fooadm> cd /oracle/client/10x_64/
testsyst:fooadm> ls -l
total 87440
-rw-rw-rw-   1 fooadm     sapsys     44765594 May 19 23:20 OCL10264_HP_IA64.SAR
-rw-r--r--   1 fooadm     sapsys         100 May  4  2006 dbclient.lst
lrwxrwxrwx   1 fooadm     sapsys          41 May 19 23:21 instantclient -> /oracle/client/10x_64/instantclient_10202
drwxrwxr-x   2 fooadm     sapsys        1024 Mar 27  2006 instantclient_10201
drwxr-xr-x   2 fooadm     sapsys        1024 May  4  2006 instantclient_10202

Markus

[fidel_vales · Accepted solution]

,

You see, helping others some times is also good for you

its the karma.

[markus_doehr2 · Accepted solution]

> ,

> You see, helping others some times is also good for you

Definitely - I'm not an all-knowing-device-for-all-purposes and I never denied that I have a lot to learn!

> its the karma.

Probably - or Chi

Markus