I have installed cx_oracle(python3) and instant client 21_1 inside a container. When I try to first time I got this error
Cannot locate a 64-bit Oracle Client library: "/python-
env/instantclient_21_1/lib/libclntsh.so:
So I have created lib under /python-env/instantclient_21_1/ and tried again, now I'm getting this error
cx_Oracle.DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library: "libnnz19.so: cannot open shared object file: No such file or directory". See https://cx-oracle.readthedocs.io/en/latest/user_guide/installation.html for help
I don't understand where is it searching for the that so file. It is already present in /python- env/instantclient_21_1/lib/
Please help
[Update: use the latest version of cx_Oracle, which was renamed python-oracledb. See the release announcement]
Follow the Instant Client installation steps or cx_Oracle Installation steps and use ldconfig
to set the library path to include the Instant Client directory.
You could set DPI_DEBUG_LEVEL=64
(see here) to trace how cx_Oracle is looking for the libraries.
Also see Docker for Oracle Database Applications in Node.js and Python.