close

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

  1. 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” Error First of All Download Download 64-bit version of oracle instantClient from Here. Then Extract zip and Copy all file. Copy the dll files in the instantclient directory to the python directory, at C:\Program Files\Python37\. Thats it Now your error must be solved. Second solution is 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. Now Your error must be solved.

  2. 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” Error First of All Download Download 64-bit version of oracle instantClient from Here. Then Extract zip and Copy all file. Copy the dll files in the instantclient directory to the python directory, at C:\Program Files\Python37\. Thats it Now your error must be solved. Second solution is 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. Now Your error must be solved.

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

Please Rate Our Solution to Motivate Us For Give Our Best

Leave a Comment