Re: Connections which go bad
From: vsevolod afanassiev <vsevolod.afanassiev_at_gmail.com>
Date: Tue, 12 Jan 2010 21:23:41 -0800 (PST)
Message-ID: <e7d8ba2b-88e9-4a9e-acc0-3632b68fc0b0_at_21g2000yqj.googlegroups.com>
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?
Date: Tue, 12 Jan 2010 21:23:41 -0800 (PST)
Message-ID: <e7d8ba2b-88e9-4a9e-acc0-3632b68fc0b0_at_21g2000yqj.googlegroups.com>
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