Re: How to simulate ORA-03114 "Not connected to Oracle" in a test application?

From: DA Morgan <>
Date: Fri, 09 Nov 2007 06:25:59 -0800
Message-ID: <>

André Hartmann wrote:
> "DA Morgan" <> schrieb im Newsbeitrag

>> Some Oracle error messages for example, ORA-03114 not connected to 
>> ORACLE, are not root causes but rather the result of something else.
>> A session might be disconnected for hundreds of reasons.

> Yes, I know that. I am not aiming at tracking down the reason here, I am
> aiming at testing the application code, that reacts to the occurrence of
> the event. For example the reaction could be to establish a new
> connection to the schema and continue as normal.

But the application code is meaningless for this error message. Is the cause of the disconnect that the Oracle client had a brain hemmorhage? Or that the CAT5 cable is disconnected? Or the fact that someone on the server did SHUTDOWN ABORT? You don't know. You can not know. And there is nothing your application can do about it except keep trying to reconnect for some finite period before timing out.

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Fri Nov 09 2007 - 15:25:59 CET

Original text of this message