[Zope] ZOracleDA periodically drops connections, please help

[Jarvis John]

Hi,
  I have the same problem (w/o crashes, though), but suspected that it
was 
from the Oracle session timing out when in an inactive state. The DBAs
won't 
give my connections unlimited idle time :^/
  Because of this, I figured it might not be the Zope end that's
disconnecting.
I created an SQL Method that just returns a '1' and run it periodically
via cron to refresh the session. I have yet to lose another connection,
but
it hasn't really been running long enough to be conclusive.  

   You might also try to call the DA's manage_close_connection and
manage_open_connection methods to reset your connections every once in a
while. 
   Something like:

from ZPublisher import Client
Client.call('http://hostname/path_to_connection_obj/manage_close_connection'
     ,'username','password')
Client.call('http://hostname/path_to_connection_obj/manage_open_connection'
     ,'username','password')


-John Jarvis

Roman Milner wrote:
> 
> Hello.  We are about to go live with a new Zope based site but we are
> having a frustrating problem.  Periodically, we lose all of our
> oracle connections.  Our queries start to return oci errors stating
> that the zsql method is not connected to a database.  Sometimes this
> causes ZServer/python to crash, other times they are still running.  In
> all cases restarting zserver fixes the problem.
> 
> We have ZServer configured to run pcgi only.  Apache also runs and
> delivers content via pcgi.
> 
> Our Zope server runs on a redhat 6.2 machine.  We have the Oracle DA
> installed on that machine.  Our Oracle server runs on a Sun box.
> 
> When ZOracleDA loses all of its connections, we can still communicate
> with the oracle server fine via sqlplus.
> 
> Any help is greatly appreciated.
> 
> ^Roman
> 
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://lists.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists -
>  http://lists.zope.org/mailman/listinfo/zope-announce
>  http://lists.zope.org/mailman/listinfo/zope-dev )