This content has been marked as final. Show 2 replies
High level documentation can be found in white paper "Application Failover with Oracle Database 11g": http://www.oracle.com/technetwork/database/app-failover-oracle-database-11g-173323.pdf.
Detailed documentation can be found in RAC documentation "Introduction to Workload Management": http://docs.oracle.com/cd/E11882_01/rac.112/e16795/hafeats.htm#BABIAICG .
If you want to use Transparent Application Failover see http://docs.oracle.com/cd/E11882_01/rac.112/e16795/hafeats.htm#BABDCBHH from same document and "Configuring Transparent Application Failover" in http://docs.oracle.com/cd/E11882_01/network.112/e10836/advcfg.htm#i473297 from Net Services Administrator's Guide.
ask application team to subscribe to oracle notifications(ONF). This can be done by modifying setting in JDBC drivers.
you can provide them above information, so that they can handle errors internally and reconnect the session after failure notification.
you can find that infomation on following file: