Re: dbi-users@perl.org
- From: Roberto Quijalvo <Bert@xxxxxxxxxxxx>
- Date: Mon, 10 Jul 2006 09:43:02 -0600
Philip Garrett wrote:
-----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
This works for me.
What's the solution when you're calling the script as a CGI-BIN script on a webserver? Is there a way to set that environment variable for LD_LIBRARY_PATH so that the perl script can see the path? I've resorted to layering in another Perl Script with $ENV{'LD_LIBRARY_PATH'}=xxxxx
which then calls the script which does the real work.
There must be a better way!
Bert
.
- Prev by Date: Re: dbi-users@perl.org
- Next by Date: problems to connect to a mysql-database
- Previous by thread: Re: dbi-users@perl.org
- Next by thread: problems to connect to a mysql-database
- Index(es):
Relevant Pages
|
|
