My Oracle Support Banner

JDBC Connections Hang On Socketread0 After RAC Failover (Doc ID 1386017.1)

Last updated on FEBRUARY 27, 2021

Applies to:

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


Two separate boxes have 2 applications deployed, one uses JDBC Thin driver and the other uses C++ OCI driver.
Both the applications connect to a RAC database and have the same sqlnet and OS parameters.

When the RAC interconnect between the two node-RAC is disconnected, all services failover properly and
new connections are created properly. However, existing connections are hanging and both the applications hang at: Method)

Component combination showing the issue::
RAC Database - Thin JDBC driver
RAC Database - C++ OCI driver

Compnent combination not showing the issue:
RAC Database 11.1 - Thin JDBC driver 11.1
RAC Database 11.1 - C++ OCI driver 11.1
RAC Database 10.2 - Thin JDBC driver 10.2
RAC Database 10.2 - C++ OCI driver 10.2




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

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