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

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

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 have copied all library files from installer media databases stage ext lib to  ORACLE HOME lib and it resolved the issue

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

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

User · Answer

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

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

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

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

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

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

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