Oracle RAC Virtual IP (VIP) Failover

[Mehdi.Ziane]

Hello,

I've went through different documents regarding the implementation of Oracle RAC 10g + SGeRAC A.11.17+ ASM on ACSL website. However, I'd like please to confirm in case of a node failure, does CRS take care of failing over the Oracle Virtual IP?.

In fact, The zip file attached is a RAC cluster configuration with two packages crs-slvm and racp-asm, and the customer is complaining why the Oracle Virtual IP isn't failing over when one of the two instances goes down.?


Many thanks in advance for your help,

Kind Regards,

Mehdi Ziane

[Luk Vandenbussche]

Medhi,

With RAC your virtual ip adres doesn't failover. RAC doesn't react like a normal SG cluster

It is your tnsnames.ora which handles this failover.
Here is my tnsnames.ora

We used racdbf to handle with the failover


RACDB1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = racdb)
(INSTANCE_NAME = racdb1)
)
)

RACDB2=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = racdb)
(INSTANCE_NAME = racdb2)
)
)

RACDB=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = racdb)
)
)

RACDBF=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1)(PORT = 1521))
(LOAD_BALANCE = yes)
(enable = broken)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = racdb)
(failover_mode=(type=select)(method=basic))
)
)

LISTENERS_RACDB =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1)(PORT = 1521))
)

[Steven E. Protter]

Shalom Mehdi,

The Virtual IP is usually provided by Serviceguard on HP-UX.

Either way its not failing over because its not configured properly in the run packages.

If you have two packages and one floating IP address, the IP address can't exist on two workstations/nodes at the same time. So the package may go without its ip address.

To solve this problem under RH clustering, I created joint packages that have the IP address bound to the package and the two or more startup scripts bound to the IP address so wherever the IP address goes, the packages trail along.

This can be done with SG/RAC as well.

SEP