JDBC Connections Hang On Socketread0 After RAC Failover
Last updated on MARCH 08, 2017
Applies to:JDBC - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
Two separate boxes have 2 applications deployed, one uses JDBC Thin driver 188.8.131.52 and the other uses C++ OCI driver.
Both the applications connect to a RAC 184.108.40.206 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:
Component combination showing the issue::
RAC Database 220.127.116.11 - Thin JDBC driver 18.104.22.168
RAC Database 22.214.171.124 - C++ OCI driver 126.96.36.199
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
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