Setup Oracle JDBC Client not to load balance across Primary and Standby clusters?
I have two RAC clusters, primary and standby, with Data Guard and Broke setup. The thought with this setup is to have the Oracle JDBC client only establish a connection to the primary cluster and then load balance to the instances in the cluster which works fine but more than that is going on! The Oracle JDBC client is also establishing a connection to the standby to load balance to it too. Both the primary and standby have the same service_name which I understand is OK (this is what we want...). And, we have followed the MAA - Client Failover Best Practices for