How to Set JDBC Thin 10g Connection String to RAC Without Referencing Every Node in the Cluster
(Doc ID 414465.1)
Last updated on MARCH 31, 2020
Applies to:JDBC - Version 10.1.0.5 to 10.2.0.5 [Release 10.1 to 10.2]
Information in this document applies to any platform.
Is there a way to specify the JDBC connection string to a RAC 10g database cluster without
referring to every single node in the cluster?
This is a problem because of the overhead of re-configuring every node that accesses the cluster
each time the member nodes of the cluster change.
The current string used is as follows:
(ADDRESS=(PROTOCOL=TCP)(HOST=<HOSTNAME 1 VIP>)(PORT=<PORT>))
(ADDRESS=(PROTOCOL=TCP)(HOST=<HOSTNAME 2 VIP>)(PORT=<PORT>))
(ADDRESS=(PROTOCOL=TCP)(HOST=<HOSTNAME 3 VIP>)(PORT=<PORT>))
Note that the VIPs (Virtual IPs) for the 3 nodes are referenced explicitly in the connection string.
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