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

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 ?

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

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

  1. oci.dll
  2. ociidbc19.dll
  3. ociw32.dll
  4. oramysql19.dll
  5. orannzsbb19.dll
  6. oraocci19.dll
  7. oraocci19d.dll
  8. oraociei19.dll
  9. oraons.dll
  10. 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.

  1. Get the basic package instantClient from Here
  2. 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

Leave a Comment