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

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-l

Received on Thu Aug 14 2014 - 16:30:27 CEST