I have installed Django on Ubuntu 12.04 behind NGINX with uWSGI. I use Postgresql as the main database for the application however I need to retrieve some data from an Oracle database.
I have successfully installed Instant Client and cx_Oracle and I can connect and query the Oracle database successfully from command line scripts and also from ./manage.py shell. However when I run the application via uwsgi I receive the following error:
InterfaceError: Unable to acquire Oracle environment handle
I am puzzled because when I check ORACLE_HOME and LD_LIBRARY_PATH they are correct and available to the environment at that point.
Also I am using instantclient version 220.127.116.11.0 while I am querying an Oracle 10g database.
I have checked a lot of proposed solutions online but nothing seems to work in my case. Anybody has any pointers on what I can try next?
Thanks a lot.