| vip of surviving node goes down [message #438239] |
Thu, 07 January 2010 11:53  |
daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india
|
Member |
|
|
Hi ,
I have a non rac database to a rac database.
everything is running fine.
the problem is that the vip is not failing over to the surviving node.
I have two node rac cluster.
whenever my node1 or node2 goes down. The vip doesnt failover to the surviving nodes instead of the surviving node also goes down.
when my both node is up.
i can see both vip address using ifconfig command.
As one of the node goes down. when i again run ifconfig command to check if configuration.
I dont see the vip address.
I try to find out the solution but in vain.
please help me where i am going wrong.
Thanks,
|
|
|
|
|
|
| Re: vip of surviving node goes down [message #438253 is a reply to message #438243] |
Thu, 07 January 2010 12:24  |
daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india
|
Member |
|
|
Hi,
Please find the tnsnames.ora entry below.
PROD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVICE_NAME = prod)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 180)
(DELAY = 5)
)
)
)
LISTENERS_PROD =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521))
)
PROD1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521))
PROD2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521))
I am able to failover to the existing instance if one of the instance goes down. but vip failover is not happening.
Thanks
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
