好久沒更新了,今天來一發,就寫下最近做的一個操作,修改11g RAC的public ip 以及 virtual ip,指令同樣适用于10g。
一.IP 資訊
原IP位址 | 新IP位址 | 說明 |
192.168.131.11 | 192.168.130.11 | scan ip |
192.168.131.13 | 192.168.130.12 | public ip |
192.168.131.14 | 192.168.130.13 | public ip |
192.168.131.23 | 192.168.130.14 | virtual ip |
192.168.131.24 | 192.168.130.15 | virtual ip |
二. OS層面網絡配置
2.1. 檢視網卡裝置資訊
--aix
ifconfig -a
lsattr -El en1
以上為AIX的指令
linux可以用以下指令檢視:
ifconfig
more /etc/sysconfig/network-scripts/ifcfg-eth0
db1:[/]#ifconfig -a
en1:flags=5e080863,18c0<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,CHECKSUM_OFFLOAD(ACTIVE),PSEG,LARGESEND,CHAIN>
inet 10.10.130.130 netmask 0xffffff00broadcast 10.10.10.255
tcp_sendspace 131072 tcp_recvspace65536 rfc1323 1
en5:flags=5e080863,18c0<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,CHECKSUM_OFFLOAD(ACTIVE),PSEG,LARGESEND,CHAIN>
inet 10.10.10.130 netmask 0xffffff00broadcast 10.10.131.255
tcp_sendspace 131072 tcp_recvspace65536 rfc1323 1
en9: flags=5e080863,18c0<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,CHECKSUM_OFFLOAD(ACTIVE),PSEG,LARGESEND,CHAIN>
inet 192.168.131.13netmask 0xffffff00 broadcast 192.168.131.255
tcp_sendspace 131072 tcp_recvspace65536 rfc1323 0
lo0:flags=e08084b,c0<UP,BROADCAST,LOOPBACK,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,LARGESEND,CHAIN>
inet 127.0.0.1 netmask 0xff000000broadcast 127.255.255.255
inet6 ::1%1/0
tcp_sendspace 131072 tcp_recvspace131072 rfc1323 1
db1:[/]#lsattr -El en9
alias4 IPv4 Alias includingSubnet Mask True
alias6 IPv6 Alias includingPrefix Length True
arp on Address Resolution Protocol(ARP) True
authority Authorized Users True
broadcast Broadcast Address True
monitor off Enable/Disable monitor for virtualEthernet True
mtu 1500 Maximum IP Packet Size for ThisDevice True
mtu_bypass off Enable/Disable largesend forvirtual Ethernet True
netaddr 192.168.131.13Internet Address True
netaddr6 IPv6 Internet Address True
netmask 255.255.255.0 Subnet Mask True
prefixlen Prefix Length for IPv6Internet Address True
remmtu 576 Maximum IP Packet Size for REMOTENetworks True
rfc1323 Enable/Disable TCP RFC1323 Window Scaling True
security none Security Level True
state up Current Interface Status True
tcp_mssdflt Set TCP Maximum SegmentSize True
tcp_nodelay Enable/Disable TCP_NODELAYOption True
tcp_recvspace Set Socket Buffer Space forReceiving True
tcp_sendspace Set Socket Buffer Space forSending True
thread off Enable/Disable threadattribute True
2.2.修改/etc/hosts (兩個節點修改)
$ vi /etc/hosts
127.0.0.1 loopback localhost # loopback (lo0) name/address
::1 loopback localhost # IPv6 loopback (lo0) name/address
#PublicNetwork -- en14
192.168.130.12 db1
192.168.130.13 db2
#PrivateInterconnect
10.10.131.130 db1-priv
10.10.131.136 db2-priv
#PublicVirtual IP (VIP) addresses
192.168.130.14 db1-vip
192.168.130.15 db2-vip
192.168.130.11 db-scan
三.修改GRID網絡配置
3.1.啟動CRS背景程序,僅保留crs的背景程序
先開啟crs再關閉相關資源
# ./crsctlstart crs
--停止相關資源:
# srvctl stopdatabase -d db
# srvctl stoplistener
# srvctl stopscan_listener
# srvctl stopscan
# srvctl stopcvu
# srvctl stopnodeapps -n db1
# srvctl stopnodeapps -n db2
--檢查資源狀态:
# crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.DATA.dg ora....up.type ONLINE ONLINE rac1
ora.FRA.dg ora....up.type ONLINE ONLINE rac1
ora....ER.lsnrora....er.type OFFLINE OFFLINE
ora....N1.lsnrora....er.type OFFLINE OFFLINE
ora....TING.dg ora....up.type ONLINE ONLINE rac1
ora.asm ora.asm.type ONLINE ONLINE rac1
ora.cvu ora.cvu.type OFFLINE OFFLINE
ora.dave.db ora....se.type ONLINE OFFLINE
ora....taf.svcora....ce.type OFFLINE OFFLINE
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora....networkora....rk.type OFFLINE OFFLINE
ora.oc4j ora.oc4j.type ONLINE ONLINE rac2
ora.ons ora.ons.type OFFLINE OFFLINE
ora....SM1.asm application ONLINE ONLINE rac1
ora....C1.lsnrapplication OFFLINE OFFLINE
ora.rac1.gsd application OFFLINE OFFLINE
ora.rac1.ons application OFFLINE OFFLINE
ora.rac1.vip ora....t1.type OFFLINE OFFLINE
ora....SM2.asm application ONLINE ONLINE rac2
ora....C2.lsnrapplication OFFLINE OFFLINE
ora.rac2.gsd application OFFLINE OFFLINE
ora.rac2.ons application OFFLINE OFFLINE
ora.rac2.vip ora....t1.type OFFLINE OFFLINE
ora.rac3.vip ora....t1.type OFFLINE OFFLINE
ora.scan1.vip ora....ip.type OFFLINE OFFLINE
注:因為11g的RAC使用ASM來存放OCR和Votingdisk , 是以要修改相關的配置資訊,就不能停止ASM執行個體。
具體的CRS的背景程序可以通過如下指令檢視:crsctl stat res -t -init
3.2.修改publicIP(隻需在一個節點上操作即可)
按新情況在主機層面修改網絡(AIX系統需要注意)
l 注意打開rfc1323參數 (=1)
no -a |fgrep rfc1323
lsattr -El en14
lsattr -El en9
no -o -prfc1323=1
--檢視配置:
$ oifcfg getif -global
en5 10.10.10.0 global cluster_interconnect
en9 192.168.131.0 global public
en1 10.10.130.0 global cluster_interconnect
# oifcfg delif-global en9
$ oifcfg setif-global en9/192.168.130.0:public
--确認
$ oifcfg getif-global
3.3.修改VIP(隻需在一個節點上操作即可)
--檢視VIP 資訊
# srvctlconfig nodeapps -a
--驗證VIP的狀态:
$ crsctl statres -t
--確定相關資源已經offline,如果沒有,手工stop一下:
$ srvctl stopinstance -d DB -n db1
$ srvctl stopvip -n db1 -f
--用root使用者修改VIP 資訊
# ./srvctlmodify nodeapps -n db1 -A 192.168.130.14/255.255.255.0/en14
# ./srvctlmodify nodeapps -n db2 -A 192.168.130.15/255.255.255.0/en14
--驗證
# srvctlconfig nodeapps -a
3.4.修改SCANIP(隻需在一個節點上操作即可)
--檢視scan狀态:
$ srvctlconfig scan
scan可不改,會自動修改。
若沒有自動修改,可參照以下步驟手動修改:
--準備修改,關閉相關服務:
$srvctl stopscan_listener
$srvctl stopscan
$srvctl statusscan
--用root進行修改:
# ./srvctlmodify scan -n db-scan
--檢查修改結果:
# srvctlconfig scan
注意:與修改private ip,vip 不一樣,修改scan ip 無需停止資料庫執行個體,asm或者重新開機crs,相對比較簡單。
3.5.重新開機clusterware(所有節點root執行)
--停止crs
# crsctl stopcrs
在所有節點執行。
--啟動crs
# crsctl startcrs
3.6.檢查所有程序的狀态
# srvctl startlistener
# srvctl startscan
# srvctl startscan_listener
# srvctl startcvu
# ./crs_stat-t
3.7.修改tnsnames.ora
vi $ORACLE_HOME/network/admin/tnsnames.ora
參考文檔:
How to Modify Private NetworkInformation in Oracle Clusterware (文檔ID 283684.1)
How to Modify Public NetworkInformation including VIP in Oracle Clusterware (文檔ID 276434.1)
----------------------------------------------------------------------------------------------
轉載須注明出處!
http://blog.csdn.net/sharqueen_wu/article/details/51314226
轉載須注明出處!
http://blog.csdn.net/sharqueen_wu/article/details/51314226
轉載須注明出處!
http://blog.csdn.net/sharqueen_wu/article/details/51314226