Active Grid Link Data Sources Fail Frequently And "TNS-12537 TNS-12560 TNS-00507  Linux Error: 115" Errors Reported On The Listener Log

(Doc ID 2380444.1)

Last updated on MARCH 29, 2018

Applies to:

JDBC - Version 12.1.0.2.0 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.0.2.0 version, Thin JDBC driver

Recently the database was migrated from Single node to RAC.
The Data Sources were recreated to Gridlink.

The DSs work fine for few days and then fail. The issue is frequent and impacting Prod env.
Most of the times all the Managed Servers lose connection with the database. Some times it is noticed only few will have issue.
The Managed Servers have to be restarted each time they notice the issue to restore the services.

0r customer no issues on the Database end.
During the issue occurrence DS test connection fails.

ERROR
-----------------------
On the Listener the next error have been reported:

23-JAN-2018 10:32:58 * * 12537
TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
 TNS-00507: Connection closed
  Linux Error: 115: Operation now in progress
...
23-JAN-2018 10:35:58 * * 12537
TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
 TNS-00507: Connection closed
  Linux Error: 115: Operation now in progress
...
23-JAN-2018 10:38:58 * * 12537
TNS-12537: TNS:connection closed
TNS-12560: TNS:protocol adapter error
 TNS-00507: Connection closed
  Linux Error: 115: Operation now in progress
23-JAN-2018 10:39:02 * service_update * htwbdv2 * 0


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, the application is not working correctly.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms