How Oracle 10g RAC configures VIP IPMP

Metalink Note 283107.1 describes how to set up an IPMP for a VIP, where the setup process is recorded.

o Existing 10g RAC installation ^^ ^^ ^^ ^^ ^^ ^^ ^^ ^^ ^^ ^^ the ^^ ^^ ^^ ^^ ^^   ^      for Existing 10g RAC installations, use SRVCTL to Modify the VIP to use all the NIC ' s       within the same IPMP group.  The following example is configuring the VIP for jphp1580, the "to use the       " the "the" NIC "s specified in the" command line.        # srvctl Stop nodeapps-n jpsun1580        # srvctl Modify Nodeapps-n jpsun1580-o/u01/app/oracle/product/10gdb-a 146.56.7 8.1/255.255.252.0/ce0\|ce1        # srvctl start Nodeapps-n jpsun1580

Node 1 modification Process

• View Node 1 Current situation

[email protected]: ~ $> srvctl config nodeapps-n ofs00mlctsc01-avip exists.:/ofs00mlctsc01-vip/10.99.32.11 /255.255.255.0/bnx1

[email protected]:~ $> srvctl config nodeapps-n ofs00mlctsc01ofs00mlctsc01 mlctscdb1/app/oracle/product/10.2

[email protected]:~ $> ifconfig-alo0:flags=2001000849< up, Loopback,running,multicast,ipv4,virtual>MTU 8232 index 1 inet 127.0.0.1 netmask ff000000 bnx0:flags=1000843< up, Broadcast,running,multicast,ipv4>MTU index 2 inet 10.99.32.10 netmask ffffff00 broadcast 10.99.32.255 groupname Prod-ipmpbnx1:flag s=1000843< up, Broadcast,running,multicast,ipv4>MTU Index 3 inet 0.0.0.0 netmask ff000000 broadcast 0.255.255.255 groupname prod-ipmpbnx1:1: Flags =1040843< up, Broadcast,running,multicast,deprecated,ipv4>MTU Index 3 inet 10.99.32.11 netmask ffffff00 broadcast 10.99.32.255bnx2:flags=1000843< up, Broadcast,running,multicast,ipv4>MTU Index 4 inet 192.168.5.10 netmask ffffff00 broadcast 192.168.5.255 groupname PRIV-IPMPBNX3:FL ags=1000843< up, Broadcast,running,multicast,ipv4> MTU index 5 inet 0.0.0.0 netmask ff000000 broadcast 0.255.255.255 Groupna Me PRIV-IPMP 

[email protected]:~ $> crs_stat-tname Type Target State Host------------------ ------------------------------------------ora....scdb.db application online online ofs0...sc02 ora....b1.inst app lication Online Online ofs0...sc01 ora....b2.inst application online online ofs0...sc02 ora .... Sm1.asm application online online ofs0...sc01 ora .... 01.lsnr application Online Online ofs0...sc01 ora....c01.gsd application online online ofs0...sc01 ora. .. C01.ons application Online Online ofs0...sc01 ora....c01.vip application online online ofs0...sc01 ora. .. Sm2.asm application online online ofs0...sc02 ora .... 02.lsnr application Online Online ofs0...sc02 ora....c02.gsd application online online ofs0...sc02 ora. .. C02.ons application Online Online ofs0...sc02 ora....c02.vip application online online ofs0...sc02 where bnx 0 and Bnx1 are two of the IPMP group PROD-IPMP groupsMembers, the current OCR recorded in the VIP use of the network card is bnx1, so VIP 10.99.32.11 was added to the bnx1. 

• Stop Nodeapps and modify the Nodeapps settings

[Email protected]:~ $> srvctl Stop Nodeapps-n OFS00MLCTSC01

[email protected]:~ $> crs_stat-tname Type Target State Host------------------ ------------------------------------------ora....scdb.db application online online ofs0...sc02 ora....b1.inst app lication Online Online ofs0...sc01 ora....b2.inst application online online ofs0...sc02 ora .... Sm1.asm application online online ofs0...sc01 ora .... 01.lsnr Application OFFLINE OFFLINE ORA....C01.GSD application OFFLINE OFFLINE ora. .. C01.ons Application OFFLINE OFFLINE ORA....C01.VIP application OFFLINE OFFLINE ora. .. Sm2.asm application online online ofs0...sc02 ora .... 02.lsnr application Online Online ofs0...sc02 ora....c02.gsd application online online ofs0...sc02 ora. ..  C02.ons application Online Online ofs0...sc02 ora....c02.vip application online online OFS0...SC02

[Email protected]:~ $> srvctl Modify Nodeapps-n ofs00mlctsc01-o/app/oracle/product/10.2-a 10.99.32.11/255.255.255. 0/bnx0\|bnx1prko-2117:this command should be executed as the System privilege user. This command needs to be executed with root.

[Email protected]:~ $> Su-rootpassword:sun Microsystems Inc.   SunOS 5.10      Generic January 2005You has new mail.

-bash-3.00#/app/oracle/product/10.2/bin/srvctl Modify Nodeapps-n ofs00mlctsc01-o/app/oracle/product/10.2-a 10.99.32.11/255.255.255.0/bnx0\|bnx1****oracle_home environment variable not set!    Oracle_home should is set to the main    directory, which contains Oracle products.    Set and Export Oracle_home, then re-run. device Oracle_home Environment variables required

-bash-3.00# Export oracle_home=/app/oracle/product/10.2

-bash-3.00#/app/oracle/product/10.2/bin/srvctl Modify Nodeapps-n ofs00mlctsc01-o/app/oracle/product/10.2-a 10.99.32.11/255.255.255.0/bnx0\|bnx1

-bash-3.00# Exitlogout

• Check and start the Nodeapps configuration

[email protected]:~ $> srvctl config nodeapps-n ofs00mlctsc01-a VIP exists.:/ofs00mlctsc01-vip/10.99.32.11/255.255.255.0/bnx0:bnx1

[email protected]:~ $> srvctl config nodeapps-n ofs00mlctsc01ofs00mlctsc01 mlctscdb1/app/oracle/product/10.2[email protected]:~ $> srvctl start nodeapps-n ofs00mlctsc01

[email protected]:~ $> crs_stat-tname Type Target State Host------------------ ------------------------------------------ora....scdb.db application online online ofs0...sc02 ora....b1.inst app lication Online Online ofs0...sc01 ora....b2.inst application online online ofs0...sc02 ora .... Sm1.asm application online online ofs0...sc01 ora .... 01.lsnr application Online Online ofs0...sc01 ora....c01.gsd application online online ofs0...sc01 ora. .. C01.ons application Online Online ofs0...sc01 ora....c01.vip application online online ofs0...sc01 ora. .. Sm2.asm application online online ofs0...sc02 ora .... 02.lsnr application Online Online ofs0...sc02 ora....c02.gsd application online online ofs0...sc02 ora. .. C02.ons application Online Online ofs0...sc02 ora....c02.vip application online online OFS0...SC02 [emai l protected]:~ $> ifconfig-alo0:flags=2001000849 < up, Loopback,running,multicast,ipv4,virtual>MTU 8232 index 1 inet 127.0.0.1 netmask ff000000 bnx0:flags=1000843< up, Broadcast,running,multicast,ipv4>MTU index 2 inet 10.99.32.10 netmask ffffff00 broadcast 10.99.32.255 groupname prod-ipmpbnx0:1: FL ags=1040843< up, Broadcast,running,multicast,deprecated,ipv4>MTU index 2 inet 10.99.32.11 netmask ffffff00 broadcast 10.99.32.255bnx1:flags=1000843< up, Broadcast,running,multicast,ipv4>MTU Index 3 inet 0.0.0.0 netmask ff000000 broadcast 0.255.255.255 groupname Prod-ipmpbnx2:flags=1 000843< up, Broadcast,running,multicast,ipv4>MTU Index 4 inet 192.168.5.10 netmask ffffff00 broadcast 192.168.5.255 groupname PRIV-IPMPBNX3:FL ags=1000843< up, Broadcast,running,multicast,ipv4>MTU Index 5 inet 0.0.0.0 netmask ff000000 broadcast 0.255.255.255 groupname PRIV-IPMP after modifying the configuration in OCR, The VIP returned to the bnx0. 

Node 2 modification process is similar to Node 1

[email protected]:~ $> crs_stat-tname Type Target State Host------------------ ------------------------------------------ora....scdb.db application online online ofs0...sc02 ora....b1.inst app lication Online Online ofs0...sc01 ora....b2.inst application online online ofs0...sc02 ora .... Sm1.asm application online online ofs0...sc01 ora .... 01.lsnr application Online Online ofs0...sc01 ora....c01.gsd application online online ofs0...sc01 ora. .. C01.ons application Online Online ofs0...sc01 ora....c01.vip application online online ofs0...sc01 ora. .. Sm2.asm application online online ofs0...sc02 ora .... 02.lsnr application Online Online ofs0...sc02 ora....c02.gsd application online online ofs0...sc02 ora. .. C02.ons application Online Online ofs0...sc02 ora....c02.vip application online online OFS0...SC02 [EMA il protected]:~ $> Srvctl config nodeapps-n ofs00mlctsc02ofs00mlctsc02 mlctscdb2/app/oracle/product/10.2

 [email protected]:~ $> srvctl config nodeapps-n ofs00mlctsc02-avip exists. :/ofs00mlctsc02-vip/10.99.32.21/255.255.255.0/bnx1  

[email protected]:~ $> crs_stat-tname Type Target State Host------------------ ------------------------------------------ora....scdb.db application online online ofs0...sc02 ora....b1.inst app lication Online Online ofs0...sc01 ora....b2.inst application online online ofs0...sc02 ora .... Sm1.asm application online online ofs0...sc01 ora .... 01.lsnr application Online Online ofs0...sc01 ora....c01.gsd application online online ofs0...sc01 ora. .. C01.ons application Online Online ofs0...sc01 ora....c01.vip application online online ofs0...sc01 ora. .. Sm2.asm application online online ofs0...sc02 ora .... 02.lsnr Application OFFLINE OFFLINE ORA....C02.GSD application OFFLINE OFFLINE ora. .. C02.ons Application OFFLINE OFFLINE ORA....C02.VIP application OFFLINE OFFLINE [Emai l protected]:~ $> Su-root Password:sun Microsystems Inc. SunOS 5.10 Generic January 2005You has new mail.

-bash-3.00# Export oracle_home=/app/oracle/product/10.2

-bash-3.00#/app/oracle/product/10.2/bin/srvctl Modify Nodeapps-n ofs00mlctsc02-o/app/oracle/product/10.2-a 10.99.32.21/255.255.255.0/bnx0\|bnx1

-bash-3.00# exitlogout[email protected]:~ $> srvctl start nodeapps-n ofs00mlctsc02[email protected]:~ $ > Crs_stat-tname Type Target State Host-------------------------------------------- ----------------ora....scdb.db application Online online ofs0...sc02 ora....b1.inst application online Onli NE ofs0...sc01 ora....b2.inst application online online ofs0...sc02 ora .... Sm1.asm application online online ofs0...sc01 ora .... 01.lsnr application Online Online ofs0...sc01 ora....c01.gsd application online online ofs0...sc01 ora. .. C01.ons application Online Online ofs0...sc01 ora....c01.vip application online online ofs0...sc01 ora. .. Sm2.asm application online online ofs0...sc02 ora .... 02.lsnr application Online Online ofs0...sc02 ora....c02.gsd application online online ofs0...sc02 ora. .. C02.ons application online Online ofs0...sc02 oRA....C02.VIP Application Online Online OFS0...SC02  

[email protected]:~ $> ifconfig-alo0:flags=2001000849< up, Loopback,running,multicast,ipv4,virtual>MTU 8232 index 1 inet 127.0.0.1 netmask ff000000 bnx0:flags=1000843< up, Broadcast,running,multicast,ipv4>MTU index 2 inet 10.99.32.20 netmask ffffff00 broadcast 10.99.32.255 groupname prod-ipmpbnx0:1: F lags=1040843< up, Broadcast,running,multicast,deprecated,ipv4>MTU index 2 inet 10.99.32.21 netmask ffffff00 broadcast 10.99.32.255bnx1:flags=1000843< up, Broadcast,running,multicast,ipv4>MTU Index 3 inet 0.0.0.0 netmask ff000000 broadcast 0.255.255.255 groupname Prod-ipmpbnx2:flags=1 000843< up, Broadcast,running,multicast,ipv4>MTU Index 4 inet 192.168.5.20 netmask ffffff00 broadcast 192.168.5.255 groupname PRIV-IPMPBNX3:FL ags=1000843< up, Broadcast,running,multicast,ipv4>MTU Index 5 inet 0.0.0.0 netmask ff000000 broadcast 0.255.255.255 groupname PRIV-IPMP

The database was not stopped during the modification process, so this should be done online. However, it is important to note that listener and VIPs will be stopped during the operation.

How Oracle 10g RAC configures VIP IPMP