[cx-oracle-users] using cx_Oracle with django, apache mod_wsgi

[pablo p. <pab...@gm...>]

Hi,

I've installed oracle xe database and client on oracle enterprise linux 5.
I 've installed cx_Oracle with:
export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$ORACLE_HOME/bin:$PATH
sudo -E easy_install cx_Oracle

I can use the django dev server with:
export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server/
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$ORACLE_HOME/bin:$PATH
python manage.py runserver

When I'm trying to use Apache with mod_wsgi I'm getting:
ImproperlyConfigured: Error loading cx_Oracle module: libclntsh.so.10.1:
cannot open shared object file: No such file or directory

I'm getting this error because the environment variables are not set for the
Apache user.
How do I set them?
I've tried searching the web but the solution didn't work for me.


When using the 11g server (not xe) do I need to install anything else in
order to install cx_Oracle with easy_install?
If I need some client, will this be enough
http://www.oracle.com/technology/software/products/sql/index.html  ?
If not, what client do I need to install?

Thanks