Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RAC 11gR2 VIP and SCAN failover behavior

759987Mar 13 2010 — edited Jul 16 2010
I 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 13 2010
Added on Mar 13 2010
8 comments
6,655 views