Two SAP SIDs on one host. Only one has problem calling libnnz10.so

[Former Member]

We have two SAP SIDs on the same host being setup.

Both have the same env setup & the same kernel (46D_EX2)

When running disp+work for SID1 it's no problem

When running disp+work for SID2 we get this error:

Wed Mar 30 11:57:33 2011

• ERROR => DlLoadLib: shl_load /usr/sap/Q61/SYS/exe/run/dboraslib.so -> DLENOACCESS (2,No such file or directory) [dlux.c 229]

• ERROR => Couldn't load library '/usr/sap/Q61/SYS/exe/run/dboraslib.so'

[dbcon.c 3598]

/usr/lib/hpux64/dld.so: Unable to find library 'libnnz10.so'.

This is a call from kernel file dboraslib.so to the ORACLE 10g client file libnnz10.so' --- both as <sid>adm. The ORACLE client dirs are all owned by ora<SID> so both SIDs should be getting the same permissions... you ca LDD the kernel file on both kernels and get the same setup:

/usr/sap/Q61/SYS/exe/run/dboraslib.so:

ibclntsh.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

/oracle/client/10x_64/instantclient/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

libc.so.1 => /usr/lib/hpux64/libc.so.1

libxti.so.1 => /usr/lib/hpux64/libxti.so.1

Anyone seen the same thing anywhere? I'm stumped for the mo as to why teh same disp+work will run for one SID and not the other. You'd think it was env setup but both are the same that I can see.

[Former Member]

Thanks for the note links - very handy. Glad to have both a solution and reasoning. Cheers.

[former_member264034]

Hi,

SAP note 602843 Environment settings for R/3/Oracle on UNIX

" LIBPATH (AIX)/SHLIB_PATH (HP-UX)/LD_LIBRARY_PATH (other UNIX

systems)

- Operating system variable which contains the search paths for

libraries

- May be important for access to Oracle client libraries such as

libclntsh or libwtc8; for more detailed information see Note

521230.

- For access to SAP libraries, /usr/sap/<sid>/SYS/exe/run must

be contained in the <sid>adm environment (see Note 588739).

- As of Kernel 7.00, the path to the Instant Client must be

contained in the <sid>adm environment (for example,

/oracle/client/10x_64/instantclient, see Note 830578)."

Oracle 10g, take a look at note 830578.

Also refer to note 819829 and install the latest Oracle Instant Client.

Regards,

Aidan

[Former Member]

and I've answered my own question - can I give myself points?

I've no idea why one SID worked and not the other yet

However adding the client path (/oracle/client/10x_64/instantclient) to the SHLIB_PATH certainly clears up the issue, so I've updated the profiles of all relevant users to include that update.

Also not sure why this was required as the LDD clearly showed that it knew where the sub-library call was going to.... and yet it still needed to be in SHLIB_PATH

Happily assign some points if someone can explain that to me!