cx_Oracle error. DPI-1047: Cannot locate a 64-bit Oracle Client library

python python-3.x windows-10 cx-oracle
Rexilife picture Rexilife · May 13, 2019 · Viewed 42.7k times · Source

I installed the library and when trying to access SQL in jupyter notebook with my credentials the following error appears:

DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library: "The specified module could not be found". See https://oracle.github.io/odpi/doc/installation.html#windows for help

Answer

Naik picture Naik · Oct 21, 2020

The easiest solution is as follows:

  1. Download 64-bit version of oracle instantClient from: https://www.oracle.com/database/technologies/instant-client/winx64-64-downloads.html
  2. Copy the dll files in the instantclient directory to the python directory, as shown below

enter image description here

enter image description here

That is it!

Related questions

Conda command is not recognized on Windows 10

I installed Anaconda 4.4.0 (Python 3.6 version) on Windows 10 by following the instructions here: https://www.continuum.io/downloads. However, when I open the Command prompt window and try to write conda list I get the 'conda' command is not recognized... error. …

Read More
Anaconda Installed but Cannot Launch Navigator

Anaconda (listed as "Python 3.6.0 (Anaconda 4.3.1 64 bit)" ) is in my programs and features list, but there is seeming no Anaconda Navigator desktop app, as their seems to be no icon on my desktop and I am unable to search for it …

Read More
PermissionError: [WinError 5] Access is denied: 'C:\\Program Files\\Anaconda3\\pkgs\\vs2015_runtime-14.0.25123-0.tmp

Conda newbie here! How can I solve this problem? C:\Users\mona>conda create --name universe-starter-agent python=3.5 Fetching package metadata ......... Solving package specifications: .......... Package plan for installation in environment C:\Users\mona\.conda\envs\universe-starter-agent: The following packages will …

Read More