RE: Problem on Perl DBI for Oracle-DBD-1.18

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
Philip
.