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

[Ankit Grover]

Hi experts,
I am using HP-UX Itanium B.11.23 Box. I have recently installed Oracle10g on the machine. When I try to login to SQLPLUS, it is giving following error:
fnsonly1-/fns/y1/r/home>sqlplus
/usr/lib/hpux64/dld.so: Unable to find library 'libsqlplus.so'.
Killed

I have tried it after making changes in paths as well:
fnsonly1-/fns/y1/r/home>echo $LD_LIBRARY_PATH
/oracle/product/10g/lib:/oracle/product/10g/rdbms/lib:/oracle/product/10g/lib:/opt/cobol/cobdir/lib:/fns/y1/r/int:/fns/y1/r/dbora/int
fnsonly1-/fns/y1/r/home>echo $SHLIB_PATH
/oracle/product/10g/lib:/oracle/product/10g/rdbms/lib:/usr/lib/hpux64:/opt/cobol/cobdir/lib:

Anyu ideas?

regards,
Ankit

[Steven E. Protter]

Shalom,

It would appear one of the following conditions is true.

SHLIB_PATH is wrong or does not include the sqlplus oracle libararyes. I don't think Oracle uses LD_LIBRARY_PATH but if so, it could be a problem.

It coulc also be that sqlplus and the rest of Oracle needs to be re-linked.

SEP

[Ankit Grover]

relinking should not be the problem since I am able to use SQLPLUS from Oracle user:

/home/oracleg>echo $SHLIB_PATH
/oracle/product/10g/lib32:/oracle/product/10g/rdbms/lib32
/home/oracleg>sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Mar 30 19:09:03 2007

Copyright (c) 1982, 2005, Oracle. All rights reserved.

SQL>

[Ankit Grover]

I have tried one more thing, ie, to use 32-bit libraraies.

fnsonly1-/fns/y1/r/home>echo $SHLIB_PATH
/oracle/product/10g/lib:/usr/lib/hpux32
fnsonly1-/fns/y1/r/home>sqlplus /
/usr/lib/hpux64/dld.so: Unable to find library 'libsqlplus.so'.
Killed
fnsonly1-/fns/y1/r/home>which sqlplus
/oracle/product/10g/bin/sqlplus

Still it is not working out.

[Duncan Edmonstone]

Ankit,

Have you checked that the user in question actually has permission to READ the directories and shared libraries?



HTH

Duncan

[Ankit Grover]

Thanks a zillion Duncan.
The problem was regarding permissions only.

But now I am facing another problem:
fnsonly1-/fns/y1/r/home>sqlplus /
Error 6 initializing SQL*Plus
Message file sp1.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory

fnsonly1-/fns/y1/r/home>echo $ORACLE_HOME
/oracle/product/10g

Can u help me again?

[Duncan Edmonstone]

Ankit,

Thats permissions again. If you don't care too much you can just run chmow -R 755 on your ORACLE_HOME (I *wouldn't* advise this)

Otherwise if you have access to metalink see Doc.ID 356850.1

HTH

Duncan

[Duncan Edmonstone · Accepted solution]

Ankit,

Thats permissions again. If you don't care too much you can just run chmod -R 755 on your ORACLE_HOME (I *wouldn't* advise this)

Otherwise if you have access to metalink see Doc.ID 356850.1

HTH

Duncan

[Ankit Grover]

Hi Duncan,

I gave read permissions on all the files to OTHER users. The previous problem is gone but now I am facing some more problems:
fnsonly1-/fns/y1/r/home>sqlplus
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly

I found on HP Forums that "There is a base bug 4516865. Permissions at the OS level aren't set properly after the Oracle 10gR2 install."

But I dont have Metalink access right no. So I can neither download patch nor see Doc.ID 356850.1 recommended by you.

Regards,
Ankit

[Ankit Grover]

The patch is:
patch no. 4547817 (10.2.0.2 patchset for oracle database server)

Its around 1.3 GB in size

[Ankit Grover]

Its a Oracle10g Installation bug for HP Itanium Sever. We need to install the patch.