Skip to content
Advertisement

Tag: cx-oracle

cx_Oracle connection type hinting in python

I’m diving into type hints and type hinting some of my code as I think it is a good practice. I have a function that takes both sqlalchemy and cx_Oracle connection/session objects. I was able to figure out the hinting for sqlalchemy here. Poked around some docs trying to figure it out with cx_Oracle to no avail. My code In

“libnnz19.so: cannot open shared object file: No such file or directory

I have installed cx_oracle(python3) and instant client 21_1 inside a container. When I try to first time I got this error 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

cx_Oracle connection fails with ‘DPI-1047: Cannot locate a 64-bit Oracle Client library’

Problem use connection oracle to python source, oracle now is worked to other language php (oci) Error: Code: Answer Update: try the latest version of cx_Oracle see the release announcement. This version (which was renamed python-oracledb) doesn’t need Instant Client so the installation is easier. Here are the cx_Oracle Windows installation instructions, which you probably found from the error message

Advertisement