libclntsh so 11 1 cannot open shared object file

Question

I want to schedule a task on Linux by icrontab  and the task is written in python and have to import cx Oracle module  so I export ORACLE HOME and LD LIBRARY PATH in  bash profile  but it raise the error      libclntsh so 11 1  cannot open shared object file     Since it is ok to run the task by issue the command in shell like   python a py    ok   I change the task in icrontab into a shell script which invoke my Python script  but the exception recurred     the shell script scheduled in icrontab    bash  python a py       Could you help how to do with it

User · Answer

Just pass your Oracle path variables before you run any scripts:
Like for perl you can do add below in beginning of your script:

BEGIN {
   my $ORACLE_HOME     = "/usr/lib/oracle/11.2/client64";
   my $LD_LIBRARY_PATH = "$ORACLE_HOME/lib";
   if ($ENV{ORACLE_HOME} ne $ORACLE_HOME
   || $ENV{LD_LIBRARY_PATH} ne $LD_LIBRARY_PATH
   ) {
      $ENV{ORACLE_HOME}     = "/usr/lib/oracle/11.2/client64";
      $ENV{LD_LIBRARY_PATH} = "$ORACLE_HOME/lib";
      exec { $^X } $^X, $0, @ARGV;
   }
}

User · Answer

The libs are located in   u01 app oracle product 11 2 0 xe lib  For Oracle XE  or similar   You should add this path to  etc ld so conf or if this file shows only an include location  as in a separate file in the  etc ld so conf d directory  I have oracle conf in  etc ld so conf d  just one file with the path  Nothing else   Of course don t forget to run ldconfig as a last step

User · Answer

Cron does not load the user s profile when running a task and you have to include the profile in your shell script explicitly   Example documentation

User · Answer

I always have this problem  I can solve by running the code below  export LD LIBRARY PATH  opt oracle instantclient  LD LIBRARY PATH    OBS  This code I saved in the configuration file because I always use it  good luck

User · Answer

For the benefit of anyone else coming here by far the best thing to do is to update cx Oracle to the latest version  6     This version does not need LD LIBRARY PATH set at all

User · Answer

I had to install the dependency oracle-instantclient12 2-basic-12 2 0 1 0-1 x86 64

User · Answer

I have copied all library files from installer media databases stage ext lib to  ORACLE HOME lib and it resolved the issue

User · Answer

This post helped me solve a similar problem with a PostgreSQL database link to Oracle using oracle fdw   I installed oracle fdw but when I tried CREATE EXTENSION oracle fdw  I got error could not load library libclntsh so 11 1  cannot open shared object file  No such file or directory     I checked  ORACLE HOME   PATH and  LD LIBRARY PATH   It worked only AFTER I put Oracle Shared Library on Linux Shared Library  echo  opt instantclient 11 2  gt  oracle conf ldconfig

User · Answer

probably you need to sudo into an account registered with relevant env settings

User · Answer

I ran into this same problem last weekend when I needed to use cx Oracle   After spending a lot of time trying to modify the LD LIBRARY PATH variable to include the  ORACLE HOME lib directoy  where libclntsh so resides  I ended up solving the problem by creating symbolic links from all the Oracle xlibx so libraries into  lib xlibx so   This certainly isn t the  cleanest  solution  but it has a good chance of working without causing too much trouble    cd  ORACLE HOME lib  for f in  ls     so    do     sudo ln -s  ORACLE HOME lib  f  lib  f   done   After I did that  cx Oracle worked like a charm

User · Answer

Possibly you want to specify PATH     and also ORACLE HOME and LD LIBRARY PATH     so that cron 1  knows where to find binaries  Read  quot 5 Crontab environment quot  here

User · Answer

If you have problem with libclntsh so  need create symlink for libclntsh so from  usr lib oracle 11 2 client64 lib to  usr lib

[oracle] libclntsh.so.11.1: cannot open shared object file.

Examples related to oracle

Examples related to shell

Examples related to cron

Examples related to environment-variables