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

[Remy Pinsonnault]

Once in a while I get the following error: "3114, 'ORA-03114: not connected
to ORACLE'"

It seems that like there are no transactions for a few days (in this case
every weekend...), I get this error. The only solution is to restart the
service, closing/opening the connection does not help...

I have Python 2.3.3, Plone 2.0.4, Zope 2.7.0.

Any ideas?

dco2.DatabaseError

Sorry, a site error occurred.

Traceback (innermost last): 

Module ZPublisher.Publish, line 163, in publish_module_standard 
Module Products.PlacelessTranslationService.PatchStringIO, line 51, in
new_publish 
Module ZPublisher.Publish, line 108, in publish 
Module Zope.App.startup, line 226, in abort 
Module ZODB.Transaction, line 134, in abort 
Module Shared.DC.ZRDB.TM, line 63, in abort 
Module Products.ZOracleDA.db, line 130, in _abort 
Module Products.ZOracleDA.DCOracle2.DCOracle2, line 312, in rollback 
DatabaseError: (3114, 'ORA-03114: not connected to ORACLE')