Or modify the SQLNET.EXPIRE_TIME value in the sqlnet.ora of each client.
<futurocom_at_wanadoo.fr> a écrit dans le message :
370328e7.4601676_at_news.wanadoo.fr...
> How to prevent automatic disconnection.
>
> 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 - 05:36:17 CST
