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

[Remy Pinsonnault]

Thanks, that's a solution that should work but isn't it drastic? I have to
admit that I haven't tried chris's branch neither...

Is there anyone out there that could recomend me another product to connect
to Oracle succesfully in a production environment?

What about the ODBC products (mx or other ones), is there anyone using them
without any failures?

Thanks for the responses

Remy

-----Original Message-----
From: zope-db-bounces at zope.org [mailto:zope-db-bounces at zope.org] On Behalf
Of Jim Abramson
Sent: Miércoles, 06 de Octubre de 2004 12:40 p.m.
To: Matthew T. Kromer; Dario Lopez-Kästen
Cc: zope-db at zope.org
Subject: RE: [Zope-DB] 3114, 'ORA-03114: not connected to ORACLE'


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
> 
_______________________________________________
Zope-DB mailing list
Zope-DB at zope.org
http://mail.zope.org/mailman/listinfo/zope-db