Problems with libclntsh.sl (Oracle on HP-UX 11)

[cadbilbao]

Hi!

Working on HPUX-11, I created a shell script to execute a SQL script on Oracle.

script.sh:
------------//---------
su oracle -c 'env ORACLE_SID=XXXX ORACLE_HOME=/u01/app/oracle/product/8.0.5 /u01/
app/oracle/product/8.0.5/bin/svrmgrl command=@/home/oracle/myscript.sql'
-------------//--------

But when executing, this message appears:
-----------//---------------
/usr/lib/dld.sl: Can't open shared library: /project/805/src/rdbms/lib//libclntsh.sl
/usr/lib/dld.sl: No such file or directory
----------//----------------

My 'libclntsh.sl' file is at /u01/app/oracle/product/8.0.5/lib, and I set
LD_LIBRARY_PATH as $ORACLE_HOME/lib

What's wrong? Thanks.

 

[MikeLacey]

Which user owns that library? What are the permissions on it?

Hmm -- from the look of the path it's trying to open to the sl it's almost as if you have a version with a hard coded path to the sl. Mike
michael.j.lacey@ntlworld.com
Email welcome if you're in a hurry or something -- but post in tek-tips as well please, and I will post my reply here as well.

 

[cadbilbao]

Hi all,

I've just found my mistake: Instead of LD_LIBRARY_PATH, I must use SHLIB_PATH on HP-UX.

Thank you anyway.

 

[MikeLacey]

Ahhh thank you... Mike
michael.j.lacey@ntlworld.com
Email welcome if you're in a hurry or something -- but post in tek-tips as well please, and I will post my reply here as well.