Login  Register

failover testing

Posted by Roshan on Apr 28, 2017; 10:37am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/failover-testing-tp2612.html

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