oracle 12c RAC修改public ip (不同網(wǎng)段)

1、oracle 12c RAC修改public ip （不同網(wǎng)段）本實驗從10.136.173網(wǎng)段遷移到10.224.212網(wǎng)段（不修改私有網(wǎng)絡）修改public ip 為不同網(wǎng)段，就需要修改vip和scanip修改public 選擇一個節(jié)點（這里選擇BJYZ-PS-LTE-APP146）查看hosts設置oracleBJYZ-PS-LTE-APP146 $ cat /etc/hosts localhost localhost.localdomain localhost4 localhost4.localdomain4:1 localhost localhost.localdo

2、main localhost6 localhost6.localdomain6#node2 BJYZ-PS-LTE-APP146. BJYZ-PS-LTE-APP1467 BJYZ-PS-LTE-APP146- BJYZ-PS-LTE-APP146-vip5 BJYZ-PS-LTE-APP146- BJYZ-PS-LTE-APP146-priv#node0 BJYZ-PS-LTE-APP144. BJYZ-PS-LTE-APP1441

3、8 BJYZ-PS-LTE-APP144- BJYZ-PS-LTE-APP144-vip3 BJYZ-PS-LTE-APP144- BJYZ-PS-LTE-APP144-priv#scanip 6 cluster-scan查看crs資源狀態(tài)rootBJYZ-PS-LTE-APP146 bin# ./crsctl stat res -t-Name Target State Server State details -Local Resources-o

4、ra.CRS.dg ONLINE ONLINE bjyz-ps-lte-app144 STABLE ONLINE ONLINE bjyz-ps-lte-app146 STABLEora.DATA.dg ONLINE ONLINE bjyz-ps-lte-app144 STABLE ONLINE ONLINE bjyz-ps-lte-app146 STABLEora.LISTENER.lsnr ONLINE ONLINE bjyz-ps-lte-app144 STABLE ONLINE ONLINE bjyz-ps-lte-app146 STABLEora.asm ONLINE ONLINE b

5、jyz-ps-lte-app144 Started,STABLE ONLINE ONLINE bjyz-ps-lte-app146 Started,STABLEwork ONLINE ONLINE bjyz-ps-lte-app144 STABLE ONLINE ONLINE bjyz-ps-lte-app146 STABLEora.ons ONLINE ONLINE bjyz-ps-lte-app144 STABLE ONLINE ONLINE bjyz-ps-lte-app146 STABLE-Cluster Resources-ora.LISTENER_SCAN1.lsnr 1 ONLI

6、NE ONLINE bjyz-ps-lte-app146 STABLEora.MGMTLSNR 1 ONLINE ONLINE bjyz-ps-lte-app146 5 11.11 .11.15,STABLEora.bighead.db 1 ONLINE ONLINE bjyz-ps-lte-app146 Open,STABLE 2 ONLINE ONLINE bjyz-ps-lte-app144 Open,STABLEora.bjyz-ps-lte-app144.vip 1 ONLINE ONLINE bjyz-ps-lte-app144 STABLEora.bjy

7、z-ps-lte-app146.vip 1 ONLINE ONLINE bjyz-ps-lte-app146 STABLEora.cvu 1 ONLINE ONLINE bjyz-ps-lte-app146 STABLEora.mgmtdb 1 ONLINE ONLINE bjyz-ps-lte-app146 Open,STABLEora.oc4j 1 ONLINE ONLINE bjyz-ps-lte-app146 STABLEora.scan1.vip 1 ONLINE ONLINE bjyz-ps-lte-app146 STABLE gridBJYZ-PS-LTE-APP146

8、 bin$ ./ocrcheckOracle 集群注冊表的狀態(tài)如下: 版本 : 4 總空間 (KB) : 409568 已用空間 (KB) : 1840 可用空間 (KB): 407728 ID : 240192001 設備/文件名 : +CRS 設備/文件完整性檢查成功 設備/文件尚未配置 設備/文件尚未配置 設備/文件尚未配置 設備/文件尚未配置 集群注冊表完整性檢查成功  查看當前public配置gridBJYZ-PS-LTE-APP146 bin$ ./oifcfg getifbond0 global publicib0 11.11.11.

9、0 global cluster_interconnect顯示為10.136.173網(wǎng)段，那么要改為4網(wǎng)段rootBJYZ-PS-LTE-APP146 bin# ./oifcfg delif -global bond0/rootBJYZ-PS-LTE-APP146 bin# ./oifcfg setif -global bond0/4:publicrootBJYZ-PS-LTE-APP146 bin# ./oifcfg getifib0 global cluster_interconnectbond0

10、 4 global public另一個節(jié)點的情況：gridBJYZ-PS-LTE-APP144 bin$ ./oifcfg getifib0 global cluster_interconnectbond0 4 global public 修改兩節(jié)點hosts文件 只改pubic vip ip 的網(wǎng)段#node20 BJYZ-PS-LTE-APP146. BJYZ-PS-LTE-APP14621 BJYZ-PS-LTE-APP146-

11、 BJYZ-PS-LTE-APP146-vip5 BJYZ-PS-LTE-APP146- BJYZ-PS-LTE-APP146-priv#node22 BJYZ-PS-LTE-APP144. BJYZ-PS-LTE-APP14423 BJYZ-PS-LTE-APP144- BJYZ-PS-LTE-APP144-vip3 BJYZ-PS-LTE-APP144- BJYZ-PS-LTE-APP144-priv#scanip 10.13

12、6.173.66 cluster-scan修改實際public地址為212網(wǎng)段的，兩個節(jié)點都要改。oracleBJYZ-PS-LTE-APP146 $ cat /etc/sysconfig/network-scripts/ifcfg-bond0 DEVICE=bond0ONBOOT=yesBOOTPROTO=staticIPADDR=20NETMASK=92GATEWAY=5USERCTL=no修改完后service network restart修改vip 依然選擇rac1（官方

13、文檔中是停一個節(jié)點修改這個節(jié)點，然后啟動在修改下一個節(jié)點）rootBJYZ-PS-LTE-APP146 bin# ./crsctl stat res -t-Name Target State Server State details -Local Resources-ora.CRS.dg ONLINE ONLINE bjyz-ps-lte-app144 STABLE ONLINE ONLINE bjyz-ps-lte-app146 STABLEora.DATA.dg ONLINE ONLINE bjyz-ps-lte-app144 STABLE ONLINE ONLINE bjyz-ps-lt

14、e-app146 STABLEora.LISTENER.lsnr ONLINE OFFLINE bjyz-ps-lte-app144 STABLE ONLINE OFFLINE bjyz-ps-lte-app146 STABLEora.asm ONLINE ONLINE bjyz-ps-lte-app144 Started,STABLE ONLINE ONLINE bjyz-ps-lte-app146 Started,STABLEwork ONLINE OFFLINE bjyz-ps-lte-app144 STABLE ONLINE OFFLINE bjyz-ps-lte-app146 STA

15、BLEora.ons ONLINE OFFLINE bjyz-ps-lte-app144 STABLE ONLINE OFFLINE bjyz-ps-lte-app146 STABLE-Cluster Resources-ora.LISTENER_SCAN1.lsnr 1 ONLINE OFFLINE STABLEora.MGMTLSNR 1 ONLINE ONLINE bjyz-ps-lte-app146 5 11.11 .11.15,STABLEora.bighead.db 1 OFFLINE OFFLINE Instance Shutdown,ST ABLE 2

16、 OFFLINE OFFLINE Instance Shutdown,ST ABLEora.bjyz-ps-lte-app144.vip 1 ONLINE OFFLINE STABLEora.bjyz-ps-lte-app146.vip 1 ONLINE OFFLINE STABLEora.cvu 1 ONLINE OFFLINE STABLEora.mgmtdb 1 ONLINE ONLINE bjyz-ps-lte-app146 Open,STABLEora.oc4j 1 ONLINE ONLINE bjyz-ps-lte-app146 STABLEora.scan1.vip 1 ONLI

17、NE OFFLINE STABLE-oracleBJYZ-PS-LTE-APP146 $ srvctl config nodeapps -a網(wǎng)絡1存在子網(wǎng) IPv4: //bond0, static子網(wǎng) IPv6: 試通目標: 網(wǎng)絡已啟用網(wǎng)絡已在以下節(jié)點上分別啟用: 網(wǎng)絡已在以下節(jié)點上分別禁用: VIP 存在: 網(wǎng)絡編號 1, 托管節(jié)點 bjyz-ps-lte-app144VIP 名稱: BJYZ-PS-LTE-APP144-VIP IPv4 地址: 8VIP IPv6 地址: VIP 已啟用。VIP

18、 已在以下節(jié)點上分別啟用: VIP 已在以下節(jié)點上分別禁用: VIP 存在: 網(wǎng)絡編號 1, 托管節(jié)點 bjyz-ps-lte-app146VIP 名稱: BJYZ-PS-LTE-APP146-VIP IPv4 地址: 7VIP IPv6 地址: VIP 已啟用。VIP 已在以下節(jié)點上分別啟用: VIP 已在以下節(jié)點上分別禁用:停止節(jié)點1的實例和vip資源rootrac1 bin# ./srvctl stop instance -d bighead -n BJYZ-PS-LTE-APP146rootrac1 bin# ./srvctl stop vi

19、p -n BJYZ-PS-LTE-APP146 -fPRCC-1017 : 90 was already stopped on rac1PRCR-1005 : Resource ora.rac1.vip is already stopped修改兩節(jié)點對應的viprootrac1 bin# ./srvctl modify nodeapps -n BJYZ-PS-LTE-APP146 -A 21/92/bond0rootrac1 bin# ./srvctl modify nodeapps -n BJYZ-PS-LTE-AP

20、P144 -A 23/92/bond0查看結(jié)果rootBJYZ-PS-LTE-APP146 bin# ./srvctl config nodeapps -aNetwork 1 existsSubnet IPv4: 4/92/bond0, staticSubnet IPv6: Ping Targets: Network is enabledNetwork is individually enabled on nodes: Network is individually disabled on no

21、des: VIP exists: network number 1, hosting node bjyz-ps-lte-app144VIP Name: BJYZ-PS-LTE-APP144-VIP IPv4 Address: 23VIP IPv6 Address: VIP is enabled.VIP is individually enabled on nodes: VIP is individually disabled on nodes: VIP exists: network number 1, hosting node bjyz-ps-lt

22、e-app146VIP Name: BJYZ-PS-LTE-APP146-VIP IPv4 Address: 21VIP IPv6 Address: VIP is enabled.VIP is individually enabled on nodes: VIP is individually disabled on nodes:重啟vip和instancerootBJYZ-PS-LTE-APP146 bin# ./srvctl start vip -n BJYZ-PS-LTE-APP146PRKO-2420 : VIP BJYZ-PS-LTE-AP

23、P146- is already started on nodes: bjyz-ps-lte-app146rootBJYZ-PS-LTE-APP146 bin# ./srvctl start listener -n BJYZ-PS-LTE-APP146PRCC-1015 : LISTENER was already running on bjyz-ps-lte-app146PRCR-1004 : Resource ora.LISTENER.lsnr is already runningrootBJYZ-PS-LTE-APP146 bin# ./srvctl start vi

24、p -n BJYZ-PS-LTE-APP144PRKO-2420 : VIP BJYZ-PS-LTE-APP144- is already started on nodes: bjyz-ps-lte-app144rootBJYZ-PS-LTE-APP146 bin# ./srvctl start listener -n BJYZ-PS-LTE-APP144PRCC-1015 : LISTENER was already running on bjyz-ps-lte-app144PRCR-1004 : Resource ora.LISTENER.lsnr is already

25、 running啟動數(shù)據(jù)庫：oracleBJYZ-PS-LTE-APP146 $ srvctl start database -d bigheadoracleBJYZ-PS-LTE-APP146 $ srvctl status database -d bighead實例 bighead1 正在節(jié)點 bjyz-ps-lte-app146 上運行實例 bighead2 正在節(jié)點 bjyz-ps-lte-app144 上運行自己重啟了？看一下資源狀態(tài)gridBJYZ-PS-LTE-APP146 bin$ ./crsctl stat res -t-Name Target State Server St

26、ate details -Local Resources-ora.CRS.dg ONLINE ONLINE bjyz-ps-lte-app144 STABLE ONLINE ONLINE bjyz-ps-lte-app146 STABLEora.DATA.dg ONLINE ONLINE bjyz-ps-lte-app144 STABLE ONLINE ONLINE bjyz-ps-lte-app146 STABLEora.LISTENER.lsnr ONLINE ONLINE bjyz-ps-lte-app144 STABLE ONLINE ONLINE bjyz-ps-lte-app146

27、 STABLEora.asm ONLINE ONLINE bjyz-ps-lte-app144 Started,STABLE ONLINE ONLINE bjyz-ps-lte-app146 Started,STABLEwork ONLINE ONLINE bjyz-ps-lte-app144 STABLE ONLINE ONLINE bjyz-ps-lte-app146 STABLEora.ons ONLINE ONLINE bjyz-ps-lte-app144 STABLE ONLINE ONLINE bjyz-ps-lte-app146 STABLE-Cluster Resources-

28、ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE bjyz-ps-lte-app144 STABLEora.MGMTLSNR 1 ONLINE ONLINE bjyz-ps-lte-app146 5 11.11 .11.15,STABLEora.bighead.db 1 ONLINE ONLINE bjyz-ps-lte-app146 Open,STABLE 2 ONLINE ONLINE bjyz-ps-lte-app144 Open,STABLEora.bjyz-ps-lte-app144.vip 1 ONLINE ONLINE bj

29、yz-ps-lte-app144 STABLEora.bjyz-ps-lte-app146.vip 1 ONLINE ONLINE bjyz-ps-lte-app146 STABLEora.cvu 1 ONLINE ONLINE bjyz-ps-lte-app146 STABLEora.mgmtdb 1 ONLINE ONLINE bjyz-ps-lte-app146 Open,STABLEora.oc4j 1 ONLINE ONLINE bjyz-ps-lte-app146 STABLEora.scan1.vip 1 ONLINE ONLINE bjyz-ps-lte-app144 STAB

30、LE- 修改scanip （這次選擇rac2）我的scanip 名字就叫scanipgridBJYZ-PS-LTE-APP146 bin$ ./srvctl config scanSCAN name: , Network: 1Subnet IPv4: 4/92/bond0, staticSubnet IPv6: SCAN 0 IPv4 VIP: 6SCAN VIP is enabled.SCAN VIP is individually enabled on nodes: S

31、CAN VIP is individually disabled on nodes:#顯示還是173網(wǎng)段停止scan和listenerrootBJYZ-PS-LTE-APP146 bin# ./srvctl stop scan_listenerrootBJYZ-PS-LTE-APP146 bin# ./srvctl stop scan修改兩節(jié)點hosts文件rootBJYZ-PS-LTE-APP146 bin# cat /etc/hosts localhost localhost.localdomain localhost4 localhost4.localdomain4:1

32、 localhost localhost.localdomain localhost6 localhost6.localdomain6#node20 BJYZ-PS-LTE-APP146. BJYZ-PS-LTE-APP14621 BJYZ-PS-LTE-APP146- BJYZ-PS-LTE-APP146-vip5 BJYZ-PS-LTE-APP146- BJYZ-PS-LTE-APP146-priv#node22 BJYZ-PS-LTE-AP

33、P144. BJYZ-PS-LTE-APP14423 BJYZ-PS-LTE-APP144- BJYZ-PS-LTE-APP144-vip3 BJYZ-PS-LTE-APP144- BJYZ-PS-LTE-APP144-priv#scanip 24 cluster-scan #修改為212網(wǎng)段修改scaniprootBJYZ-PS-LTE-APP146 bin# ./srvctl modify scan -n cluster-scan

34、.rootBJYZ-PS-LTE-APP146 bin# ./srvctl config scanSCAN name: , Network: 1Subnet IPv4: 4/92/bond0, staticSubnet IPv6: SCAN 0 IPv4 VIP: 24SCAN VIP is enabled.SCAN VIP is individually enabled on nodes: SCAN VIP is individually disabled on nodes:修改成功，重啟scan和listenerrootBJYZ-PS-LTE-APP146 bin# ./srvctl start scanrootBJYZ-PS-LTE-APP146 bin# ./srvctl start scan_listenerrootBJYZ-PS-LTE-APP146 bin# ./crsctl stat res -t-Name Target State Server State details -Local Resources-ora.CRS.dg ONLINE O