DCD dead connection detection in 12c

  • From: April Sims <aprilcsims@xxxxxxxxx>
  • To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 14 Aug 2014 09:30:27 -0500

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@xxxxxxxxx

Other related posts: