Please Suggest for below scenario
2 Application server- Weblogic 10.3.6
ORACLE Service Bus 188.8.131.52.7
2 Oracle DB 11G machines
1.We have 2 parallel OSB domain running on 2 machines and pointing to Active DB (Primary DB)
2.On DB side we have active and passive setup with Oracle Data guard in place for data replication.
QUERY:- In case of Primary DB going down HOW Automatic fail over can be achieved on weblogic server ?
What type of datasources are you using currently? (generic, multi, gridlink)
Gridlink and multi are what you should look at. Gridlink is recommended for failover handling via ONS functionality.
Fusion Middleware High Availability Guide
5 Considerations for High Availability Oracle Database Access