oracle rac 11g修改IP地址

橡皮草帽

实验环境：oracle 11.2.0.4 rac
节点1：

rac1	修改前ip地址	修改后ip地址
#Public IP	192.168.133.8  rac1	192.168.13.8  rac1
#Private IP	1.1.1.111 rac1-priv	2.2.2.111 rac1-priv
#Virtual IP	192.168.133.9 rac1-vip	192.168.13.9 rac1-vip
#Scan IP	192.168.133.77 rac-scan	192.168.13.77 rac-scan

节点2：

rac2	修改前ip地址	修改后ip地址
#Public IP	192.168.133.10  rac2	192.168.13.10  rac2
#Private IP	1.1.1.222 rac2-priv	2.2.2.222 rac2-priv
#Virtual IP	192.168.133.11 rac2-vip	192.168.13.11 rac2-vip
#Scan IP	192.168.133.77 rac-scan	192.168.13.77 rac-scan

橡皮草帽

RAC修改IP这个操作本身也只有几步操作，但是它涉及到OCR。所以要格外小心。一般来说，如果不是必须要修改的话，尽量不要去修改OCR 的东西。稳定第一。
在做之前，要手动对OCR进行一个备份，这样即使修改失败，也能还原回来。
另外，Public/Private对应的的主机名不能更改，如果确实需要更改主机名，需要重新安装CRS。

1.查看ocr的备份
[root@rac1 bin]# ./ocrconfig -showbackup

2.备份ocr
[root@rac1 bin]# ./ocrconfig -manualbackup
rac2     2020/02/26 20:15:42     /u01/app/11.2.0/grid/cdata/rac/backup_20200226_201542.ocr
[root@rac1 bin]# ./ocrconfig -showbackup
PROT-24: Auto backups for the Oracle Cluster Registry are not available
rac2     2020/02/26 20:15:42     /u01/app/11.2.0/grid/cdata/rac/backup_20200226_201542.ocr

3.关闭数据库
[root@rac1 bin]# ./srvctl stop database -d rac

橡皮草帽

橡皮草帽 发表于 2020-2-26 22:17
RAC修改IP这个操作本身也只有几步操作，但是它涉及到OCR。所以要格外小心。一般来说，如果不是必须要修改的 ...

修改Public Ip 和Private IP
1.在任意节点上修改
这里我以节点1上面进行操作
[root@rac1 bin]# ./oifcfg getif
ens33  192.168.133.0  global  public
ens34  1.1.1.0  global  cluster_interconnect
[root@rac1 bin]# ./oifcfg delif -global ens33
[root@rac1 bin]# ./oifcfg setif -global ens33/192.168.13.0:public
[root@rac1 bin]# ./oifcfg getif
ens34  1.1.1.0  global  cluster_interconnect
ens33  192.168.13.0  global  public
[root@rac1 bin]# ./oifcfg delif -global ens34
PRIF-31: Failed to delete the specified network interface because it is the last private interface
这里不允许删除最后一个私有接口，可以先添加一个私有接口再删除
[root@rac1 bin]# ./oifcfg setif -global ens34/2.2.2.0:cluster_interconnect
[root@rac1 bin]# ./oifcfg getif
ens34  1.1.1.0  global  cluster_interconnect
ens33  192.168.13.0  global  public
ens34  2.2.2.0  global  cluster_interconnect
[root@rac1 bin]# ./oifcfg delif -global ens34/1.1.1.0:cluster_interconnect
[root@rac1 bin]# ./oifcfg getif
ens33  192.168.13.0  global  public
ens34  2.2.2.0  global  cluster_interconnect

2.在任意节点上停止oracle高可用服务
[root@rac1 bin]# ./crsctl stop cluster -all
CRS-2673: Attempting to stop 'ora.crsd' on 'rac1'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac1'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rac1'
CRS-2673: Attempting to stop 'ora.cvu' on 'rac1'
CRS-2673: Attempting to stop 'ora.OCRLILI.dg' on 'rac1'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'rac1'
CRS-2673: Attempting to stop 'ora.FRA.dg' on 'rac1'
CRS-2673: Attempting to stop 'ora.oc4j' on 'rac1'
CRS-2673: Attempting to stop 'ora.rac2.vip' on 'rac1'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'rac1'
CRS-2677: Stop of 'ora.cvu' on 'rac1' succeeded
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'rac1' succeeded
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'rac1'
CRS-2677: Stop of 'ora.DATA.dg' on 'rac1' succeeded
CRS-2677: Stop of 'ora.FRA.dg' on 'rac1' succeeded
CRS-2677: Stop of 'ora.rac2.vip' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.rac1.vip' on 'rac1'
CRS-2677: Stop of 'ora.scan1.vip' on 'rac1' succeeded
CRS-2677: Stop of 'ora.rac1.vip' on 'rac1' succeeded
CRS-2677: Stop of 'ora.oc4j' on 'rac1' succeeded
CRS-2677: Stop of 'ora.OCRLILI.dg' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'rac1'
CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'rac1'
CRS-2677: Stop of 'ora.ons' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'rac1'
CRS-2677: Stop of 'ora.net1.network' on 'rac1' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac1' has completed
CRS-2677: Stop of 'ora.crsd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'rac1'
CRS-2673: Attempting to stop 'ora.evmd' on 'rac1'
CRS-2673: Attempting to stop 'ora.asm' on 'rac1'
CRS-2677: Stop of 'ora.evmd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac1'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'rac1'
CRS-2677: Stop of 'ora.cssd' on 'rac1' succeeded
CRS-4404: The following nodes did not reply within the allotted time:
rac2

3.修改ip地址并测试（所有节点都要修改）
/etc/hosts
/etc/sysconfig/network-scripts/ifcfg-ens33
/etc/sysconfig/network-scripts/ifcfg-ens34

4.在所有节点上重新启动服务
[root@rac1 bin]# ./crsctl start cluster -all

橡皮草帽

橡皮草帽 发表于 2020-2-26 22:27
修改Public Ip 和Private IP
1.在任意节点上修改
这里我以节点1上面进行操作

修改scan ip
1.停止scan_listener scan
[root@rac1 bin]# ./srvctl stop scan_listener
[root@rac1 bin]# ./srvctl stop scan

2.删除scan_listener scan
[root@rac1 bin]# ./srvctl remove scan_listener -f
[root@rac1 bin]# ./srvctl remove scan -f      

3.添加scan_listener scan
[root@rac1 bin]# ./srvctl add scan -n rac-scan -k 1 -S 192.168.13.0/255.255.255.0/ens33
PRCN-3008 : Failed to add or use registered network 1 with network subnet '192.168.13.0' because the network was already registered for network subnet '192.168.133.0'
说明:-k 1 会报错，是因为之前已经使用过
[root@rac1 bin]# ./srvctl add scan -n rac-scan -k 2 -S 192.168.13.0/255.255.255.0/ens33
[root@rac1 bin]# ./srvctl config scan
SCAN name: rac-scan, Network: 2/192.168.13.0/255.255.255.0/ens33
SCAN VIP name: scan1, IP: /rac-scan/192.168.13.77
[root@rac1 bin]# ./srvctl add scan_listener

4.启动scan_listener scan
[root@rac1 bin]# ./srvctl start scan
[root@rac1 bin]# ./srvctl start scan_listener

橡皮草帽

橡皮草帽 发表于 2020-2-26 22:34
修改scan ip
1.停止scan_listener scan
[root@rac1 bin]# ./srvctl stop scan_listener

修改Virtual IP
1.停止vip资源
[root@rac1 bin]# ./crsctl stop resource ora.rac1.vip -f
[root@rac1 bin]# ./crsctl stop resource ora.rac2.vip -f

2.查看vip状态
[root@rac1 bin]# ./crsctl stat res -t

3.修改vip地址
[root@rac1 bin]# ./srvctl modify nodeapps -A 192.168.13.9/255.255.255.0/ens33 -n rac1
[root@rac1 bin]# ./srvctl modify nodeapps -A 192.168.13.11/255.255.255.0/ens33 -n rac2

4.启动vip资源
[root@rac1 bin]# ./crsctl start resource ora.rac1.vip -f
CRS-2672: Attempting to start 'ora.rac1.vip' on 'rac1'
CRS-2676: Start of 'ora.rac1.vip' on 'rac1' succeeded
CRS-2672: Attempting to start 'ora.LISTENER.lsnr' on 'rac1'
CRS-2676: Start of 'ora.LISTENER.lsnr' on 'rac1' succeeded
[root@rac1 bin]# ./crsctl start resource ora.rac2.vip -f
CRS-2672: Attempting to start 'ora.rac2.vip' on 'rac2'
CRS-2676: Start of 'ora.rac2.vip' on 'rac2' succeeded
CRS-2672: Attempting to start 'ora.LISTENER.lsnr' on 'rac2'
CRS-2676: Start of 'ora.LISTENER.lsnr' on 'rac2' succeeded
启动vip资源后本地监听就已经启动了  下面的步骤可以不执行

5.启动本地监听
./srvctl start listener -n rac1
./srvctl start listener -n rac1

6.查看本地监听
[root@rac1 bin]# ./srvctl status listener -n rac1
Listener LISTENER is enabled on node(s): rac1
Listener LISTENER is running on node(s): rac1
[root@rac1 bin]# ./srvctl status listener -n rac2
Listener LISTENER is enabled on node(s): rac2
Listener LISTENER is running on node(s): rac2

7.查看网口配置信息
[grid@rac1 ~]$ oifcfg getif
ens33  192.168.13.0  global  public
ens34  2.2.2.0  global  cluster_interconnect

橡皮草帽

橡皮草帽 发表于 2020-2-26 22:39
修改Virtual IP
1.停止vip资源
[root@rac1 bin]# ./crsctl stop resource ora.rac1.vip -f

验证修改后的状态
这里我在节点2上进行验证
[grid@rac2 ~]$ 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.lsnr ora....er.type ONLINE    ONLINE    rac1        
ora....N1.lsnr ora....er.type ONLINE    ONLINE    rac2        
ora.OCRLILI.dg ora....up.type ONLINE    ONLINE    rac1        
ora.asm        ora.asm.type   ONLINE    ONLINE    rac1        
ora.cvu        ora.cvu.type   ONLINE    ONLINE    rac1        
ora.gsd        ora.gsd.type   OFFLINE   OFFLINE               
ora....network ora....rk.type ONLINE    ONLINE    rac1        
ora....network ora....rk.type ONLINE    ONLINE    rac1        
ora.oc4j       ora.oc4j.type  ONLINE    ONLINE    rac2        
ora.ons        ora.ons.type   ONLINE    ONLINE    rac1        
ora.rac.db     ora....se.type OFFLINE   OFFLINE               
ora....SM1.asm application    ONLINE    ONLINE    rac1        
ora....C1.lsnr application    ONLINE    ONLINE    rac1       
ora.rac1.gsd   application    OFFLINE   OFFLINE               
ora.rac1.ons   application    ONLINE    ONLINE    rac1        
ora.rac1.vip   ora....t1.type ONLINE    ONLINE    rac1       
ora....SM2.asm application    ONLINE    ONLINE    rac2        
ora....C2.lsnr application    ONLINE    ONLINE    rac2        
ora.rac2.gsd   application    OFFLINE   OFFLINE               
ora.rac2.ons   application    ONLINE    ONLINE    rac2        
ora.rac2.vip   ora....t1.type ONLINE    ONLINE    rac2        
ora.scan1.vip  ora....ip.type ONLINE    ONLINE    rac2