RE: dbi-users@perl.org

-----Original Message-----
From: Lihong Sun [mailto:lihong_sun88@xxxxxxxxx]
Sent: Monday, June 26, 2006 2:49 PM
To: dbi-users@xxxxxxxx
Subject: dbi-users@xxxxxxxx

Dear folks,

I have a question for you here. I just installed DBI and Oracle DBD
module. I tried a test script but got the following errors:

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.9.0: 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 3) line 3 Compilation failed in
require at (eval 3) line 3. Perhaps a required shared library or dll
isn't installed where expected at lsun.pl line 7

Does anyone know what is wrong? I could login to the database using
sqlplus username/password@sid

Try this before running your script:
export LD_LIBRARY_PATH="$ORACLE_HOME/lib:$LD_LIBRARY_PATH"

That should help it to find the library.

Philip
.