Re: How to prevent automatic disconnection ?

You could be facing two problems,

1. SQLNET TimeOut parameter, that is set within SQL*Net's sqlnet.ora file. You could set this to a zero timeout.
2. If you have enabled profiling, then this may be causing the connection to timeout, if you have set some timelimits.

I am sure there are a number of other options, possibly within TCP/IP but I am not sure about those.

Andrew

futurocom_at_wanadoo.fr wrote:

> We are making a system composed of
> - Oracle RDBMS (ver 7.3.2) and server with Unix SCO
> - Clients running on windows NT Workstation 4.0
> The different machines are linked together with TCP.IP
> protocol and SQL*Net Ver 2.0. Dialog between clients and
> server uses OCI commands. We have this problem :
>
> If the client connected to the server doesn't work
> (no SQL request sent) for about 2 hours, the link with the
> data base is broken and so the client doesn't received information
> sent
> by the server anymore.
> How is it possible to prevent automatic disconnection ?
>
> Thank you for your help.
Received on Thu Apr 01 1999 - 04:59:56 CST