PCP failover takes approx 30 mintues
My sqlnet.ora on my RAC nodes has the following values set:
sqlnet.expire_time = 10
SQLNET.INBOUND_CONNECT_TIMEOUT=120
tcp_retries1=2
tcp_retries2=2
tcp_syn_retries=2
my mid-tier tnsnames.ora file is setup using the scan listener.
(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=ON)(FAILOVER=ON) (ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx.xx1)(PORT=xxxx)) (ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx.xx2)(PORT=xxxx)) (ADDRESS=(PROTOCOL=TCP)(HOST=xxx.xxx.xxx.xx3)(PORT=xxxx))) (CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=SCAN)))