My Oracle Support Banner

Datasource Error During Rollover Instance Bounce (Doc ID 2519896.1)

Last updated on SEPTEMBER 19, 2019

Applies to:

Oracle Health Insurance Claims Adjudication - Version 3.18.3.0.0 and later
Information in this document applies to any platform.

Goal


On :  3.18.3.0.0 version,


1) During the database maintenance , we have bounced the instance in rolling fashion when the application is up and running, and we noticed below error in application logs. Application login was also not working. Then we have followed the workaround given in this noteid "Database Test connection failed. Connection.isValid() returned false. (Doc ID 2018739.1)".  After resetting the data source, application login was working fine and datasource validation was successful.
Please confirm if we can do the fix mentioned in the same note id (Enable test-connection-on-reserve.).

2) We have two database instances for every database, so we had planned for no outage and we had moved the services to the available node, but still we were getting the datasource validation error and users were not able to login to the applications.
Can you please provide a solution for this connection reset error we are seeing in the application logs.
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.