JDBC Connection From WLS Data-source Hangs When The First Instance Of 2 Node RAC Database Goes Down
Last updated on MAY 05, 2017
Applies to:JDBC - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
On : 22.214.171.124.0 version, Thin JDBC driver
JDBC thin connection is not working when one instance of a 2 node RAC Database is shut down.
Listener configuration / behavior has been verified.
-- When Node A has its database instance shutdown or crash, the JDBC connections hang and go into pending status.
WebLogic Server is using the next configuration:
1] Regular data-source
2] Using SCAN on the URL JDBC
3] The minimum number of connection is 1
When the first node in the RAC is stopped, the problem is produced; if the second node is stopped. all works fine.
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