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

Question

I installed the library and when trying to access SQL in jupyter notebook with my credentials the following error appears:

DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library: "The specified module could not be found". See https://oracle.github.io/odpi/doc/installation.html#windows for help

That error suggests that you haven't installed a library properly. Did you follow the link it gave you? — TechPerson, May 13 '19 at 20:30
Check that Python, cx_Oracle and your Oracle Client libraries are all 64-bit or all 32-bit. How do i check this? — Rexilife, May 13 '19 at 20:49
The error message already tells you you have a 64-bit Python. Follow the instructions in the URL in the message — Christopher Jones, May 14 '19 at 01:24

score 40 · Answer 1 · answered Oct 21 '20 at 15:35

40

The easiest solution is as follows:

Download 64-bit version of oracle instantClient from: https://www.oracle.com/database/technologies/instant-client/winx64-64-downloads.html
Copy the dll files in the instantclient directory to the python directory, as shown below

That is it!

answered Oct 21 '20 at 15:35

Naik

787
7
13

1

That's very useful. Is there a simple way to get the same issue to resolve in UNIX ? – user29496 Nov 18 '20 at 13:49
1

On Linux you have to set the library search path (e.g with ldconfig or LD_LIBRARY_PATH - see the Instant Client installation instructions on the download page) before the Python process starts – Christopher Jones Nov 28 '20 at 01:25
2

@Naik: This is a bad practice. Instead pass the location of the library files to Python as outlined in the cx_Oracle [documentation](https://cx-oracle.readthedocs.io/en/latest/user_guide/initialization.html#using-cx-oracle-init-oracle-client-to-set-the-oracle-client-directory). See my answer below for details. – Stan Nov 30 '20 at 22:02
@Stan Thanks for your comment. But that did not work for me! – Naik Dec 02 '20 at 01:58
4

Using `init_oracle_client(lib_dir=...)` works on Windows and macOS but won't work on Linux. This is documented. – Christopher Jones Jan 29 '21 at 04:39
Didn"t like this hack, but this is the easiest solution I came over with. – Musa Feb 23 '21 at 05:37
This solution worked for me, why is this bad practice? – bart cubrich Oct 18 '21 at 16:53

score 27 · Answer 2 · edited Mar 16 '22 at 22:50

The short answer is: cx_Oracle.init_oracle_client(lib_dir= r"c:\path_to_libraries")

Here are the steps that I followed to solve this same issue:

If you have not already installed cx_Oracle you can do so with the following command:
python -m pip install cx_Oracle --upgrade

The cx_Oracle documentation can be found here.

Use the following commands to verify that everything is installed and recognized:

import sqlalchemy as sqla
import pandas as pd
import cx_Oracle

# Test to see if it will print the version of sqlalchemy
print(sqla.__version__)    # this returns 1.2.15 for me

# Test to see if the cx_Oracle is recognized
print(cx_Oracle.version)   # this returns 8.0.1 for me

# This fails for me at this point but will succeed after the solution described below
cx_Oracle.clientversion()

At this point I get errors saying the libraries cannot be located. Here is the solution:

import os
import platform

# This is the path to the ORACLE client files
lib_dir = r"C:\put_your_path_here\instantclient-basic-windows.x64- 19.9.0.0.0dbru\instantclient_19_9"

# Diagnostic output to verify 64 bit arch and list files
print("ARCH:", platform.architecture())
print("FILES AT lib_dir:")
for name in os.listdir(lib_dir):
    print(name)

Be sure to update the lib_dir path specific to your installation. If you have the correct path, you should see a listing of all the Oracle files like: (adrci.exe, oci.dll, oci.sym, etc). This is the location that Python needs to be able to find the Oracle drivers.

The current (Nov 2020) standard way for passing the location of the Oracle libraries for Windows is cx_Oracle.init_oracle_client(lib_dir= r"c:\path_to_libraries"). Here is an example:

lib_dir = r"C:\put_your_path_here\instantclient-basic-windows.x64- 19.9.0.0.0dbru\instantclient_19_9"

try:
    cx_Oracle.init_oracle_client(lib_dir=lib_dir)
except Exception as err:
    print("Error connecting: cx_Oracle.init_oracle_client()")
    print(err);
    sys.exit(1);

At this point I can run the following code without any errors:

# This works after passing the lib_dir path
cx_Oracle.clientversion()    # For me it returns: (19, 9, 0, 0, 0)

DEPRECATED Here is how to update the PATH variable temporarily:

The following works, but using cx_Oracle.init_oracle_client(lib_dir= r"c:\path_to_libraries") is now the preferred way.

import os   
# Manually append the location of the ORACLE libraries to the PATH variable
os.environ["PATH"] = lib_dir + ";" + os.environ["PATH"]

The new 'standard' is to use cx_Oracle 8's `init_oracle_client()` instead of setting PATH - see https://cx-oracle.readthedocs.io/en/latest/user_guide/initialization.html — Christopher Jones, Nov 28 '20 at 01:26

score 11 · Answer 3 · answered Jan 28 '21 at 23:22

As per documentation accessed on cx_Oracle page.

Step 1: install cx_Oracle

python -m pip install cx_Oracle --upgrade

Step 2: Download and extract Oracle Basic Client

For Windows download and extract Oracle Basic Instatnt client instantclient-basic-windows.x64-19.9.0.0.0dbru.zip file.

Step 3: Inform cx_Oracle module about the Instatnt Client location.

If you stick to documentation and extract them in c:\oracle folder then your script may look like this.

    import cx_Oracle
    cx_Oracle.init_oracle_client(lib_dir=r"C:\oracle\instantclient_19_9")

Now you will be free from the error.

score 2 · Answer 4 · answered Dec 15 '19 at 17:15

Make sure you have installed the correct oracle client (you can find the oracle client package from here "https://www.oracle.com/in/database/technologies/instant-client/winx64-64-downloads.html" and add the downloaded folder inside the folder where python is installed and then add this location (location of your client package folder) to system's environment variable. Hope that will work.

score 2 · Answer 5 · answered Oct 10 '20 at 12:53

2

I suggest you to first check the compatibility of your OS, Python and Oracle Instant Client architecture:

import platform
platform.architecture()

Then, I definitely advise you to set the Oracle Instant Client inside your jupyter notebook:

import os
os.environ["PATH"] = "Complete Location of Instant Client Folder" + ";" + os.environ["PATH"]

answered Oct 10 '20 at 12:53

Mohammad-Reza Malekpour

337
3
8

2

Note PATH is only for Windows. And it has been superseded by using cx_Oracle 8's `init_oracle_client(lib_dir=xxx)` (which is useful on Windows and macOS) – Christopher Jones Nov 28 '20 at 01:24

score 2 · Answer 6 · answered Mar 26 '21 at 03:40

2

I faced this error in Anconda Spyder.

This is how I fixed it.

Get the basic package instantClient from: https://www.oracle.com/database/technologies/instant-client/winx64-64-downloads.html
Extract and copy all the *.dll files and paste it to Anaconda3 folder where you have python.exe.

answered Mar 26 '21 at 03:40

dhina karan

131
1
3

1

With cx_Oracle 8 on Windows, I'd recommend using [`init_oracle_client()`](https://cx-oracle.readthedocs.io/en/latest/user_guide/initialization.html#using-cx-oracle-init-oracle-client-to-set-the-oracle-client-directory) since you can keep Instant Client & Python separate. – Christopher Jones Mar 26 '21 at 23:31

Priyank Pathak · Answer 7 · 2021-06-10T19:38:33.710

For MAC

After you do : python -m pip install cx_Oracle --upgrade

try:

import cx_Oracle
# Test to see if the cx_Oracle is recognized
print(cx_Oracle.version)   # this returns 8.0.1 for me

# This fails for me at this point but will succeed after the solution described below
cx_Oracle.clientversion()

if you encounter issues like :

Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
cx_Oracle.DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library: "dlopen(libclntsh.dylib, 1): image not found". See https://cx-oracle.readthedocs.io/en/latest/user_guide/installation.html for help

Follow the step highlighted here: https://cx-oracle.readthedocs.io/en/latest/user_guide/installation.html#manual-installation

Manual Installation

Download the Basic 64-bit DMG from Oracle. (https://www.oracle.com/database/technologies/instant-client/macos-intel-x86-downloads.html)
Mount the dng
Open the mounted dng, and run ./install_ic.sh (via terminal) e.g. : cd /Volumes/instantclient-basic-macos.x64-19.8.0.0.0dbru/ && ./install_ic.sh
In Finder, eject the mounted Instant Client package.

Re-run the oracle connection.

import cx_Oracle

cx_Oracle.init_oracle_client(lib_dir="/Users/priyank.pathak/Downloads/instantclient_19_8")
## cx_Oracle.init_oracle_client(lib_dir="/Users/your_username/Downloads/instantclient_19_8")

cx_Oracle.clientversion()

Can you update your solution and replace the pip install of mysql packages with the relevant cx_Oracle install? Also, the instructions miss the important step of how cx_Oracle knows where Instant Client is: on macOS use `init_oracle_client()` — Christopher Jones, Jun 09 '21 at 23:00
This works. Note that the command `./install_ic.sh` does nothing but move everything from that directory to the `Downloads` folder of your mac. Now we have to manually add this path in the program using the command `init_oracle_client()` as shown in the answer. — misteeque, Sep 28 '21 at 11:44
I am following these instructions on Mac but still getting he following error: DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library: "dlopen(libclntsh.dylib, 0x0001): tried: 'libclntsh.dylib' (no such file), '/usr/lib/libclntsh.dylib' (no such file), '/Users/balikuma/Desktop/libclntsh.dylib' (no such file)". — Vikram, Apr 25 '22 at 15:44

score 0 · Answer 8 · answered Aug 01 '19 at 18:12

Probably you have installed cx_Oracle Python library. In order to execute the DB connectivity through jupyter notebook, you need to install the Oracle Client and that is what missing in your scenario. Please follow the steps from below link and and install Oracle Client and this will solve your problem: https://oracle.github.io/odpi/doc/installation.html#windows

score 0 · Answer 9 · answered Nov 20 '21 at 03:02

I went into the same problem but on Arch Linux, running in NodeJS. Some of the answers here helped me in searching for the official installation guide. Then I followed these steps and they worked for me: https://oracle.github.io/node-oracledb/INSTALL.html#instzip , hope it could help someone else too.

Download Instant Client Basic Light Package (ZIP) (Linux) https://www.oracle.com/database/technologies/instant-client/linux-x86-64-downloads.html

Create folder and unzip into it

mkdir /opt/oracle
unzip ~/Downloads/instantclient-basiclite-linux.x64-21.4.0.0.0dbru.zip -d /opt/oracle/

Then, according to the docs, execute these commands below:

If there is no other Oracle software on the machine that will be impacted, then permanently add Instant Client to the run-time link path. For example, if the Basic package unzipped to /opt/oracle/instantclient_19_11, then run the following using sudo or as the root user
```
sudo sh -c "echo /opt/oracle/instantclient_19_11 > /etc/ld.so.conf.d/oracle-instantclient.conf"
sudo ldconfig
```
OR

Alternatively, every shell running Node.js will need to have the link path set:
```
export LD_LIBRARY_PATH=/opt/oracle/instantclient_19_11:$LD_LIBRARY_PATH
```

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

9 Answers9

Linked

Related