Today We are Going To Solve DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library: “The specified module could not be found” in Python. Here we will Discuss All Possible Solutions and How this error Occurs So let’s get started with this Article.
Contents
How to Fix DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library: “The specified module could not be found” Error?
- How to Fix DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library: “The specified module could not be found” Error?
To Fix DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library: “The specified module could not be found” Error just Set the Oracle Instant Client. First of all, check the compatibility of your OS, Python and Oracle Instant Client architecture:
import platform platform.architecture()
And then set the Oracle Instant Client inside your jupyter notebook:import os os.environ["PATH"] = "Complete Location of Instant Client Folder" + ";" + os.environ["PATH"]
- DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library: “The specified module could not be found”
To Fix DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library: “The specified module could not be found” Error just Install cx_Oracle. First of all, install cx_Oracle
python -m pip install cx_Oracle --upgrade
Then just download and extract Oracle Basic Client and Inform cx_Oracle module about the Instatnt Client location.import cx_Oracle cx_Oracle.init_oracle_client(lib_dir=r"C:\oracle\instantclient_19_9")
This will solve your error.
Solution 1 : Set the Oracle Instant Client
First of all, check the compatibility of your OS, Python and Oracle Instant Client architecture:
import platform
platform.architecture()
And then set the Oracle Instant Client inside your jupyter notebook:
import os
os.environ["PATH"] = "Complete Location of Instant Client Folder" + ";" + os.environ["PATH"]
Solution 2 : Install cx_Oracle
First of all, install cx_Oracle
python -m pip install cx_Oracle --upgrade
Then just download and extract Oracle Basic Client and Inform cx_Oracle module about the Instatnt Client location.
import cx_Oracle
cx_Oracle.init_oracle_client(lib_dir=r"C:\oracle\instantclient_19_9")
This will solve your error.
Conclusion
So these were all possible solutions to this error. I hope your error has been solved by this article. In the comments, tell us which solution worked? If you liked our article, please share it on your social media and comment on your suggestions. Thank you.
Also Read These Solutions
- Invalid hook call. Hooks can only be called inside of the body of a function component
- Attempted import error: ‘firebase/app’ does not contain a default export (imported as ‘firebase’)
- unexpected disconnect while reading sideband packet fatal: the remote end hung up unexpectedly
- Using / for division is deprecated and will be removed in Dart Sass 2.0.0 in Nuxtjs
- accessible: module java.base does not “opens java.io” to unnamed module