I can second that...
I've had the listener time out and the httpd process never picks up a new
connection. I have also seen where a perl script encounters an OCI error
(usually my fault ;) after the connection and the httpd child can never
connect again.
Incidentally, I have also noticed that on my Linux installation Oracle will
not shutdown (or shutdown abort) while any of the httpd processes have
persistent connections. That is, httpd must come down first for Oracle to
shutdown cleanly. Just thought I'd mention it...
--Geoff
> -----Original Message-----
> From: Greg Stark [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, November 02, 1999 4:39 AM
> To: Tim Bunce
> Cc: mod-perl Mailing List; DBI Users Mailing List
> Subject: Re: Failing to reconnect after Oracle "shutdown abort"
> (Apache::DBI)
>
>
> Tim Bunce <[EMAIL PROTECTED]> writes:
>
> > Has anyone experienced a situation where a process (httpd for example)
> > can't reconnect to Oracle after a "shutdown abort"?
> >
> > Tim.
>
> As far as I can tell we never get a clean reconnection after any sort of
> connection problem. I don't even think it takes a shutdown abort to cause
> this.
>
> --
> greg
