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@xxxxxxxxx> 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@xxxxxxxxx> wrote: > > On 3/3/06, siva m <tech.sivam@xxxxxxxxx> 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@xxxxxxxxxx > > http://lists.centos.org/mailman/listinfo/centos > > > _______________________________________________ > CentOS mailing list > CentOS@xxxxxxxxxx > http://lists.centos.org/mailman/listinfo/centos > -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.centos.org/pipermail/centos/attachments/20060303/20dabbcf/attachment.htm