oracle sqlplus error - libsqlplus.sl

[Shivkumar]

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

[Victor Fridyev]

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

[Shivkumar]

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

[Shivkumar]

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

[Arunvijai_4 · Accepted solution]

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

[Zigor Buruaga]

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

[Shivkumar]

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 #

[Shivkumar]

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

[Indira Aramandla]

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

[Yogeeraj_1]

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