DCD dead connection detection in 12c
From: April Sims <aprilcsims_at_gmail.com>
Date: Thu, 14 Aug 2014 09:30:27 -0500
Message-ID: <CAK+cZDezcmf-SpJWy0gGkN50S+2uVGJup=vQJr-iv1qkp+0SwQ_at_mail.gmail.com>
Need some help in resolving our new idle timeouts seen since going to 12c. I have a document
Date: Thu, 14 Aug 2014 09:30:27 -0500
Message-ID: <CAK+cZDezcmf-SpJWy0gGkN50S+2uVGJup=vQJr-iv1qkp+0SwQ_at_mail.gmail.com>
Need some help in resolving our new idle timeouts seen since going to 12c. I have a document
Oracle Net 12c: New Implementation of Dead Connection Detection (DCD) (Doc ID 1591874.1)
We are on Linux RH 64-bit so this is applicable.
Our current OS settings look like the following:
# cat /proc/sys/net/ipv4/tcp_keepalive_time 7200
# cat /proc/sys/net/ipv4/tcp_keepalive_intvl
75
# cat /proc/sys/net/ipv4/tcp_keepalive_probes
9
sqlnet.ora
SQLNET.EXPIRE_TIME = 10
SQLNET.INBOUND_CONNECT_TIMEOUT = 120
listener.ora
INBOUND_CONNECT_TIMEOUT_LISTENER_listenername = 120
Any suggestions on the changes I need to make to prevent a 2 hour idle timeout?
thanks,
-- April C. Sims http://aprilcsims.wordpress.com Twitter, LinkedIn Oracle Database 11g – Underground Advice for Database Administrators https://www.packtpub.com/oracle-11g-database-implementations-guide/book OCP 8i, 9i, 10g, 11g DBA Southern Utah University aprilcsims_at_gmail.com -- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 14 2014 - 16:30:27 CEST