[Zope-DB] DCOracle2 Error: (1012, 'ORA-01012: not logged on')

[Chris Withers]

Dieter Maurer wrote:
> Chris Withers wrote at 2003-9-19 12:58 +0100:
>  > ...
>  > Error Type: Database Error
>  > Error Value: (1012, 'ORA-01012: not logged on')
> 
> One of the few directly understandable Oracle error messages.
> 
>   The connection did not make a "logon".

But why would this happen half way through a transaction involving a ZSQL method?

>  > DatabaseError: (3114, 'ORA-03114: not connected to ORACLE')
> 
> Almost surely, your Oracle process died.
> 
> We made the experience that Oracle processes like to die...

So how do you stop your users seeing errors like these?

Chris