Oracle RAC 修改IP

RAC 修改IP 这个操作本身也只有几步操作，但是它涉及到OCR。所以要格外小心。一般来说，如果不是必须要修改的话，尽量不要去修改OCR 的东西。稳定第一。

任务：将下面的IP换个网段

enp0s3 10.203.101.0 global public

enp0s8 10.203.101.0 global public

修改为

enp0s3 10.203.111.0 global public

enp0s8 10.203.111.0 global public

在做之前，要手动的OCR 进行一个备份，这样即使修改失败，也能还原回来。 OCR的备份。

----备份ocr文件

[root@svrdba bin]# ./ocrconfig -export /u01/ocr.exp

PROT-58: successfully exported the Oracle Cluster Registry contents to file '/u01/ocr.exp'

1 ----oracle用户登录停止数据库

[oracle@svrdba ~]$ srvctl stop database -db orcl

[oracle@svrdba ~]$ srvctl status database -db orcl

Instance orcl11 is not running on node svrdba

Instance orcl12 is not running on node svrdbb

2 ----停止ASM

在svrdba执行

[oracle@svrdba ~]$ srvctl stop asm -node svrdba –force

在svrdbb执行

[oracle@svrdba ~]$ srvctl stop asm -node svrdbb –force

3 ----停止其他app

在svrdba执行

[oracle@svrdba ~]$ srvctl stop nodeapps -node svrdba -force

PRCC-1017 : ons was already stopped on svrdba

PRCR-1005 : Resource ora.ons is already stopped

在svrdbb执行

[oracle@svrdbb ~]$ srvctl stop nodeapps -node svrdbb –force

4 --- Root用户登录停止集群CRS

[root@svrdba bin]# pwd

/u01/app/12.2.0/grid/bin

[root@svrdba bin]# ./crsctl stop crs

CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'svrdba'

CRS-2673: Attempting to stop 'ora.crsd' on 'svrdba'

CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on server 'svrdba'

CRS-2673: Attempting to stop 'ora.chad' on 'svrdba'

CRS-2673: Attempting to stop 'ora.chad' on 'svrdbb'

CRS-2673: Attempting to stop 'ora.qosmserver' on 'svrdba'

CRS-2673: Attempting to stop 'ora.orcl.db' on 'svrdba'

CRS-2677: Stop of 'ora.orcl.db' on 'svrdba' succeeded

CRS-2673: Attempting to stop 'ora.DATA.dg' on 'svrdba'

CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'svrdba'

CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'svrdba'

CRS-2673: Attempting to stop 'ora.cvu' on 'svrdba'

CRS-2677: Stop of 'ora.DATA.dg' on 'svrdba' succeeded

CRS-2673: Attempting to stop 'ora.asm' on 'svrdba'

CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'svrdba' succeeded

CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'svrdba' succeeded

CRS-2673: Attempting to stop 'ora.scan1.vip' on 'svrdba'

CRS-2677: Stop of 'ora.cvu' on 'svrdba' succeeded

CRS-2677: Stop of 'ora.asm' on 'svrdba' succeeded

CRS-2673: Attempting to stop 'ora.ASMNET1LSNR_ASM.lsnr' on 'svrdba'

CRS-2677: Stop of 'ora.qosmserver' on 'svrdba' succeeded

CRS-2677: Stop of 'ora.scan1.vip' on 'svrdba' succeeded

CRS-2677: Stop of 'ora.chad' on 'svrdbb' succeeded

CRS-2677: Stop of 'ora.chad' on 'svrdba' succeeded

CRS-2673: Attempting to stop 'ora.mgmtdb' on 'svrdba'

CRS-2677: Stop of 'ora.ASMNET1LSNR_ASM.lsnr' on 'svrdba' succeeded

CRS-2677: Stop of 'ora.mgmtdb' on 'svrdba' succeeded

CRS-2673: Attempting to stop 'ora.MGMTLSNR' on 'svrdba'

CRS-2677: Stop of 'ora.MGMTLSNR' on 'svrdba' succeeded

CRS-2673: Attempting to stop 'ora.svrdba.vip' on 'svrdba'

CRS-2677: Stop of 'ora.svrdba.vip' on 'svrdba' succeeded

CRS-2672: Attempting to start 'ora.MGMTLSNR' on 'svrdbb'

CRS-2672: Attempting to start 'ora.qosmserver' on 'svrdbb'

CRS-2672: Attempting to start 'ora.cvu' on 'svrdbb'

CRS-2672: Attempting to start 'ora.svrdba.vip' on 'svrdbb'

CRS-2676: Start of 'ora.cvu' on 'svrdbb' succeeded

CRS-2676: Start of 'ora.svrdba.vip' on 'svrdbb' succeeded

CRS-2676: Start of 'ora.MGMTLSNR' on 'svrdbb' succeeded

CRS-2672: Attempting to start 'ora.scan1.vip' on 'svrdbb'

CRS-2676: Start of 'ora.scan1.vip' on 'svrdbb' succeeded

CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'svrdbb'

CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'svrdbb' succeeded

CRS-2672: Attempting to start 'ora.mgmtdb' on 'svrdbb'

CRS-2676: Start of 'ora.qosmserver' on 'svrdbb' succeeded

CRS-2676: Start of 'ora.mgmtdb' on 'svrdbb' succeeded

CRS-2672: Attempting to start 'ora.chad' on 'svrdbb'

CRS-2676: Start of 'ora.chad' on 'svrdbb' succeeded

CRS-2673: Attempting to stop 'ora.ons' on 'svrdba'

CRS-2677: Stop of 'ora.ons' on 'svrdba' succeeded

CRS-2673: Attempting to stop 'ora.net1.network' on 'svrdba'

CRS-2677: Stop of 'ora.net1.network' on 'svrdba' succeeded

CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'svrdba' has completed

CRS-2677: Stop of 'ora.crsd' on 'svrdba' succeeded

CRS-2673: Attempting to stop 'ora.asm' on 'svrdba'

CRS-2673: Attempting to stop 'ora.crf' on 'svrdba'

CRS-2673: Attempting to stop 'ora.drivers.acfs' on 'svrdba'

CRS-2673: Attempting to stop 'ora.gpnpd' on 'svrdba'

CRS-2673: Attempting to stop 'ora.mdnsd' on 'svrdba'

CRS-2677: Stop of 'ora.drivers.acfs' on 'svrdba' succeeded

CRS-2677: Stop of 'ora.gpnpd' on 'svrdba' succeeded

CRS-2677: Stop of 'ora.crf' on 'svrdba' succeeded

CRS-2677: Stop of 'ora.mdnsd' on 'svrdba' succeeded

CRS-2677: Stop of 'ora.asm' on 'svrdba' succeeded

CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'svrdba'

CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'svrdba' succeeded

CRS-2673: Attempting to stop 'ora.ctssd' on 'svrdba'

CRS-2673: Attempting to stop 'ora.evmd' on 'svrdba'

CRS-2677: Stop of 'ora.ctssd' on 'svrdba' succeeded

CRS-2677: Stop of 'ora.evmd' on 'svrdba' succeeded

CRS-2673: Attempting to stop 'ora.cssd' on 'svrdba'

CRS-2677: Stop of 'ora.cssd' on 'svrdba' succeeded

CRS-2673: Attempting to stop 'ora.gipcd' on 'svrdba'

CRS-2677: Stop of 'ora.gipcd' on 'svrdba' succeeded

CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'svrdba' has completed

CRS-4133: Oracle High Availability Services has been stopped.

[root@svrdba bin]#

[root@svrdba bin]# ./crs_stat -t

CRS-0184: Cannot communicate with the CRS daemon.

[root@svrdba bin]#

Public/Private对应的的主机名不能更改，如果确实需要更改主机名，需要重新安装CRS。

修改 /etc/hosts

[root@svrdba bin]# cat /etc/hosts

127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4

::1 localhost localhost.localdomain localhost6 localhost6.localdomain6

10.203.111.4 svrdba svrdba-1

10.203.111.5 svrdba-2

10.203.111.6 svrdbb svrdbb-1

10.203.111.7 svrdbb-2

10.203.111.104 svrdba-vip

10.203.111.105 svrdbb-vip

10.203.111.111 oracle-scan

192.168.100.100 svrdba-private-1

192.168.101.100 svrdba-private-2

192.168.100.101 svrdbb-private-1

192.168.101.101 svrdbb-private-2

诊断系统状态

[root@svrdba bin]# ./crs_stat -t

Name Type Target State Host

------------------------------------------------------------

ora....SM.lsnr ora....er.type ONLINE ONLINE svrdba

ora.DATA.dg ora....up.type ONLINE ONLINE svrdba

ora....ER.lsnr ora....er.type ONLINE OFFLINE

ora....AF.lsnr ora....er.type OFFLINE OFFLINE

ora....N1.lsnr ora....er.type ONLINE OFFLINE

ora.MGMTLSNR ora....nr.type ONLINE OFFLINE

ora.asm ora.asm.type ONLINE ONLINE svrdba

ora.chad ora.chad.type ONLINE OFFLINE

ora.cvu ora.cvu.type ONLINE OFFLINE

ora.mgmtdb ora....db.type ONLINE OFFLINE

ora....network ora....rk.type ONLINE OFFLINE

ora.ons ora.ons.type ONLINE OFFLINE

ora.orcl.db ora....se.type OFFLINE OFFLINE

ora.proxy_advm ora....vm.type OFFLINE OFFLINE

ora.qosmserver ora....er.type ONLINE OFFLINE

ora.scan1.vip ora....ip.type ONLINE OFFLINE

ora....BA.lsnr application ONLINE OFFLINE

ora.svrdba.ons application ONLINE OFFLINE

ora.svrdba.vip ora....t1.type ONLINE OFFLINE

ora....BB.lsnr application ONLINE OFFLINE

ora.svrdbb.ons application ONLINE OFFLINE

ora.svrdbb.vip ora....t1.type ONLINE OFFLINE

使用oifcfg修改网卡

[root@svrdba bin]# ./oifcfg getif -global

enp0s10 192.168.101.0 global cluster_interconnect

enp0s3 10.203.101.0 global public

enp0s8 10.203.101.0 global public

enp0s9 192.168.100.0 global cluster_interconnect,asm

当前为101网段，希望改为111网段

删除当前配置

./oifcfg delif -global enp0s3

./oifcfg delif -global enp0s8

之后svrdba，svrdbb都应为

[root@svrdba bin]# ./oifcfg getif -global

enp0s10 192.168.101.0 global cluster_interconnect

enp0s9 192.168.100.0 global cluster_interconnect,asm

重新添加

./oifcfg setif -global enp0s3/10.203.111.0:public

./oifcfg setif -global enp0s8/10.203.111.0:public

之后svrdba，svrdbb都应为

[root@svrdbb bin]# ./oifcfg getif -global

enp0s10 192.168.101.0 global cluster_interconnect

enp0s9 192.168.100.0 global cluster_interconnect,asm

enp0s3 10.203.111.0 global public

enp0s8 10.203.111.0 global public

修改VIP

./srvctl modify nodeapps -n svrdba -A 10.203.111.104/255.255.255.0/enp0s3

./srvctl modify nodeapps -n svrdbb -A 10.203.111.105/255.255.255.0/enp0s3

检查

[root@svrdba bin]# ./srvctl status vip -node svrdbb VIP 10.203.111.105 is enabled

VIP 10.203.111.105 is running on node: svrdbb

[root@svrdba bin]# ./srvctl status vip -node svrdba

VIP 10.203.111.104 is enabled

VIP 10.203.111.104 is running on node: svrdba

设置listener.ora和tnsnames.ora,

没有用到固定IP，不用改。

启动数据库

./srvctl start nodeapps -n svrdba

./srvctl start nodeapps -n svrdbb

[root@svrdbb bin]# ./srvctl start nodeapps -n svrdbb

PRKO-2421 : Network resource is already started on node(s): svrdba,svrdbb

PRKO-2420 : VIP 10.203.111.105 is already started on nodes: svrdbb

PRKO-2422 : ONS is already started on node(s): svrdba,svrdbb

[root@svrdba bin]# ./srvctl start asm -n svrdba

PRCC-1015 : asm was already running on svrdba

PRCR-1004 : Resource ora.asm is already running

[root@svrdbb bin]# ./srvctl start asm -n svrdbb

PRCC-1015 : asm was already running on svrdbb

PRCR-1004 : Resource ora.asm is already running

./srvctl start instance -db orcl -node svrdbb

检查

[root@svrdbb bin]# ./crs_stat -t

Name Type Target State Host

------------------------------------------------------------

ora....SM.lsnr ora....er.type ONLINE ONLINE svrdba

ora.DATA.dg ora....up.type ONLINE ONLINE svrdba

ora....ER.lsnr ora....er.type ONLINE ONLINE svrdba

ora....AF.lsnr ora....er.type OFFLINE OFFLINE

ora....N1.lsnr ora....er.type ONLINE ONLINE svrdbb

ora.MGMTLSNR ora....nr.type ONLINE ONLINE svrdba

ora.asm ora.asm.type ONLINE ONLINE svrdba

ora.chad ora.chad.type ONLINE ONLINE svrdba

ora.cvu ora.cvu.type ONLINE ONLINE svrdba

ora.mgmtdb ora....db.type ONLINE ONLINE svrdba

ora....network ora....rk.type ONLINE ONLINE svrdba

ora.ons ora.ons.type ONLINE ONLINE svrdba

ora.orcl.db ora....se.type ONLINE ONLINE svrdba

ora.proxy_advm ora....vm.type OFFLINE OFFLINE

ora.qosmserver ora....er.type ONLINE ONLINE svrdba

ora.scan1.vip ora....ip.type ONLINE ONLINE svrdbb

ora....BA.lsnr application ONLINE ONLINE svrdba

ora.svrdba.ons application ONLINE ONLINE svrdba

ora.svrdba.vip ora....t1.type ONLINE ONLINE svrdba

ora....BB.lsnr application ONLINE ONLINE svrdbb

ora.svrdbb.ons application ONLINE ONLINE svrdbb

ora.svrdbb.vip ora....t1.type ONLINE ONLINE svrdbb

系统SCAN IP

[oracle@svrdba ~]$ srvctl config scan

SCAN name: oracle-scan, Network: 1

Subnet IPv4: 10.203.111.0/255.255.255.0/enp0s3, static

Subnet IPv6:

SCAN 1 IPv4 VIP: 10.203.101.111

SCAN VIP is enabled.

SCAN VIP is individually enabled on nodes:

SCAN VIP is individually disabled on nodes:

srvctl stop scan_listener

root用户：

[root@svrdba bin]# ./srvctl modify scan -n oracle-scan

[root@svrdbb bin]# ./srvctl start scan

[root@svrdbb bin]# ./srvctl start scan_listener