Re: Problem with DBD::Oracle with mod_perl

[Perrin Harkins]

> After some time of work (about hundred of requests), I get
>
> DBD::Oracle::db prepare failed: ORA-03113: end-of-file on communication
> channel
> (DBD: error possibly near <*> indicator at char 1 in '<*>select
slogan_text
> from
>  slogans') at /usr/local/www/lib/SQL.pm line 221.
>
> and all Oracle-using perl programs within Apache stops to work until I
> restart Apache.
>
> With two clients fetching a page both at one time, I'm 100% getting this
in
> less than a minute.

Are you using Apache::DBI?  Are you opening a connection in the parent
process (in startup.pl or equivalent)?
- Perrin