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