CentOS - Mar 2006 - Problem with oracle&httpd...

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.html>

On 3/3/06, siva m <tech.sivam at gmail.com> wrote:
> 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?
The httpd env variables are supposed to go in /etc/sysconfig/httpd. Is
that what you mean when you refer to apachectl scripts, or are you
doing something else?


--
"They that can give up essential liberty to obtain a little temporary
safety deserve neither liberty nor safety''
Benjamin Franklin 1775