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

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.

How to Fix DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library: “The specified module could not be found” 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