Oracle running under Amazon Web services : database connections timing out

From: John Dunn <JDunn_at_sefas.com>
Date: Mon, 16 Apr 2018 08:21:57 +0000
Message-ID: <EEC3316514CFB24AB2285394E0D405587D10ABE8_at_BOU.sefasuk.local>



A client has moved their applications and database to run in a AWS environment. The application is now stopping(after an hour) due to database connections being closed.

It had no such problems in the previous non-cloud environment where it has run for years.

Their AWS guys have suggested "the application should look to ensure a keepalive is used for the JDBC connections"

Any idea how we would do that?
Database is Oracle 11

Anyone else seen this problem in an AWS environment?

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 P Please consider the environment before printing this email Sefas Innovation Limited,
Floor 3, Whitefriars, Lewins Mead,
Bristol BS1 2NT, UK.
Tel: +44 (0) 117 906 9920

Registered No: 3769761 England.
Registered Office: One New Street, Wells, Somerset, BA5 2LA, United Kingdom. VAT Registration No: GB 741 5377 32
Unless stated to be non-confidential, this email and any attachments are private and confidential and are for the addressee only. Sefas monitors e-mails to ensure its systems operate effectively and to minimize the risk of viruses. Whilst Sefas has taken reasonable steps to scan this email, it does not accept liability for any virus that may be contained in it. Internet communications are not 100% secure and as such Sefas is not responsible for their abuse by 3rd parties, nor for any alteration or corruption in transmission.

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Apr 16 2018 - 10:21:57 CEST

Original text of this message