JDBC Connections Hang On Socketread0 After RAC Failover
(Doc ID 1386017.1)
Last updated on MARCH 14, 2023
Applies to:
JDBC - Version 11.2.0.2.0 and laterInformation in this document applies to any platform.
Symptoms
Scenario:
Two separate boxes have 2 applications deployed, one uses JDBC Thin driver 11.2.0.2 and the other uses C++ OCI driver.
Both the applications connect to a RAC 11.2.0.3 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:
java.net.SocketInputStream.socketRead0(Native Method)
Component combination showing the issue::
RAC Database 11.2.0.3 - Thin JDBC driver 11.2.0.2
RAC Database 11.2.0.3 - C++ OCI driver 11.2.0.2
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
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |