Geek Answers Handbook

Libsqlplus.so: connot open shared object file: There is no such file or directory, even if PATH contains the path

I uploaded the Instant Oracle Client Version 11.2.0.4.0 ( basic , sqlplus , devel .rpm file) Oracle website in Ubuntu. After converting .rpm to .deb using alien I installed it, basic first and sqlplus and last devel .

And then I tried to run sqlplus.

But He says sqlplus64: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory

Although my PATH contains PATH .

Below is my PATH and the location of libsqlplus.so .

 A@ubuntu :~$ sudo find / -name libsqlplus.so /usr/lib/oracle/11.2/client64/lib/libsqlplus.so A@ubuntu :~$ echo $PATH /usr/lib/lightdm/lightdm:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/home/sangmin/eclipse:/usr/lib/oracle/11.2/client64/lib:/usr/lib/oracle/11.2/client64
+6
source share
2 answers

Check your Oracle client. The user is either sqlplus or sqlplus64 depending on your platform. In my case, I used:

 $ sqlplus64 username/ password@ //dbhost:1521/SID

If you get the following message, you need to tell sqlplus to use the proper libray:

sqlplus64: error loading shared libraries: libsqlplus.so: cannot open shared objects file: no such file or directory.

To do this, first find the location of the Oracle libraries. The path should be something like /usr/lib/oracle/<version>/client(64)/lib/ . In my case (Ubuntu 14.04 LTS, Intel on 64-bit) it was /usr/lib/oracle/11.2/client64/lib/ .

Now add this path to the system library list. Create and edit a new file:

 $ sudo nano /etc/ld.so.conf.d/oracle.conf

Add inside the path:

 /usr/lib/oracle/11.2/client64/lib/

Run the dynamic runtime linker program:

 $ sudo ldconfig

If sqlplus gives the missing libaio.so.1 file, run:

 $ sudo apt-get install libaio1

For other errors when trying to start sqlplus see the Ubuntu help page.

+13
source

Maybe you should check the permissions issue: sqlplus: error loading shared libraries

PERMISSIONS: I want to emphasize the importance of rights for "sqlplus".

  • For any "other" UNIX user other than the owner / group, in order to be able to run sqlplus and access the ORACLE database, read / execute permissions (rx) are required for these 4 directories:

    $ ORACLE_HOME / bin, $ ORACLE_HOME / lib, $ ORACLE_HOME / oracore, $ ORACLE_HOME / sqlplus

  • Environment. Install them correctly:

    a. ORACLE_HOME (example: ORACLE_HOME=/u01/app/oranpgm/product/12.1.0/PRMNRDEV/ )

    B. LD_LIBRARY_PATH (example: ORACLE_HOME=/u01/app/oranpgm/product/12.1.0/PRMNRDEV/lib )

    C. ORACLE_SID

    D. PATH

      export PATH="$ORACLE_HOME/bin:$PATH"
0
source

More articles:


All Articles