Here's the situation:
I know how to set up MultiDatasources for an individual RAC cluster, and I have been doing that for years.
Is there a way to configure MultiDatasources (mDS) in WebLogic to allow for automatic failover between the two clusters, or does the app have to be coded to failover from an mDS that's not working to one that's working (with preference to a currently labelled "primary" site).
We still want to have load balancing across the current "primary" cluster's members
Is there a "best practice" here?
Hi, no, not at the MDS level. If we allowed nested MDSes, it would be easy, but we don't.
Because of your especially easy requirements, you can try it at the JDBC driver URL.
If it is possible to define your URLs so they connect to your primary site if available,
but connect to the standby site if not, that might work for you.
There are 2 ways to connect WLS to a Oracle RAC.
1. Use the Oracle RAC service URL which contains the details of all the RAC nodes and the respective IP address and DNS.
2. Connect to the primary cluster as you are currently doing and use a MDS to load-balance/failover between multiple nodes in the primary RAC (if applicable).
In case of a primary RAC nodes failure and switch to DR RAC nodes, use WLST scripts to change the connection URL and restart the application to remove any old connections.
Such DB fail-over tests can be conducted in a test/reference environment to set up the required log monitoring and subsequent steps to measure the timelines.