failover testing

[Roshan]

checklist.rar

Hi Erman,

I am doing a failover testing on a RAC(2 nodes). The first check is failing when I am connecting sqldeveloper on 1 node and I shutdown DB, it does not failover. SCAN IP was used to connect to sqldeveloper.

Please advise.

node1 tnsnames
CBS =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = cbs-scan.telecom.mu)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = cbs)
    )
  )


node2 tnsnames
CBS_2 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.210.228.10)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = cbs)
    )
  )

Regards,
Roshan

[ErmanArslansOracleBlog]

You want TAF...

Please check the following document:
How to Setup SQL Developer to support Transparent Application Failover (TAF) (Doc ID 1389747.1)