Objective - execute perl modules from apache that access an oracle database
Oracle database - 10gr2, SUSE SLES9 linux
Apache server - RHAS 4.0, oracle 10gr2 instant client
Perl Version
perl -v
This is perl, v5.8.5 built for i386-linux-thread-multi
Apache Version
apachectl -v
Server version: Apache/2.0.55
Server built: Feb 28 2006 10:15:42
mod_perl, DBI, DBD versions
mod_perl -2.0.2
DBI-1.50
DBD-Oracle 1.17
Apache DBI-0.9901
Error when running perl module from apache error_log file
[Sat Apr 22 20:48:04 2006] emahni.pl: 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: libnnz10.so: 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.
ORACLE_HOME, LD_LIBRARY_PATH ($ORACLE_HOME/lib), TWO_TASK, and
LD_RUN_PATH($ORACLE_HOME/lib:$ORACLE_HOME/rdbms/lib) set in httpd.conf
Running the script from the command line connects to the database and
returns correct results.
I've googled using the following:
module DBD::Oracle: libnnz10.so
The third and fourth google entries look as though they may be helpful
but i'm receiving a "server busy" message.
Anyone got an idea what is on these pages or experienced the same
problem and would like to share a resolution?
Thanks.