重庆思庄Oracle、Redhat认证学习论坛

标题: oracle rac 11g修改IP地址 [打印本页]

作者: 橡皮草帽 时间: 2020-2-26 22:04
标题: oracle rac 11g修改IP地址
本帖最后由橡皮草帽于 2020-2-26 22:30 编辑

实验环境：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

作者: 橡皮草帽 时间: 2020-2-26 22:17
本帖最后由橡皮草帽于 2020-2-26 22:31 编辑

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:27
本帖最后由橡皮草帽于 2020-2-26 22:30 编辑

橡皮草帽发表于 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:34

橡皮草帽发表于 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:39

橡皮草帽发表于 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:42

橡皮草帽发表于 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

欢迎光临重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/)