Re: Database connections being disconnected
- From: Stefan Koehler <contact@xxxxxxxx>
- To: lkemnitz@xxxxxxxx, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 6 Feb 2015 18:34:23 +0100 (CET)
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: @OracleSK
> Leroy Kemnitz <lkemnitz@xxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
