[CentOS] Problem with oracle&httpd...

Fri Mar 3 18:47:53 UTC 2006
siva m <tech.sivam at gmail.com>

Hi,
     I have CentOS 4.2 installed on my PC and I've successfully installed
Oracle 10g along with apache web server(httpd) and perl-DBD-Oracle.

     The problem is trying to connect to oracle to oracle from a CGI script.
I defined all of the environment variables(ORACLE_HOME, LD_LIBRARY_PATH,
PERL5LIB) in httpd.conf as well as apachectl scripts but I am getting the
following error in the logs:
=========================================
[Fri Mar 03 00:31:25 2006] [error] [client 192.168.251.6] Can't load
'/usr/lib/perl5/site_perl/5.8.5/i386-linux-thread-multi/auto/DBD/Oracle/Oracle.so'
for module DBD::Oracle: libclntsh.so.10.1: cannot open shared object file:
No such file or directory at
/usr/lib/perl5/5.8.5/i386-linux-thread-multi/DynaLoader.pm line 230.
============================================
Also I disabled SELlinux, defined all of the above mentioned env variables
in /etc/profile but now use.
One weird thing is that as a standalone perl script I can connect to oracle
but not through CGI.

Can any one please suggest what's going wrong or what am I missing?

thanks in advance,
Siv
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.centos.org/pipermail/centos/attachments/20060303/644f4779/attachment-0003.html>