We had some strange connection problems like this before. Our most
common error was about the 'hostdef extension not found'..
We found that we could get around this by using fully qualified oracle
database connection identifiers, instead of using the entry that
appears in tnsnames.ora, for example:
dbi:Oracle:web becomes something like this
dbi:Oracle:(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=...... )))
It's worked like a champ since then... I'm not sure why it works,
probably because I've removed a few layers of indirection.. Either
that or some environment variable is getting corrupted..
On Mon, May 22, 2000 at 06:36:54PM -0700, Ian Kallen wrote:
>
> I've done everything I can think of to shore up any DB connection
> flakiness but I'm still plagued by errors such as these:
> DBD::Oracle::db selectcol_arrayref failed: ORA-12571: TNS:packet writer
> failure
> ...this is only a problem under mod_perl, outside of the
> mod_perl/Apache::DBI environment everything seems fine. Once the db
> connection is in this state, it's useless until the server gets a restart.
>
> My connect strings look good and agree, I put Stas' ping method in the
> DBD::Oracle::db package, set a low timeout, called Oracle (they don't
> want to hear about it). Everything is the latest versions of
> mod_perl/Apache/DBI/DBD::Oracle connecting to an Oracle 8.1.5 db on
> Solaris. Is Apache::DBI not up to it? (it looks simple enough)
>
> Maybe there's a better persistent connection method I should be looking
> at?
>
> --
> Salon Internet http://www.salon.com/
> Manager, Software and Systems "Livin' La Vida Unix!"
> Ian Kallen <[EMAIL PROTECTED]> / AIM: iankallen / Fax: (415) 354-3326
--
Paul Lindner
[EMAIL PROTECTED]
Red Hat Inc.
San Francisco, USA
