Hi would appreciate if some one could guide me or point me to some URL, to how to handle nod fail-over.
I have custom application done in Java, and this is connected to 2 nod Oracle RAC. recently we found when ever the node which was catering reboots or fails the application gets stuck and we have to restart the application as well.
1. Do-sent this fail over should be seamless!
2. Do we need to do any modifications to the application to handle these kinds scenarios
3. Is there aditional configuration for the RAC side?
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.