Python module “cx_Oracle” module could not be found

by 
# - This import requires appropriate oraocciXX.dll to be available in PATH (on windows)
#   (Probably LD_LIBRARY_PATH or LD_LIBRARY_PATH64 on POSIX)
#     where XX is the oracle DB version, e.g. oraocci11.dll for Oracle 11g.
# - This dll is part of the Oracle Instant client pkg available here:
#     http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html
# - Also ensure that python, cx_Oracle and Oracle Client are of same arch (32 or 64-bit)
#
import cx_Oracle

You can find out arch (32 or 64-bit) for:

  • python by just running the python in interactive mode on command line.
  • cx_Oracle: look at the name of downloaded file.
  • Oracle Client:
    • run the sqlplus that’s part of your client package
    • start Task Manager and see if sqlplus.exe has “*32” next to it (=32 bit) or not (=64 bit)
    • if you don’t have sqlplus, use dumpbin /headers oraocciXX.dll
  • If you’re using POSIX you probably would already know. Use file oraocciXX.so

Finally if you still don’t understand here is really for dummies instructions:

  • Ensure you’ve installed 32-bit versions of python, cx_Oracle and Oracle Instant Client. These could also be 64-bit, but must be same for all 3. Can not mix and match. Links:
  • Windows:
    • set PATH=%PATH%;C:\ProgFiles\OraClient\11_2
  • POSIX (Linux/Unix/Solaris…) <– Untested..
    • export LD_LIBRARY_PATH=/path/to/your/32bit/oraocciXX.so
    • (64 bit) export LD_LIBRARY_PATH64=/path/to/your/64bit/oraocciXX.so
  • run path-to-python/python.exe -c "import cx_Oracle" to test whether your setup is working or not.
    • if it prints
    • nothing: then it’s successful.
    • ImportError: DLL load failed: The specified module could not be found: then oraocciXX is not found. Setup the env vars correctly.
    • ImportError: DLL load failed: %1 is not a valid Win32 application: You have a 32/64 bit mismatch.

More Related Contents:

  1. How can I do a batch insert into an Oracle database using Python?
  2. Importing modules from parent folder
  3. How to list all functions in a Python module?
  4. __getattr__ on a module
  5. `from … import` vs `import .` [duplicate]
  6. How to make a cross-module variable?
  7. Execution of Python code with -m option or not
  8. Python: importing a sub‑package or sub‑module
  9. Python pip install module is not found. How to link python to pip location?
  10. What happens when a module is imported twice?
  11. How to import all submodules?
  12. How to create module-wide variables in Python? [duplicate]
  13. PyCharm error: ‘No Module’ when trying to import own module (python script)
  14. Does Python have a package/module management system?
  15. Can’t load Python modules installed via pip from site-packages directory
  16. In Python, can I call the main() of an imported module?
  17. ImportError on python 3, worked fine on python 2.7
  18. ImportError: No module named ‘selenium’
  19. Python: import module from another directory at the same level in project hierarchy
  20. Python importing a module from a parallel directory
  21. how to test if one python module has been imported?
  22. Python: Why should ‘from import *’ be prohibited?
  23. Import module works in terminal but not in IDLE
  24. Python can’t find module in the same folder
  25. How do I extend a python module? Adding new functionality to the `python-twitter` package
  26. Can you define aliases for imported modules in Python?
  27. Python modules with identical names (i.e., reusing standard module names in packages)
  28. python module import – relative paths issue
  29. python import module from parent package
  30. How to reference python package when filename contains a period

Leave a Comment