Good afternoon:
We've been having some trouble with our web servers' database
connections. About once a day, our logs will be flooded with the
following error message.
[Fri Sep 17 12:38:11 1999] [error] DBD::Oracle initialisation failed:
Can't locate auto/DBD/Oracle/ORA_OCI.al in @INC (@INC contains:
/raid/staging/modules /www/modules /www/modules
/usr/local/lib/perl5/5.00503/sun4-solaris /usr/local/lib/perl5/5.00503
/usr/local/lib/perl5/site_perl/5.005/sun4-solaris
/usr/local/lib/perl5/site_perl/5.005 . /usr/local/apache-1.3.9/
/usr/local/apache-1.3.9/lib/perl) at
/usr/local/lib/perl5/site_perl/5.005/sun4-solaris/DBD/Oracle.pm line 48.
The /raid/staging/modules and /www/modules directories have been added
to @INC via "use lib" for in-house Perl modules.
The above error occurs when users are unable to establish a connection
to our Oracle database due to a high number of TNS connections being
open at the same time. What is this ORA_OCI.al file, and what
information does it contain? Should DBD::Oracle have installed it when
the module was built? It seems to me that the only logical place for
the file to be is in the
/usr/local/lib/perl5/site_perl/5.005/sun4-solaris/auto/DBD/Oracle/
directory, since that's where the Oracle.bs and Oracle.so files reside
for DBD::Oracle. But it's not there, nor can I find it anywhere else on
our system.
Can anyone shed some light on this ORA_OCI.al file for me?
System Specifics:
Solaris 2.7
Perl 5.005_03
Apache 1.3.9
mod_perl 1.21
DBI 1.13
DBD::Oracle 1.03
Thanks in advance for your help.
- Simon
*************************************************************
Simon D. Miner
Web Developer
Christian Book Distributors
http://www.christianbook.com
*************************************************************