[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 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 ?

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 this dll

1. First of All Download Download 64-bit version of oracle instantClient from Here.
2. Then Extract zip and Copy This all file.
   • oci.dll
   • ocijdbc19.dll
   • ociw32.dll
   • oramysql19.dll
   • orannzsbb19.dll
   • oraocci19.dll
   • oraocci19d.dll
   • oraociei19.dll
   • oraons.dll
   • orasql19.dll
3. Copy the dll files in the instantclient directory to the python directory, at C:\Program Files\Python37\
4. That is it!

Solution 2: install cx_Oracle

First of all install cx_Oracle. Use this command to install.

python -m pip install cx_Oracle --upgrade

Then 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.

Now, Inform cx_Oracle module about the Instatnt Client location.

For Example Here is my code.

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

Now Your error must be solved.

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

• OSError: [E050] Can’t find model ‘en_core_web_sm’. It doesn’t seem to be a shortcut link, a Python package or a valid path to a data directory