Re: [cx-oracle-users] libclntsh.so and setup.py

[Mark H. <mh...@pi...>]

On 2/9/12 1:26 AM, Aurélien Vallée wrote:
> Hello,
>
> Just a question, why does cx_Oracle lookup for libclntsh.so in $ORACLE_HOME and fail if not found?
> I have my libclntsh.so installed in /usr/local/lib, which means i basically need to
>
> export ORACLE_HOME=/usr/local
> pip install cx_Oracle
> export ORACLE_HOME=/usr/local/share/oracle11
>
> Every time I need to install cx_Oracle - which is a pain since i need to deploy a alot of python applications needing cx_Oracle in virtualens.

We use the oracle instantclient on mac and linux (by your libclntsh.so filename, I'm
guessing this may be linux?).

We install like this:

- all lib*.so to /usr/lib
- all headers to /usr/include
- sqlplus to /usr/bin
- tnsnames.ora to /etc


This will allow oracle clients to run nicely without setting any environment
variables.  Build cx_Oracle in this environment, and it will pick up the
proper include files and libraries without problem.

Hope this helps!
Markk