Re: Database connections being disconnected

From: Stefan Koehler <contact_at_soocs.de>
Date: Fri, 6 Feb 2015 18:34:23 +0100 (CET)
Message-ID: <1193030935.26262.1423244063694.JavaMail.open-xchange_at_app10.ox.hosteurope.de>

Hi Leroy,
maybe caused by a weird (OS) kernel setting as this issue occurs on DEV only. We already discussed these different parameters and its influence on each other here (read all posts): https://www.freelists.org/post/oracle-l/DCD-dead-connection-detection-in-12c

Just a guess based on your general description.  

Best Regards
Stefan Koehler

Freelance Oracle performance consultant and researcher Homepage: http://www.soocs.de
Twitter: _at_OracleSK

> Leroy Kemnitz <lkemnitz_at_uwsa.edu> hat am 6. Februar 2015 um 18:09 geschrieben:
> All –
>
> I have been having problems with database connections being ‘reset’. I am using SQL Dev 4.0 to connect to Oracle 11.2.0.3.
>
> I have the SQLNET.EXPIRE_TIME = 0 in the sqlnet.ora. My firewall guys tell me that the firewall is open and time outs are set. This is occurring
> in dev but not in prod – so apparently I set something wrong in dev – but I can’t find it.
>
> I have been searching thru Oracle support but no answers yet. Anyone else have the same issue? I am running out of ideas of what to check.
>
> LeRoy

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Feb 06 2015 - 18:34:23 CET