Hi Keith
On 8/23/06, Lam, Keith (MGS) <[EMAIL PROTECTED]> 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"
I searched on google and tried the suggestions from forums but still get
the problem unsolved. These are what I tried:
1. I've added /home/oracle/oracle/product/10.2.0/oraclient/lib to
/etc/ld.so.conf and run "ldconfig" as shown below
2. I put the following environment variables in the configuration file
httpd.conf:
SetEnv LD_LIBRARY_PATH
/home/oracle/oracle/product/10.2.0/oraclient/lib
SetEnv ORACLE_HOME /home/oracle/oracle/product/10.2.0/oraclient
<*SNIPPED*>
4. Making sure all files were accesable and also need to make some links
from the $ORACLE_HOME/lib dir to the */lib dir that perl can access.
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
<*SNIP AGAIN*>
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.
1. There are no DLLs in Linux like in windows,
instead of writing so much text you could have
$perl -c <perlcode.pl> ed the program you tried to run and pasted just the
errors.
However,
Please do a make;make test;make install of Oracle DBD and DBI
CGI is for the webinterface and DBI for the database so when problem is with
the Database
you probably need not mention the CGI issues in the mail.
and I think if you do DBD and DBI Install everything will be solved.
if now ... we are here to troubleshoot.
"Google is my Best friend, But I think I will ask the RIGHT Question at
RIGHT TIME as I know he is tricky"
Thanks,
Keith Lam
Corporate Security (IPC)
Tel: 416-327-1941
--
Best,
Vasundhar
--
If Physics is my God, Linux is my Girlfriend.
I go to the temple of biology to understand God with my girlfriend. ;) [Some
call it Bioinformatics]
