1) Enables application to automatically reconnect to database. Active transactions get rollback.
2) TNSParameter : Failover_mode=(type=select)(method=basic)
Failover method can be either select or session.
3) Can be configured by dbms_service package at server side