Re: Connections which go bad

From: vsevolod afanassiev <>
Date: Tue, 12 Jan 2010 21:23:41 -0800 (PST)
Message-ID: <>

It could be firewall killing connections. Is application server software running on the same host as database? Or apps server is on different host? Is there firewall between them?

If Apps server is on different host then you can try running SQL*Plus on both hosts. Most likely
SQL*Plus on the same host as database will stay connected while SQL*Plus on different host will be disconnected.

If the problem is caused by firewall killing idle connections then it can prevented:
- Adjust firewall settings, disable killing of idle connections

  • JDBC should have parameter that forces all connections to be tested (typically by executing 'select * from dual').
  • If Oracle Dead Connection Detection is enabled ( sqlnet.expire_time ) then Oracle sends probe packets
Received on Tue Jan 12 2010 - 23:23:41 CST

Original text of this message