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 ?
- 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
- Solution 2: install cx_Oracle
- Solution 3: Follow this step.
- Summary
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 ?
How To Solve DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library: “The specified module could not be found” Error ?
To Solve DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library: “The specified module could not be found” 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.
DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library: “The specified module could not be found”
To Solve DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library: “The specified module could not be found” 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.
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.
- oci.dll
- ociidbc19.dll
- ociw32.dll
- oramysql19.dll
- orannzsbb19.dll
- oraocci19.dll
- oraocci19d.dll
- oraociei19.dll
- oraons.dll
- 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.
- Get the basic package instantClient from Here
- 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