On 3/3/06, siva m tech.sivam@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