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 >