DBD module loading problem

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.

Re: DBD module loading problem

One more thing - all perl makefile.pl, make, make test, & make install,
were successful for mod_perl, DBI, & DBD

Kevin Moore wrote:

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

RE: DBD module loading problem

------_=_NextPart_001_01C6669B.586E9D76
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

> ------------------------------------------------------------ ---------
> From: Kevin Moore [mailto:kmoore@esntech.com]
> Sent: Sun 4/23/2006 12:15 AM
> To: dbi-users@perl.org
> Subject: DBD module loading problem
>=20
>=20
> Objective - execute perl modules from apache that access an oracle
> database
>=20
> Oracle database - 10gr2, SUSE SLES9 linux
> Apache server - RHAS 4.0, oracle 10gr2 instant client
>=20
> Perl Version
> perl -v
> This is perl, v5.8.5 built for i386-linux-thread-multi
>=20
> Apache Version
> apachectl -v
> Server version: Apache/2.0.55
> Server built: Feb 28 2006 10:15:42
>=20
> mod_perl, DBI, DBD versions
>=20
> mod_perl -2.0.2
> DBI-1.50
> DBD-Oracle 1.17
> Apache DBI-0.9901
>=20
> Error when running perl module from apache error_log file
>=20
> [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

Have you added PassEnv and PerlPassEnv directives for all of these
variables?

You'll need them for things to work right. See:
http://tinyurl.com/kunxp [httpd.apache.org]
http://tinyurl.com/jr7dw [perl.apache.org]

hth,
Philip



------_=_NextPart_001_01C6669B.586E9D76--