Search code examples
pythonsetup.pycx-oracle

cx_Oracle installation fails with FileNotFoundError: [WinError 3]

My organisation does not allow me to use pip to install Python libraries, hence i downloaded the zip for cx_Oracle (python-cx_Oracle-master.zip) from GIT and then tried to install it using install command, as below :

python.exe ./setup.py install

However, it immediately fails with below error :

  File ".\setup.py", line 91, in <module>
    for n in sorted(os.listdir(dpiSourceDir)) if n.endswith(".c")]
FileNotFoundError: [WinError 3] The system cannot find the path specified: 'odpi\\src'

I tried to brain storm a lot but could not reach to conclusion. While cx_Oracle is important for me to proceed in my project, i cannot find a way forward. Requesting help from you guys.

I'm on a Windows10 x64 machine, with Python 3.6

Solution

  • You are missing the ODPI-C source code. You need to follow the instructions found in the documentation here.