DPI-1047: Cannot locate a 64-bit Oracle Client library:

[pallavisrinivas]

I am able to run this python script manually. Facing this issue while running on cronjob as the same user

conn = cx_Oracle.connect(user=v_db_user, password=v_db_passwd, dsn=dsn_tns)
cx_Oracle.DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library: "libclntsh.so: cannot open shared object file: No such file or directory". See https://oracle.github.io/odpi/doc/installation.html#linux for help

But I do have this file in my instant client. Here are the list of files
sdk
bin
xstreams.jar
BASIC_README
libons.so
libocci.so
rdbms
libocijdbc12.so
adrci
libipc1.so
libmql1.so
SQLPLUS_README
libclntshcore.so.12.1
libocci.so.12.1
uidrvci
ojdbc6.jar
libociei.so
libsqlplus.so
libclntsh.so
libclntshcore.so
genezi
ojdbc7.jar
libsqlplusic.so
libnnz12.so
sqlplus
libclntsh.so.12.1
liboramysql12.so
glogin.sql

[pallavisrinivas]

Output of ldd libclntsh.so

[cjbj]

Cron won't inherit your shell environment variables, e.g. LD_LIBRARY_PATH. This is the kind of reason the installation instructions recommend using ldconfig, where possible.

Or write a shell script that sets the environment variables and then calls Python. Change cron to invoke the shell script.

[pallavisrinivas]

Thanks for the reply. I have got all the Oracle paths in to a file & used source to pass this file in a crontab. This helped me resolve the issue

• • • • • source /home/user/.Oracle [path to python] [path to filename.py]

[sensub]

Or you can do something like this:

• • • • • . /home/xyz/.pyenv && /home/xyz/python-script.py