[CentOS] Problem with oracle&httpd...

[Rick Philbrick]

Hi,

This may not be what your experiencing but when I have Shared Object
problems one of the first places I check is /etc/ld.so.conf  to ensure
that the paths to the .so are present.  Might be worth a look.

If you do a locate for libclntsh.so.10.1 and its in /usr/local/lib
then you probably need to include that path in the ld.so.conf


Rickp

On 3/3/06, Jim Perrin <jperrin at gmail.com> wrote:
> 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
> _______________________________________________
> CentOS mailing list
> CentOS at centos.org
> http://lists.centos.org/mailman/listinfo/centos
>