Re: Oracle 10gR2 RAC VIP Question

From: Naqi Mirza <naqimirza_at_yahoo.com>
Date: Wed, 28 Mar 2007 10:59:48 -0700 (PDT)
Message-ID: <631414.99766.qm@web32411.mail.mud.yahoo.com>

I also see the following in the vip log file, just wondering if anyone has a clue about this?:
.

2007-03-28 00:17:02.059: [ RACG][1] [28130][1][ora.aquadb1.vip]: Wed Mar 28 00:16:59 PST 2007 [ 28132 ] Checking interface existance Wed Mar 28 00:16:59 PST 2007 [ 28132 ] Calling getifbyip 17Wed Mar 28 00:16:59 PST 2007 [ 28132 ] getifbyip: started for 192.25.3.17

Wed Mar 28 00:16:59 PST 2007 [ 28132 ] Completed getifb
2007-03-28 00:17:02.059: [    RACG][1] [28130][1][ora.aquadb1.vip]: yip lan0:2 ---> ???
Wed Mar 28 00:16:59 PST 2007 [ 28132 ] Completed with initial interface test
Wed Mar 28 00:16:59 PST 2007 [ 28132 ] Broadcast = 192.25.3.255
Wed Mar 28 00:16:59 PST 2007 [ 28132 ] checkIf: start for if=lan0
Wed Mar 28 00:16:59 PST 2007 [ 28132 
2007-03-28 00:17:02.059: [    RACG][1] [28130][1][ora.aquadb1.vip]: ] checkIf: get default gw
Wed Mar 28 00:16:59 PST 2007 [ 28132 ] defaultgw:  started
Wed Mar 28 00:16:59 PST 2007 [ 28132 ] defaultgw:  completed with 192.25.3.254
Wed Mar 28 00:17:01 PST 2007 [ 28132 ] checkIf: RX packets checked if=lan0 ok

Wed Mar 28 00
2007-03-28 00:17:02.059: [ RACG][1] [28130][1][ora.node1.vip]: :17:01 PST 2007 [ 28132 ] checkIf: end for if=lan0 Wed Mar 28 00:17:01 PST 2007 [ 28132 ] main: interface is okay, exit success
.

Original Message ---- From: Naqi Mirza <naqimirza_at_yahoo.com> To: oracle-l_at_freelists.org Sent: Wednesday, 28 March, 2007 2:13:25 AM Subject: Oracle 10gR2 RAC VIP Question

Hi,
I have a 2 node 10gR2 (10.2.0.2) Installation running on HP-UX (PA-RISC) 64 Bit, 11.23. HP Serviceguard Extensions for RAC (11.17) is also installed.
.

Due to maintenance both nodes were brought down. One they were brought up, I noticed that the vip for one node - node2, was running on interface lan0:2. lan0 is our public interface. Now typically, the vip runs on lan0:1. When a node is evicted from the cluster, the vip of the evicted node gets relocated from lan0:1 on the evicted node to lan0:2 on the surviving node. My question basically is, does it matter which logical interface (:1,:2,:3,:4,etc) the vip runs on for any node - be it the evicted node, or the surviving (master) node. Essentially the mapping for the vip is defined in the OCR and the /etc/hosts file. There is no mention of whether this should run on :1,:2,:3,:4,etc - only that it should be on the public interface - lan0 - which it is. A look into the ocr file, and this is all i can find:
.

[SYSTEM.css.interfaces.global.lan0.172|d25|d3|d0.1]
.

Not sure what d0.1 means?, the first three segments are those for the public network. .1 = :1 = lan0:1 ?? That said, whenever I have seen a relocation of the vip take place it goes to lan0:2 - However as mentioned earlier, lan0:2 is already in use by one of the nodes, if a relocation to this node were to take place would the the vip come up here as lan0:3 - unfortunately I can't test this out yet, but was wondering if anyone had an idea on this? Thanks

Naqi

The all-new Yahoo! Mail goes wherever you go - free your email address from your Internet provider.

What kind of emailer are you? Find out today - get a free analysis of your email personality. Take the quiz at the Yahoo! Mail Championship. http://uk.rd.yahoo.com/evt=44106/*http://mail.yahoo.net/uk

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Mar 28 2007 - 12:59:48 CDT