Re: ora-3113

From: Scott Parker <parker_at_dorite.use.com>
Date: Mon, 13 Mar 1995 22:30:42 GMT
Message-ID: <D5EH7A.BqG_at_dorite.use.com>


One of the problems is that SQL*Net on the client thinks you still have a open connection. You might check the manual for the client SQL*Net on how to close or reset the buffer. I can't remember if you actual have to exit the client program and restart SQL*Net on the client. I wish I had some docs with me.

I do remember you can see this if you turn debug mode on in SQL*Net on the client.

Larry S. Dare (ldare_at_bach.seattleu.edu) wrote:

: I am in the final phases of a program checkout. One of the test is
: haveing the client program recononnect if it loses its oracle
: connection.
 

: For the server side, oracle cleans up nicely. From the client side
: the program receives a ora3113 ora3114.
 

: It then returns a ora1075 after it tries to reconnect, which says
: that I am already connected.
 

: Any clues on how to DISCONNECT the program so it can connect again?
 

: Thanks
 

: --
: Larry S. Dare
: ldare_at_wdni.com

: --
: Larry S. Dare
: ldare_at_wdni.com
Received on Mon Mar 13 1995 - 23:30:42 CET

Original text of this message