[Zope-DB] 3114, 'ORA-03114: not connected to ORACLE'

[Jim Abramson]

We have a mechanism dealing with this:

1 - a python script in zope that uses a given DCO2 connection to ask oracle (select 'OK' from dual)
2 - a mon process that requests this py script by URL every n minutes
3 - if the reponse is not 'OK' from the URL call, retry after n seconds
4 - if n retries fail, we restart zope summarily.

step 4 is necessary because it seems once the pool, or a connection in the pool, has gone sour, there's no manage_ option that really makes everything fine again.

We are 100% certain our database isn't flaking, many other users/systems connected and they do not complain.  The connection pool just doesn't seem to keep itself in a happy/healthy state all the time.  But this mon solution works very well for us.

Admittedly, I haven't tried Chris' branch of DCO2 to see if it works better there.

Jim


> -----Original Message-----
> From: Matthew T. Kromer [mailto:matt at bane.mi.org] 
> Sent: Tuesday, October 05, 2004 8:44 AM
> To: Dario Lopez-Kästen
> Cc: zope-db at zope.org
> Subject: Re: [Zope-DB] 3114, 'ORA-03114: not connected to ORACLE'
> 
> Just a FYI, Chris Withers has a branch of DCOracle2 which may 
> feature better behavior when the database connection drops.
> 
> 
> On Oct 5, 2004, at 1:49 AM, Dario Lopez-Kästen wrote:
> 
> > Remy Pinsonnault wrote:
> >> Dieter, what do you mean had died?
> >> Four other applications are connected to the same Oracle Server 
> >> (written in
> >> ASP, Java, Oracle Developer, PowerBuilder) and their 
> connection did 
> >> not went
> >> down as DCOracle2 did...
> >
> > we experience the same problem. I still ahve not seen a pattern to 
> > this. Things that have changed from before we had this problem:
> >
> > New version of Zope (2.6-series), new OS (RH AS 3.0), 
> latest DCOracle2 
> > from CVS. Exaclty the 3 cor components of a site :-P.
> >
> > Which means that we ought to start comparing versions.
> >
> > NB: We have no problems with the Oracle Servers, it is just 
> the Zope 
> > client that dies.
> >
> > /dario
> >
> > -- 
> > -- 
> -------------------------------------------------------------------
> > Dario Lopez-Kästen, IT Systems & Services Chalmers 
> University of Tech.
> > _______________________________________________
> > Zope-DB mailing list
> > Zope-DB at zope.org
> > http://mail.zope.org/mailman/listinfo/zope-db
> 
> _______________________________________________
> Zope-DB mailing list
> Zope-DB at zope.org
> http://mail.zope.org/mailman/listinfo/zope-db
>