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 )