Re: ORA-3113

A copy of this was sent to "Pootie" <pootie_at_england.com> (if that email address didn't require changing) On Sat, 2 Jun 2001 13:41:52 -0500, you wrote:

>There is another Linux box acting as a firewall. I will have to ask about
>this.
>
>The timer solution is probably where I'll go. In all the years I have
>worked with Oracle tools, I have always had to "trick" things into working,
>i.e. "dual".
>

not to be sounding defensive here or anything, but this has NOTHING to do with the tool. open a telnet session, let it sit for 20 minutes -- same effect will happen. Your network admins have installed some security for you. using the timer is a method to subvert their work.

I used to run a "ping" command in the background when I used an ISP that would shut you down after 5 minutes of inactivity -- same exact concept.

don't understand the reference to "dual" as a trick? any examples of what you felt was a "trick" with dual?

>Thanks for your help.
>
>"Thomas Kyte" <tkyte_at_us.oracle.com> wrote in message
>news:t86ghtc5sdpb6qv6ou4athubp8d62ceot9_at_4ax.com...
>> A copy of this was sent to "Richard W. Howell" <rwh_at_iquest.net>
>> (if that email address didn't require changing)
>> On Fri, 1 Jun 2001 13:22:35 -0500, you wrote:
>>
>> >Running v8.1.6 on Linux using Net8 TCP/IP, Forms 4.5 on Windows 98
 clients.
>> >
>> >Everything is fine until a period (usually about 15 minutes) of
 inactivity.
>> >Oracle disconnects from my form and I get ORA-3113/3114. What must I do
 to
>> >keep the session connected, even though there may be long periods of
>> >inactivity?
>> >
>> >A similar (but older) setup on Netware would last indefinitely without
>> >disconnection.
>> >
>> >
>>
>> you running a firewall or some other software that times out network
 connections
>> after a period of inactivity?
>>
>> Its a security feature that is pretty typical these days.
>>
>> If so, setting up dead client detection might allow you to subvert this
 security
>> feature. With DCD -- the server process will "ping" the client and
 expects the
>> client to respond. That will generate some network activity.
>>
>> Another method would be to put a timer into the form and every 10 minutes
 see
>> what time it is on the server.
>> --
>> Thomas Kyte (tkyte_at_us.oracle.com) Oracle Service Industries
>> Howtos and such: http://asktom.oracle.com/
 http://asktom.oracle.com/~tkyte/
>> Oracle Magazine: http://www.oracle.com/oramag
>> Opinions are mine and do not necessarily reflect those of Oracle Corp
>

--
Thomas Kyte (tkyte_at_us.oracle.com) Oracle Service Industries
Howtos and such: http://asktom.oracle.com/ http://asktom.oracle.com/~tkyte/
Oracle Magazine: http://www.oracle.com/oramag
Opinions are mine and do not necessarily reflect those of Oracle Corp