[Solved] DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library: “The specified module could not be found”

Hello Guys, How are you all? Hope You all Are Fine. Today When I am trying to access SQL in jupyter notebook I am facing following error DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library: “The specified module could not be found” in python. So Here I am Explain to you all the possible solutions here.

Without wasting your time, Let’s start This Article to Solve This Error.

How DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library: “The specified module could not be found” Error Occurs ?

When I am trying to access SQL in jupyter notebook I am facing following error.

DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library: "The specified module could not be found"

How To Solve DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library: “The specified module could not be found” Error ?

Solution 1: Copy and paste following files

First of all Download oracle instantClient From Here for 64-bit version.

Then Copy All File that I am suggesting.

1. oci.dll
2. ociidbc19.dll
3. ociw32.dll
4. oramysql19.dll
5. orannzsbb19.dll
6. oraocci19.dll
7. oraocci19d.dll
8. oraociei19.dll
9. oraons.dll
10. orasql19.dll

Now Just copy all files and paste it to given location.

C:\Program Files\Python37

Your Path maybe different.

Solution 2: install cx_Oracle

First of all install install cx_Oracle using this command.

python -m pip install cx_Oracle --upgrade

Now Just download Oracle Basic Client and Extract It.

Then just Inform cx_Oracle module about the Instatnt Client location.

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

And now Your error should be resolved.

Solution 3: Follow this step.

1. Get the basic package instantClient from Here
2. Extract and copy all the *.dll files and paste it to Anaconda3 folder where you have python.exe.

Summary

It’s all About this issue. Hope all solution helped you a lot. Comment below Your thoughts and your queries. Also, Comment below which solution worked for you?

Also, Read

• ssl.SSLError: [SSL: WRONG_VERSION_NUMBER] wrong version number (_ssl.c:1056)