RAC 11gR2 VIP and SCAN failover behavior
759987Mar 13 2010 — edited Jul 16 2010I tried to failover testing on 2 node 11gR2 RAC on Linux 5 X86-64 with configure in tnsnames.ora on client side (client side TAF configuration) with the following configuration
NVSDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dbrac-scan)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = NVSDB)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 180)
(DELAY = 5)
)
)
)
The test scenario
1. Connect from client to RAC database , and test query with select * from dba_objects
2. Open new terminal and connect to instance in step 1 , then shutdown abort
3. I found that , the session in step 1 not failover to other node , and VIP and SCAN not failover to other node too
In my opinion session , VIP and SCAN should failover to other node.
Or is this the default behavior of VIP and SCAN on 11gR2 ??
Can anyone suggest me ?
Thankyou and Regards