[CentOS] Problem with oracle&httpd...

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

Hi,
     I've tried using both the ways:  I set ORACLE_HOME, LD_PATH_LIBRARY and
PERL5LIB paths in
/etc/sysconfig/httpd and restarted the server. But it didn't work and also
tried including the ORACLE_HOME/lib inside ld.so.sonf but even that too
didn't work. Please suggest if anything I am missing out.

thanks,
-siv



On 3/3/06, siva m <tech.sivam at gmail.com> wrote:
>
> I'll try both the ways(include library path in /etc/ld.so.conf and env
> variables in /etc/sysconfig/httpd). I'll let you know the results.
>
> thanks again,
> -siva
>
>
> On 3/3/06, Rick Philbrick <rickphilbrick at gmail.com> wrote:
> >
> > 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
> > >
> > _______________________________________________
> > CentOS mailing list
> > CentOS at centos.org
> > http://lists.centos.org/mailman/listinfo/centos
> >
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.centos.org/pipermail/centos/attachments/20060303/ef81d85e/attachment-0005.html>