oracle 12c RAC修改public ip (不同网段)

1、oracle 12c RAC修改public ip （不同网段）本实验从10.136.173网段迁移到10.224.212网段（不修改私有网络）修改public ip 为不同网段，就需要修改vip和scanip修改public 选择一个节点（这里选择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资源状态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 集群注册表的状态如下: 版本 : 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网段，那么要改为4网段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另一个节点的情况：gridBJYZ-PS-LTE-APP144 bin$ ./oifcfg getifib0 global cluster_interconnectbond0 4 global public 修改两节点hosts文件 只改pubic vip ip 的网段#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网段的，两个节点都要改。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、文档中是停一个节点修改这个节点，然后启动在修改下一个节点）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网络1存在子网 IPv4: //bond0, static子网 IPv6: 试通目标: 网络已启用网络已在以下节点上分别启用: 网络已在以下节点上分别禁用: VIP 存在: 网络编号 1, 托管节点 bjyz-ps-lte-app144VIP 名称: BJYZ-PS-LTE-APP144-VIP IPv4 地址: 8VIP IPv6 地址: VIP 已启用。VIP

18、 已在以下节点上分别启用: VIP 已在以下节点上分别禁用: VIP 存在: 网络编号 1, 托管节点 bjyz-ps-lte-app146VIP 名称: BJYZ-PS-LTE-APP146-VIP IPv4 地址: 7VIP IPv6 地址: VIP 已启用。VIP 已在以下节点上分别启用: VIP 已在以下节点上分别禁用:停止节点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修改两节点对应的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查看结果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启动数据库：oracleBJYZ-PS-LTE-APP146 $ srvctl start database -d bigheadoracleBJYZ-PS-LTE-APP146 $ srvctl status database -d bighead实例 bighead1 正在节点 bjyz-ps-lte-app146 上运行实例 bighead2 正在节点 bjyz-ps-lte-app144 上运行自己重启了？看一下资源状态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网段停止scan和listenerrootBJYZ-PS-LTE-APP146 bin# ./srvctl stop scan_listenerrootBJYZ-PS-LTE-APP146 bin# ./srvctl stop scan修改两节点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网段修改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