[mod_python] Problem getting my web app to work with remote oracle server

I'm having a frustrating time getting my web app to connect with a 
remote oracle server.
However, from the linux prompt I am able to run oracle commands to 
connect to database.
The error message I get are as follows:

Mod_python error: "PythonHandler mod_python.psp" Traceback (most recent 
call last):

File "apache.py", line 299, in HandlerDispatch result = object(req)
File "/usr/local/lib/python2.4/site-packages/mod_python/psp.py", line 
302, in handler p.run()
File "/usr/local/lib/python2.4/site-packages/mod_python/psp.py", line 
213, in run exec code in global_scope
File "/var/www/html/psp/modinfo.psp", line 58, in ? oracle = 
cx_Oracle.connect(myUid, myPwd, myDsn) *

DatabaseError: ORA-12541: TNS:no listener*

I suspect that it has something to do with the permission of the *apache 
user* defined in the *httpd.conf file*.
Also, I have set the ORACLE_HOME,LD_LIBRARY_PATH and TNS_ADMIN variable 
to load and be initialized on startup. But it does not work!!!


Can someone help me with this?


Wayne




My set up is as follows:

PYTHON 2.4.4c1 (#1, Nov 6 2006, 14:14:48)
operating system  [GCC 3.4.6 20060404 (Red Hat 3.4.6-3)]
 MOD_PYTHON 3.2.10
Apache version 2.0.52


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mm_cfg_has_not_been_edited_to_set_host_domains/pipermail/mod_python/attachments/20080415/287c3b02/attachment.html