Re: Database connections being disconnected
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-lReceived on Fri Feb 06 2015 - 18:34:23 CET