Front page | perl.dbi.users |
Postings from August 2006
Lam, Keith (MGS) wrote: > Hi DBI experts, > > Could you please help me to resolve this Perl Oracle DBD problem. > > I am using Oracle Client 10g, Perl 5.8.5 (default from RedHat ES4 > installation) and Oracle-DBD-1.18. > > The SQLPLUS and Perl cgi program runs and displays output as expected > without any errors from the command line > > I have the following error when running perl CGI script using Oracle > DBD from the web browser: > > "install_driver(Oracle) failed: 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. > at (eval 1) line 3 Compilation failed in require at (eval 1) line 3. > Perhaps a required shared library or dll isn't installed where > expected" [snip] > > 5. All authority/access and symbolic links for libclntsh.so.10.1, > libclntsh.so, libocci.so.10.1 and libocci.so are set up properly in > /home/oracle/oracle/product/10.2.0/oraclient/lib What are the permissions on that directory itself. If you su to nobody (or whoever your server runs as), can you cd into that dir? > Could you please suggest me what else I should try to resolve this > problem? I searched on google extensively but found no other sources > of solutions beside those listed above. If you're using Apache, you can start it with the -X option to run in single-process debug mode. That will make it easier to use the LD_DEBUG environment variable to track down your problem. # dumps actual library search paths LD_DEBUG=libs httpd -X After the server has started up, you can hit the web page that will load DBD::Oracle, at which point you should see the search path that ld is using to find the library. Regards PhilipThread Previous | Thread Next