TAF Policy | RAC

 PUNE =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = racscan)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = pune)
      (FAILOVER_MODE=(METHOD=preconnect)(TYPE=select))
     (LOAD_BALANCE=YES)
     (FAILOVER=ON)

On differet window of node 1:
-----------------------------

sqlpulus shoaib/shoaib@pune
sql> select * from dba_sources;



On node 2:
----------
sqlplus / as sysdba


sql>
COLUMN inst_id    FORMAT 13
COLUMN username FORMAT a9
COLUMN service_name     FORMAT a9
COLUMN failover_type    FORMAT a15
COLUMN failover_method  FORMAT a11
COLUMN failed_over FORMAT a11

select inst_id,username,service_name,failover_type,failover_method,failed_over from gv$session where username='SHOAIB';

   INST_ID USERNAME  SERVICE_N FAILOVER_TYPE   FAILOVER_ME FAILED_OVER
---------- --------- --------- --------------- ----------- -----------
         2 SHOAIB    pune      NONE            NONE        NO
         1 SHOAIB    pune      SELECT          PRECONNECT  NO


On node 1:
----------
sqlplus / as sysdba
sql> shut immediate;




On node 2:
----------

sql> COLUMN inst_id     FORMAT 13
COLUMN username         FORMAT a9
COLUMN service_name     FORMAT a9
COLUMN failover_type    FORMAT a15
COLUMN failover_method  FORMAT a11
COLUMN failed_over      FORMAT a11

select inst_id,username,service_name,failover_type,failover_method,failed_over from gv$session where username='SHOAIB';

INST_ID USERNAME  SERVICE_N FAILOVER_TYPE   FAILOVER_ME FAILED_OVER
---------- --------- --------- --------------- ----------- -----------
         2 SHOAIB    pune      SELECT          PRECONNECT  YES