topic Re: oracle sqlplus error - libsqlplus.sl in Operating System - HP-UX

oracle sqlplus error - libsqlplus.sl

Shivkumar — Sat, 29 Oct 2005 15:38:15 GMT

Dear Sirs,

I got the below error while using sqlplus command.

root@jasmine: /home/sksonkar/shiv_oracle_sqpplus #./sqlplus
/usr/lib/pa20_64/dld.sl: Unable to find library 'libsqlplus.sl'.
Killed

Can anyone suggest some workaround ?

Thanks,
Shiv

Re: oracle sqlplus error - libsqlplus.sl

Victor Fridyev — Sat, 29 Oct 2005 16:29:13 GMT

Hi,
Could you please show the environment of the user: ORACLE_HOME and SHLIB_PATH.
The library must be in $ORACLE_HOME/lib and this directory must be in SHLIB_PATH

HTH

Re: oracle sqlplus error - libsqlplus.sl

Shivkumar — Sat, 29 Oct 2005 17:11:28 GMT

I am using oracle instant client which doesn't need to set the ORACLE_HOME ?

Re: oracle sqlplus error - libsqlplus.sl

Shivkumar — Sat, 29 Oct 2005 17:14:28 GMT

Sir,

Here is directory where i installed oracle intant client:

$ pwd
/home/sksonkar/shiv_oracle_sqpplus
$ ll
total 4654
-rwxr-xr-x 1 sksonkar users 1525 Oct 26 15:51 glogin.sql
-rwxr-xr-x 1 sksonkar users 916968 Oct 26 15:51 libsqlplus.sl
-rwxr-xr-x 1 sksonkar users 1435656 Oct 26 15:51 libsqlplusic.sl
-rwxr-xr-x 1 sksonkar users 25168 Oct 26 15:51 sqlplus
-rwxr-xr-x 1 root sys 1020 Oct 28 09:41 tnsnames.ora
$

Thanks,
Shiv

Re: oracle sqlplus error - libsqlplus.sl

Arunvijai_4 — Sun, 30 Oct 2005 01:50:01 GMT

Shiv, export your SHLIB_PATH=$SHLIB_PATH:/home/sksonkar/shiv_oracle_sqpplus.
LD should be able to find your libraries now. Otherwise, manually linking it to /usr/lib will also help.

-Arun

Re: oracle sqlplus error - libsqlplus.sl

Zigor Buruaga — Sun, 30 Oct 2005 02:11:41 GMT

Hi,

Looking at the instructions on oracle web:

1. Download the appropriate Instant Client packages for your platform. All installations REQUIRE the Basic package.

2. Unzip the packages into a single directory such as "instantclient".
3. Set the library loading path in your environment to the directory in Step 2 ("instantclient"). On many UNIX platforms, LD_LIBRARY_PATH is the appropriate environment variable. On Windows, PATH should be used.

Did you try to set LD_LIBRARY_PATH to the appropiate value?

Regards,
Zigor

Re: oracle sqlplus error - libsqlplus.sl

Shivkumar — Sun, 30 Oct 2005 14:41:55 GMT

root@bigguy: /home/sksonkar/shiv_oracle_sqpplus # ./sqlplus
/usr/lib/pa20_64/dld.sl: Unable to find library 'libclntsh.sl.10.1'.
Killed
root@bigguy: /home/sksonkar/shiv_oracle_sqpplus #

Re: oracle sqlplus error - libsqlplus.sl

Shivkumar — Sun, 30 Oct 2005 14:43:48 GMT

Sir,

Now i got this new errors as shown below:

root@bigguy: /home/sksonkar/shiv_oracle_sqpplus # ./sqlplus
/usr/lib/pa20_64/dld.sl: Unable to find library 'libclntsh.sl.10.1'.
Killed
root@bigguy: /home/sksonkar/shiv_oracle_sqpplus #

Thanks,
Shiv

Re: oracle sqlplus error - libsqlplus.sl

Indira Aramandla — Sun, 30 Oct 2005 21:23:02 GMT

Hi Shivkumar,

SQL*Plus Instant Client allows you to run SQL*Plus without installing the standard Oracle client, or having an ORACLE_HOME.

Unable to find library 'libclntsh.sl.10.1'. indicates that this library did not get created properly

You can try relink all, but more than likely it is an environment variable that is not set properly.

As others mentioned environment variables (LD_LIBRARY_PATH and SHLIB_PATH) were not set properly

LD_LIBRARY_PATH=/lib:/usr/dt/lib:/usr/lib
export LD_LIBRARY_PATH

SHLIB_PATH=/lib:/usr/dt/lib:/usr/lib
export SHLIB_PATH

Check the value for LD_LIBRARY_PATH and SHLIB_PATH after step 1
echo $LD_LIBRARY_PATH
echo $SHLIB_PATH
Run sqlplus again.

Indira A

Re: oracle sqlplus error - libsqlplus.sl

Yogeeraj_1 — Sun, 30 Oct 2005 23:13:44 GMT

hi shiv,

IA is right. Assuming your installation was properly done, make sure these environment variables are set:
LD_LIBRARY_PATH and SHLIB_PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/dt/lib:/usr/lib
export SHLIB_PATH=$ORACLE_HOME/lib:/usr/dt/lib:/usr/lib

good luck
yogeeraj