1 Reply Latest reply: Apr 14, 2013 7:02 PM by rajeysh RSS

    transparent application failover

    sandydb
      Hi All,

      I am testing TAF at client side with failover_method=preconnect. When i login using service name for which preconnect is enabled, I am seeing 4 sid's for each user session .

      ex:

      SQL> select inst_id,sid,failover_type,failover_method,failed_over from gv$session where username='XXXX';

      INST_ID SID FAILOVER_TYPE FAILOVER_M FAI
      ---------- ---------- ------------- ---------- ---
      1 53 NONE NONE NO
      1 59 SELECT PRECONNECT NO
      1 61 NONE NONE NO
      2 64 NONE NONE NO


      Please help in understanding y there are 4 sid's for single user connection. As per my understanding only 2 sid's should be there. Please correct me.

      tnsnames.ora:

      baan =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST =cluster1-scan.baan.com )(PORT = 1521))
      )
      (CONNECT_DATA =
      (SERVICE_NAME = DBRAC.rp.com)(FAILOVER_MODE = (backup = taf)(type = select)(method = preconnect)(retries = 180)(delay = 5)
      ))
      )
      taf =
      (DESCRIPTION =
      (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST =cluster1-scan.baan.com )(PORT = 1521))
      )
      (CONNECT_DATA =
      (SERVICE_NAME = DBRAC.rp.com
      ))


      Thanks,
      Sandy