sqlplus error while loading shared libraries libsqlplus so cannot open shared object file No such file or directory

Question

Please suggest a solution for solving this issue   While giving the command   sqlplus  nolog   the error that occurred    sqlplus  error while loading shared libraries   libsqlplus so  cannot open shared object file  No such file or directory

User · Answer

Don t forget   apt-get install libaio1 libaio-dev   or  yum install libaio

User · Answer

You should already have all needed variables in  etc profile d oracle sh  Make sure you source it     source  etc profile d oracle sh  The file s content looks like   ORACLE HOME  usr lib oracle 11 2 client64 PATH  ORACLE HOME bin  PATH LD LIBRARY PATH  ORACLE HOME lib export ORACLE HOME export LD LIBRARY PATH export PATH   If you don t have it  create it and source it

User · Answer

You can try usage     echo   usr lib oracle 12 2 client64 lib   gt   etc ld so conf d oracle conf   ldconfig   This problem are because oracleinstant client not configure shared library

User · Answer

Could you please check if LD LIBRARY PATH points to the oracle libs

User · Answer

The minimum configuration to properly run sqlplus from the shell is to set ORACLE HOME and LD LIBRARY PATH  For ease of use  you might want to set the PATH accordingly too   Assuming you have unzipped the required archives in  opt oracle instantclient 11 1     export ORACLE HOME  opt oracle instantclient 11 1   export LD LIBRARY PATH   ORACLE HOME    export PATH   ORACLE HOME  PATH     sqlplus  SQL Plus  Release 11 1 0 7 0 - Production on Wed Dec 31 14 06 06 2014

User · Answer

PERMISSIONS  I want to stress the importance of permissions for  sqlplus      For any  Other  UNIX user other than the Owner Group to be able to run sqlplus and access an ORACLE database   read execute permissions are required  rx  for these 4 directories     ORACLE HOME bin    ORACLE HOME lib   ORACLE HOME oracore   ORACLE HOME sqlplus Environment  Set those properly   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

User · Answer

It means you didn t set ORACLE HOME and ORACLE SID variables  Kindly set proper working  ORACLE HOME and  ORACLE SID and after that execute sqlplus  nolog command  It will be working

User · Answer

laryx-decidua  I think you are only seeing the 18 x instant client releases that are in the ol7 oci included repo  The 19 x instant client RPMs  at the moment  are only in the ol7 oracle instantclient repo  Easiest way to access that repo is   yum install oracle-release-el7

User · Answer

sudo sh -c  echo  usr lib oracle 12 2 client64 lib  gt   etc ld so conf d oracle-instantclient conf  sudo ldconfig   from https   help ubuntu com community Oracle 20Instant 20Client

User · Answer

I know it s an old thread  but I got into this once again with Oracle 12c and LD LIBRARY PATH has been set correctly  I have used strace to see what exactly it was looking for and why it failed    strace sqlplus  nolog   sqlplus tries to load this lib from different dirs  some didn t exist in my install  Then it tried the one I already had on my LD LIBRARY PATH      open   oracle product 12 1 0 db 1 lib libsqlplus so   O RDONLY    -1   EACCES  Permission denied    So in my case the lib had 740 permissions  and since my user wasn t an owner or didn t have oracle group assigned I couldn t read it  So simple chmod  r helped

User · Answer

I did solve this error by setting  export LD LIBRARY PATH  LD LIBRARY PATH  ORACLE HOME lib  ORACLE HOME   yes  not only  ORACLE HOME lib but   ORACLE HOME too

User · Answer

On Oracle s own Linux  Version 7 7  PRETTY NAME  Oracle Linux Server 7 7   in  etc os-release   if you installed the 18 3 client libraries with  sudo yum install oracle-instantclient18 3-basic x86 64 sudo yum install oracle-instantclient18 3-sqlplus x86 64   then you need to put the following in your  bash profile   export ORACLE HOME  usr lib oracle 18 3 client64 export LD LIBRARY PATH  LD LIBRARY PATH  ORACLE HOME lib  ORACLE HOME   in order to be able to invoke the SQLPlus client  which  incidentally  is called sqlplus64 on this platform

[linux] sqlplus: error while loading shared libraries: libsqlplus.so: cannot open shared object file: No such file or directory

Examples related to linux

Examples related to oracle

Examples related to installation

Examples related to sqlplus

Examples related to oracleclient