Re: How to simulate ORA-03114 "Not connected to Oracle" in a test application?
From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 09 Nov 2007 06:25:59 -0800
Message-ID: <1194618354.915561_at_bubbleator.drizzle.com>
>
>
> 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.
Date: Fri, 09 Nov 2007 06:25:59 -0800
Message-ID: <1194618354.915561_at_bubbleator.drizzle.com>
André Hartmann wrote:
> "DA Morgan" <damorgan_at_psoug.org> schrieb im Newsbeitrag
> news:1194616637.115847_at_bubbleator.drizzle.com...
>> 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 damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Fri Nov 09 2007 - 15:25:59 CET