Re: Solutions for Dead SQL*Net connections

John Marcus (jmarcus_at_spirit.com.au) wrote:
: 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

Just a question: what units are you using that 600,000 = 10 min? micro seconds?
Thanks,
Mickey. Received on Wed Sep 13 1995 - 00:00:00 CEST