Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

oracle sqlplus error - libsqlplus.sl

SOLVED
Go to solution
Shivkumar
Super Advisor

oracle sqlplus error - libsqlplus.sl

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
9 REPLIES
Victor Fridyev
Honored Contributor

Re: oracle sqlplus error - libsqlplus.sl

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
Entities are not to be multiplied beyond necessity - RTFM
Shivkumar
Super Advisor

Re: oracle sqlplus error - libsqlplus.sl

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

Re: oracle sqlplus error - libsqlplus.sl

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
Honored Contributor
Solution

Re: oracle sqlplus error - libsqlplus.sl

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
"A ship in the harbor is safe, but that is not what ships are built for"
Zigor Buruaga
Esteemed Contributor

Re: oracle sqlplus error - libsqlplus.sl

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
Super Advisor

Re: oracle sqlplus error - libsqlplus.sl

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
Super Advisor

Re: oracle sqlplus error - libsqlplus.sl

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
Honored Contributor

Re: oracle sqlplus error - libsqlplus.sl

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
Never give up, Keep Trying
Yogeeraj_1
Honored Contributor

Re: oracle sqlplus error - libsqlplus.sl

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)