connection failover conf
Hi, I am having problem on connect-time failover configuration. Actually I have three nodes as node_a, node_b, node_c. I need to configure as:
If instance fails on node_a, then new coming client must be redirect to node_b. Mean time if node_b also fails then the new connection need to be redirected to node_c.
Following is my client's tnsnames.ora
RACDB =
(DESCRIPTION =
(FAILOVER = true)
(LOAD_BALANCE = no)
(ADDRESS = (PROTOCOL = TCP)(HOST = node_a-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = node_b-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = node_c-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = racdb)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 30)
(DELAY = 5)
)
)
)
I am not able to connect to node_b in case of failure of instance on node_a.
Instance is already ready when I do status on lsnrctl prompt.
Service "racdb" has 3 instance(s).
Instance "racdb1", status READY, has 1 handler(s) for this service...
Instance "racdb2", status READY, has 2 handler(s) for this service...
Instance "racdb3", status READY, has 1 handler(s) for this service...
whenever one of the instance is failed, according to my knowledge listener on node_a must redirect connection request to node_b or connect to service racdb2.
Please help, I am unable to connect if instace racdb1 on node_a fails.