Re: Solutions for Dead SQL*Net connections
Date: 1995/09/13
Message-ID: <435uic$fsf_at_casper.spirit.com.au>#1/1
Andy Chan <chanandy_at_hk.super.net> wrote:
>Since many of you are interested in my solutions on dead SQL*Net v1
>connections, there you are ...
>For Solaris 2.3, 2.4
> # ndd -set /dev/tcp tcp_close_wait_interval 60000
> # ndd -set /dev/tcp tcp_ip_abort_cinterval 60000
> # ndd -set /dev/tcp tcp_keepalive_interval 60000
> For permanent effect, you may need to add these lines in startup
>scripts.
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....
John Marcus (jmarcus_at_spirit.com.au)
Database Administration
Australian Bureau of Statistics
Canberra, Australia
Received on Wed Sep 13 1995 - 00:00:00 CEST