Home » Server Options » RAC & Failsafe » vip of surviving node goes down (oracle 10.2.0.1 , RHEL-4)
vip of surviving node goes down [message #438239] Thu, 07 January 2010 11:53 Go to next message
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 #438243 is a reply to message #438239] Thu, 07 January 2010 11:59 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
What kind of failover method are you using?
Post your tnsnames.ora
Re: vip of surviving node goes down [message #438253 is a reply to message #438243] Thu, 07 January 2010 12:24 Go to previous messageGo to next message
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
Re: vip of surviving node goes down [message #438269 is a reply to message #438253] Thu, 07 January 2010 14:07 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Have you verified CRS log?

Re: vip of surviving node goes down [message #438310 is a reply to message #438239] Fri, 08 January 2010 00:41 Go to previous message
daniesh.shaikh@gmail.com
Messages: 62
Registered: February 2008
Location: india
Member
No.
you mean to say the log under $CRS_HOME/log .

Thanks,
Previous Topic: RAC virtual enviroment setup in single desktop?
Next Topic: Is UDP suitable for cluster interconnect ?
Goto Forum:
  


Current Time: Fri Mar 29 00:32:18 CDT 2024