Re: Solutions for Dead SQL*Net connections
Date: 1995/09/15
Message-ID: <43bpug$11h_at_tst.hk.super.net>#1/1
jmarcus_at_spirit.com.au (John Marcus) wrote:
>
>We're running ORACLE 7.0.16, SQL*Net V1, with Solaris 2.4. We tried
>setting these parameters (we used 600000 - 10 minutes, rather than
>60000 - 1 minute), but the "dead" connections still won't go away. Do
>we need to restart orasrv, or are we missing something here....
>
Do you mean the "existing" dead connections weren't go away ?? If so, that's normal. The modified TCP parameters will only be effective on new sockets created after the change --- NOT BEFORE !!
In general, you shouldn't need to restart orasrv because orasrv will eventaully generate system call to create new sockets for new connections, and these should observe a modified behaviour.
Hope this help.
Rgds,
Andy :)
Received on Fri Sep 15 1995 - 00:00:00 CEST