hmmm... since nobody else has anything to say about it...
I don't know about the ORA_OCI.al file. However, if you have traced the
problem to no TNS service available, you could probably use Apache::DBI to
make persistent connections per httpd process, then tune the number of
processes (MaxClients) to a number of TNS sessions less than that which
causes the problem. Are you using Apache::DBI?
there might be another way around this by tuning your listener or something.
I wonder if someone knows the max number of open connections Oracle can
handle, and if it is adjustable?
Also, I know some people recommend seperating your normal httpd server from
one that is DBI enabled, using some type of DBI proxy, which may help limit
the number of open connections. It's not something that I do, however, so
maybe others can help more.
I hope some of this is helpful...
best of luck
--Geoff
> -----Original Message-----
> From: Simon Miner [SMTP:[EMAIL PROTECTED]]
> Sent: Monday, October 11, 1999 1:00 PM
> To: 'mod_perl Mailing List'; 'DBI Users Mailing List'
> Cc: Simon Miner; Robb Rosell; Win Mattina
> Subject: Missing ORA_OCI.al file
>
> 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
> *************************************************************
