RE: Oracle running under Amazon Web services : database connections timing out

Hi John,

I'm pretty sure it is because I used it on a recent cloud project. On Azure, Windows and 11.2.0.4.

Unless, of course, I've quoted the wrong setting! Check docs.oracle.com for the 11g networking manual for details. I can't, I'm in the bath!!!!!!!! ;-)

Cheers,
Norm.

On 16 April 2018 15:50:58 BST, John Dunn <JDunn_at_sefas.com> wrote:
>Is SQLNET.EXPIRE_TIME available in Oracle 11?
>
>
>John Dunn
>Senior Solutions Engineer
>Sefas Innovation Limited.
>Tel: + 44 (0) 117 910 0529
>www.sefas.com<http://www.sefas.com/>
>Advanced notice of holidays : 3rd April, 23rd-26 April 2018
>With effect from 1st April 2017 my normal working days are Monday to
>Thursday
>
>From: Norman Dunbar [mailto:oracle_at_dunbar-it.co.uk]
>Sent: 16 April 2018 10:09
>To: John Dunn; John Dunn; oracle-l_at_freelists.org
>Subject: Re: Oracle running under Amazon Web services : database
>connections timing out
>
>If I renember correctly, adding SQLNET.EXPIRE_TIME=15 does a probe
>every 15 minutes to check connections are alive and effectively is a
>keepalive. I've had to use this in the past. It goes on the server by
>the way, not the client.
>
>Cheers,
>Norm.
>
>--
>Sent from my Android device with K-9 Mail. Please excuse my brevity.

-- 
Sent from my Android device with K-9 Mail. Please excuse my brevity.
--
http://www.freelists.org/webpage/oracle-l