Re: [cx-oracle-users] DLL load failed

[Anthony T. <ant...@gm...>]

Yes, installing Instant Client 12 will work for you. However, do not set
ORACLE_HOME. On Windows you should simply put the location of OCI.DLL in
your PATH environment variable. And in your case, ensure that it is before
your other Oracle installation.

This link gives the information on which Oracle client and server
combinations are supported. It is part of the ODPI-C library which will be
the underlying library used as of cx_Oracle 6.

https://oracle.github.io/odpi/doc/installation.html#oracle-client-and-database-versions

Anthony

On Fri, Apr 14, 2017 at 1:48 AM, Dominique DEXHEIMER <
dom...@to...> wrote:

> dependencywalker helped pinpoint the sore muscle, which is finding
> OCI.DLL. However it may just be a back compatibility issue. I have Oracle
> Client 10.2 while the oldest version of cx_Oracle is 11g.  I looked up
> previous posts for compatibility issues, but could not find anything
> helpful.
>
>
>
> My best bet is to install Instant Client 12 and give it precedence over
> the other client installed by pointing ORACLE_HOME to it.
>
>
>
> Thanks and regards,
>
> Dominique
>
>
>
> *From:* Massa, Harald Armin [mailto:ch...@gh...]
> *Sent:* jeudi 13 avril 2017 18:26
> *To:* cx-...@li...
> *Subject:* Re: [cx-oracle-users] DLL load failed
>
>
>
> Hi,
>
>
>
> I have run the installer cx_Oracle-5.2.1-12c.win-amd64-py2.7.exe on a
> Dell Precision T5610, running Windows7 64 bits, with apparent success: the
> compiled file cx_Oracle.pyd is in place under the site-packages directory.
> However, it seems that Python misses parts of the module (see session
>  below), even after appending a line to sys.path. Would there be another
> module registration to write somewhere before running it ?
>
>
>
> >>> import cx_Oracle
>
>
>
> Traceback (most recent call last):
>
>   File "<pyshell#0>", line 1, in <module>
>
>     import cx_Oracle
>
> ImportError: DLL load failed: The specified module could not be found.
>
> >>>
>
>
>
> most likely you are missing the Oracle OCI libary in the fitting 12c
> version. They have to be downloaded and licenced with Oracle.
>
>
>
> Make sure cx_Oracle is able to find them, usefull things are:
>
> - have the bin directory in your path
>
> - have the oracle environment variables set correctly.
>
>
>
> Usefull tool to diagnose:
>
> http://www.dependencywalker.com/
>
>
>
> Cheers,
>
>
>
> Harald
>
>
>
>
>
>
>
>
>
> --
>
>
>
> GHUM GmbH
> Harald Armin Massa
> Spielberger Straße 49
> 70435 Stuttgart
> 0173/9409607
>
> Amtsgericht Stuttgart, HRB 734971
>
> ------------------------------------------------------------
> ------------------
> Check out the vibrant tech community on one of the world's most
> engaging tech sites, Slashdot.org! http://sdm.link/slashdot
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>
>