Oracle 10g RAC 如何配置 VIP IPMP

標籤：style   blog   color   os   io   使用   ar   for   資料   

metalink note 283107.1介紹了如何設定VIP的IPMP，此處記錄一下設定過程。

o Existing 10g RAC installation   ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^      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,       to use the two 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.78.1/255.255.252.0/ce0\|ce1        # srvctl start nodeapps -n jpsun1580

節點1修改過程

• 查看節點1當前情況

[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 1500 index 2        inet 10.99.32.10 netmask ffffff00 broadcast 10.99.32.255        groupname prod-ipmpbnx1: flags=1000843<UP,BROADCAST,RUNNING,MULTICAST,IPv4> mtu 1500 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 1500 index 3        inet 10.99.32.11 netmask ffffff00 broadcast 10.99.32.255bnx2: flags=1000843<UP,BROADCAST,RUNNING,MULTICAST,IPv4> mtu 1500 index 4        inet 192.168.5.10 netmask ffffff00 broadcast 192.168.5.255        groupname priv-ipmpbnx3: flags=1000843<UP,BROADCAST,RUNNING,MULTICAST,IPv4> mtu 1500 index 5        inet 0.0.0.0 netmask ff000000 broadcast 0.255.255.255        groupname priv-ipmp

[email protected]:~ $> crs_stat -tName           Type           Target    State     Host        ------------------------------------------------------------ora....scdb.db application    ONLINE    ONLINE    ofs0...sc02 ora....b1.inst application    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 其中bnx0和bnx1是IPMP組prod-ipmp組的兩個成員，目前OCR中記錄的VIP使用的網卡是bnx1，因此VIP 10.99.32.11被加到了bnx1上。

• 停止nodeapps，並修改nodeapps設定

[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 application    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.這個命令需要用root執行

[email protected]:~ $> su - rootPassword: Sun Microsystems Inc.   SunOS 5.10      Generic January 2005You have 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 be set to the main    directory that contains Oracle products.    Set and export ORACLE_HOME, then re-run.需要先裝置ORACLE_HOME環境變數

-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

• 檢查並啟動nodeapps的配置

[email protected]:~ $> srvctl config nodeapps -n ofs00mlctsc01 -aVIP 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 application    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 [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 1500 index 2        inet 10.99.32.10 netmask ffffff00 broadcast 10.99.32.255        groupname prod-ipmpbnx0:1: flags=1040843<UP,BROADCAST,RUNNING,MULTICAST,DEPRECATED,IPv4> mtu 1500 index 2        inet 10.99.32.11 netmask ffffff00 broadcast 10.99.32.255bnx1: flags=1000843<UP,BROADCAST,RUNNING,MULTICAST,IPv4> mtu 1500 index 3        inet 0.0.0.0 netmask ff000000 broadcast 0.255.255.255        groupname prod-ipmpbnx2: flags=1000843<UP,BROADCAST,RUNNING,MULTICAST,IPv4> mtu 1500 index 4        inet 192.168.5.10 netmask ffffff00 broadcast 192.168.5.255        groupname priv-ipmpbnx3: flags=1000843<UP,BROADCAST,RUNNING,MULTICAST,IPv4> mtu 1500 index 5        inet 0.0.0.0 netmask ff000000 broadcast 0.255.255.255        groupname priv-ipmp修改了OCR中的配置以後，VIP回到了bnx0上。

節點2修改過程與節點1類似

[email protected]:~ $> crs_stat -tName           Type           Target    State     Host        ------------------------------------------------------------ora....scdb.db application    ONLINE    ONLINE    ofs0...sc02 ora....b1.inst application    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  [email 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 application    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               [email protected]:~ $> su - root                               Password: Sun Microsystems Inc.   SunOS 5.10      Generic January 2005You have 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    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 

[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 1500 index 2        inet 10.99.32.20 netmask ffffff00 broadcast 10.99.32.255        groupname prod-ipmpbnx0:1: flags=1040843<UP,BROADCAST,RUNNING,MULTICAST,DEPRECATED,IPv4> mtu 1500 index 2        inet 10.99.32.21 netmask ffffff00 broadcast 10.99.32.255bnx1: flags=1000843<UP,BROADCAST,RUNNING,MULTICAST,IPv4> mtu 1500 index 3        inet 0.0.0.0 netmask ff000000 broadcast 0.255.255.255        groupname prod-ipmpbnx2: flags=1000843<UP,BROADCAST,RUNNING,MULTICAST,IPv4> mtu 1500 index 4        inet 192.168.5.20 netmask ffffff00 broadcast 192.168.5.255        groupname priv-ipmpbnx3: flags=1000843<UP,BROADCAST,RUNNING,MULTICAST,IPv4> mtu 1500 index 5        inet 0.0.0.0 netmask ff000000 broadcast 0.255.255.255        groupname priv-ipmp

在修改過程中並未停止資料庫，因此此操作應該是可以線上做。不過在操作過程中listener和VIP會被停掉，這一點需要注意。

Oracle 10g RAC 如何配置 VIP IPMP