Is Oracle-VIP LAN InteraNode FailOver Supported in ServiceGuard (SGeRAC)

[Muhammad Ahmad]

Hi SG/SGeRAC CFS Gurus,

Can ServiceGuard LAN Monitoring Capabilities Handle the Oracle-RAC-Instance's Virtual IP Failover to the available standby network interface of the same node, as it do in case of Physical-IP Failover to standby lans.

[Wim Rombauts]

Yes, it can. I use it for a while now, and maintenance on our network switches has never brought our RAC database down.
There even aren't anyspecial rules to take care of, for as far as I know.

[johnsonpk]

Hi Muhammad,
In SG environment , If sg is able to recognize a lan card failure and there is a standby interface on the same bridged lan ,SG will move all ip configures on that lan including vip to the standby interface. This applies for all sg extension

Rgds!
Johnson

[Muhammad Ahmad]

Hi Wilm/John,

In case of public lan interface down event, only physical IP will be moved to the standby lan interface not the Oracle-VIP.

Wilm:

Furthermore, during maintenance activities your database did'nt got down becasue in case of public lan down event, infact, the Oracle RAC Next-Available Instance/Cluster-Node will take care of the running oracle session on the first node (public-network-down).

In my understanding, SG can ONLY monitor/failover the physical ip addresses NOT the Oracle-VIP addresses, becuase this VIP is managed under Oracle-Clusterware not under SG.

Example:

Consider 2-nodes Oracle-RAC-Cluster with SGeRAC (Cluster-file-system):

Node-1 Network Configuration:

lan0: Physical-IP: 192.168.1.1
Oracle-VIP: 1.1.1.1
lan1: heartbeat ip
lan2: standby lan
lan3: standby lan

when lan0 got down on Node-1, the results will be:

Node-1 Network Configuration:

lan0: down
lan1: heartbeat ip
lan2: 192.168.1.1
lan3: standby lan

the Oracle-VIP was failover/assigned to the 2nd-cluster member node's public lan interface:

Node-2 Network Configuration:

lan0: Physical-IP:192.168.1.2
Oracle-VIP: 1.1.1.2
Oracle-VIP: 1.1.1.1 (came from first-node)
lan1: heartbeat ip
lan2: standby lan
lan3: standby lan

I hope to get an expert opinion, coz, we have faced this issue in our implementations.

In our understanding, we need to use APA for LAN Management for ORACLE_VIP, SG can't handle this configurations Alone.

An Expert Opinion expected.

Regards,

[johnsonpk]

Hi Muhammad,

I give up ..
Oracle rac vip does not failover to standby card..as sg is not aware of rac vip ...

Service guard will only move the vip that is configured through package(cmmodnet) provided local_lan switching is enabled in the pkg configuration file.

I have tested in our RAC cluster and the result floored me as i was in a wrong assumption..thanks for the thread ..


Thanks!
johnson

[Muhammad Ahmad]

Hi John,

Pleasur's mine.

Hi Gurus,

Any Comments / suggestions are welcome.