Oracle 19c RAC 替换私网操作
惜分飞发表于 2024-09-06 14:05:45
联系：手机/微信(+86 17813235971) QQ(107644445)
作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]
19c的三节点集群,需要替换一个私网网卡(如果有足够的停机窗口有一个更加简单的方法,直接通过修改网卡名称实现替换,不过需要主机重启一次,参考:Linux 8 修改网卡名称)
1. 先在主机层面确认新配置网络能够相互ping通,在hosts文件加入私网信息,并且确认ssh 可以相互访问
ssh xffdb1-priv3 date;ssh xffdb2-priv3 date;ssh xffdb3-priv3 date;
2. 删除掉需要删除的网络上的asm监听和该network信息
[grid@xffdb1 ~]$ srvctl config listener -asmlistener
Name: ASMNET1LSNR_ASM
Type: ASM Listener
Owner: grid
Subnet: 172.16.16.0
Home: <CRS home>
End points: TCP:1525
Listener is enabled.
Listener is individually enabled on nodes:
Listener is individually disabled on nodes:
Name: ASMNET2LSNR_ASM
Type: ASM Listener
Owner: grid
Subnet: 172.17.17.0
Home: <CRS home>
End points: TCP:1526
Listener is enabled.
Listener is individually enabled on nodes:
Listener is individually disabled on nodes:
[grid@xffdb1 ~]$ srvctl config asmnetwork
ASM network 1 exists
Subnet IPv4: 172.16.16.0//
Subnet IPv6:
Network is enabled
Network is individually enabled on nodes:
Network is individually disabled on nodes:
ASM network 2 exists
Subnet IPv4: 172.17.17.0//
Subnet IPv6:
Network is enabled
Network is individually enabled on nodes:
Network is individually disabled on nodes:
[grid@xffdb1 ~]$
[grid@xffdb3 ~]$ srvctl config asm
ASM home: <CRS home>
Password file: +DATA/orapwASM
Backup of Password file: +DATA/orapwASM_backup
ASM listener: LISTENER
ASM instance count: 3
Cluster ASM listener: ASMNET1LSNR_ASM,ASMNET2LSNR_ASM
[grid@xffdb3 ~]$ crsctl status res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE xffdb1 STABLE
ONLINE ONLINE xffdb2 STABLE
ONLINE ONLINE xffdb3 STABLE
ora.chad
ONLINE ONLINE xffdb1 STABLE
ONLINE ONLINE xffdb2 STABLE
ONLINE ONLINE xffdb3 STABLE
ora.net1.network
ONLINE ONLINE xffdb1 STABLE
ONLINE ONLINE xffdb2 STABLE
ONLINE ONLINE xffdb3 STABLE
ora.ons
ONLINE ONLINE xffdb1 STABLE
ONLINE ONLINE xffdb2 STABLE
ONLINE ONLINE xffdb3 STABLE
ora.proxy_advm
OFFLINE OFFLINE xffdb1 STABLE
OFFLINE OFFLINE xffdb2 STABLE
OFFLINE OFFLINE xffdb3 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE xffdb1 STABLE
2 ONLINE ONLINE xffdb2 STABLE
3 ONLINE ONLINE xffdb3 STABLE
ora.ASMNET2LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE xffdb1 STABLE
2 ONLINE ONLINE xffdb2 STABLE
3 ONLINE ONLINE xffdb3 STABLE
ora.OCR.dg(ora.asmgroup)
1 ONLINE ONLINE xffdb1 STABLE
2 ONLINE ONLINE xffdb2 STABLE
3 ONLINE ONLINE xffdb3 STABLE
ora.DATADG.dg(ora.asmgroup)
1 ONLINE ONLINE xffdb1 STABLE
2 ONLINE ONLINE xffdb2 STABLE
3 ONLINE ONLINE xffdb3 STABLE
ora.FRADG.dg(ora.asmgroup)
1 ONLINE ONLINE xffdb1 STABLE
2 ONLINE ONLINE xffdb2 STABLE
3 ONLINE ONLINE xffdb3 STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE xffdb2 STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE xffdb1 STABLE
2 ONLINE ONLINE xffdb2 STABLE
3 ONLINE ONLINE xffdb3 Started,STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE xffdb1 STABLE
2 ONLINE ONLINE xffdb2 STABLE
3 ONLINE ONLINE xffdb3 STABLE
ora.asmnet2.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE xffdb1 STABLE
2 ONLINE ONLINE xffdb2 STABLE
3 ONLINE ONLINE xffdb3 STABLE
ora.cvu
1 ONLINE ONLINE xffdb2 STABLE
ora.xffdb1.vip
1 ONLINE ONLINE xffdb1 STABLE
ora.xffdb2.vip
1 ONLINE ONLINE xffdb2 STABLE
ora.xffdb3.vip
1 ONLINE ONLINE xffdb3 STABLE
ora.xifenfei.db
1 ONLINE ONLINE xffdb1 Open,HOME=/u01/app/o
racle/product/19c/db
_1,STABLE
2 ONLINE ONLINE xffdb2 Open,HOME=/u01/app/o
racle/product/19c/db
_1,STABLE
3 ONLINE ONLINE xffdb3 Open,HOME=/u01/app/o
racle/product/19c/db
_1,STABLE
ora.qosmserver
1 ONLINE ONLINE xffdb2 STABLE
ora.scan1.vip
1 ONLINE ONLINE xffdb2 STABLE
--------------------------------------------------------------------------------
[grid@xffdb1 peer]$ srvctl update listener -listener ASMNET2LSNR_ASM -asm -remove -force
[grid@xffdb1 peer]$ srvctl remove asmnetwork -netnum 2 -force
PRCR-1028 : Failed to remove resource ora.asmnet2.asmnetwork
PRCR-1072 : Failed to unregister resource ora.asmnet2.asmnetwork
CRS-0245: User doesn't have enough privilege to perform the operation
[root@xffdb1 ~]# source /home/grid/.bash_profile
[root@xffdb1 ~]# srvctl remove asmnetwork -netnum 2 -force
[root@xffdb1 ~]#
[root@xffdb1 ~]#
[root@xffdb1 ~]# crsctl status res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE xffdb1 STABLE
ONLINE ONLINE xffdb2 STABLE
ONLINE ONLINE xffdb3 STABLE
ora.chad
ONLINE ONLINE xffdb1 STABLE
ONLINE ONLINE xffdb2 STABLE
ONLINE ONLINE xffdb3 STABLE
ora.net1.network
ONLINE ONLINE xffdb1 STABLE
ONLINE ONLINE xffdb2 STABLE
ONLINE ONLINE xffdb3 STABLE
ora.ons
ONLINE ONLINE xffdb1 STABLE
ONLINE ONLINE xffdb2 STABLE
ONLINE ONLINE xffdb3 STABLE
ora.proxy_advm
OFFLINE OFFLINE xffdb1 STABLE
OFFLINE OFFLINE xffdb2 STABLE
OFFLINE OFFLINE xffdb3 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE xffdb1 STABLE
2 ONLINE ONLINE xffdb2 STABLE
3 ONLINE ONLINE xffdb3 STABLE
ora.OCR.dg(ora.asmgroup)
1 ONLINE ONLINE xffdb1 STABLE
2 ONLINE ONLINE xffdb2 STABLE
3 ONLINE ONLINE xffdb3 STABLE
ora.DATADG.dg(ora.asmgroup)
1 ONLINE ONLINE xffdb1 STABLE
2 ONLINE ONLINE xffdb2 STABLE
3 ONLINE ONLINE xffdb3 STABLE
ora.FRADG.dg(ora.asmgroup)
1 ONLINE ONLINE xffdb1 STABLE
2 ONLINE ONLINE xffdb2 STABLE
3 ONLINE ONLINE xffdb3 STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE xffdb2 STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE xffdb1 STABLE
2 ONLINE ONLINE xffdb2 STABLE
3 ONLINE ONLINE xffdb3 Started,STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE xffdb1 STABLE
2 ONLINE ONLINE xffdb2 STABLE
3 ONLINE ONLINE xffdb3 STABLE
ora.cvu
1 ONLINE ONLINE xffdb2 STABLE
ora.xffdb1.vip
1 ONLINE ONLINE xffdb1 STABLE
ora.xffdb2.vip
1 ONLINE ONLINE xffdb2 STABLE
ora.xffdb3.vip
1 ONLINE ONLINE xffdb3 STABLE
ora.xifenfei.db
1 ONLINE ONLINE xffdb1 Open,HOME=/u01/app/o
racle/product/19c/db
_1,STABLE
2 ONLINE ONLINE xffdb2 Open,HOME=/u01/app/o
racle/product/19c/db
_1,STABLE
3 ONLINE ONLINE xffdb3 Open,HOME=/u01/app/o
racle/product/19c/db
_1,STABLE
ora.qosmserver
1 ONLINE ONLINE xffdb2 STABLE
ora.scan1.vip
1 ONLINE ONLINE xffdb2 STABLE
--------------------------------------------------------------------------------
[grid@xffdb2 peer]$ srvctl config listener -asmlistener
Name: ASMNET1LSNR_ASM
Type: ASM Listener
Owner: grid
Subnet: 172.16.16.0
Home: <CRS home>
End points: TCP:1525
Listener is enabled.
Listener is individually enabled on nodes:
Listener is individually disabled on nodes:
[grid@xffdb2 peer]$ srvctl config asmnetwork
ASM network 1 exists
Subnet IPv4: 172.16.16.0//
Subnet IPv6:
Network is enabled
Network is individually enabled on nodes:
Network is individually disabled on nodes:
3. 替换集群私网操作
[grid@xffdb1 ~]$ oifcfg getif bond0 192.168.20.0 global public ens9f0 172.16.16.0 global cluster_interconnect,asm ens9f1 172.17.17.0 global cluster_interconnect,asm [grid@xffdb1 ~]$ oifcfg setif -global ens6f0np0/172.18.18.0:cluster_interconnect,asm [grid@xffdb1 ~]$ oifcfg getif bond0 192.168.20.0 global public ens9f0 172.16.16.0 global cluster_interconnect,asm ens9f1 172.17.17.0 global cluster_interconnect,asm ens6f0np0 172.18.18.0 global cluster_interconnect,asm [grid@xffdb1 ~]$ oifcfg delif -global ens9f1/172.17.17.0 [grid@xffdb1 ~]$ oifcfg getif bond0 192.168.20.0 global public ens9f0 172.16.16.0 global cluster_interconnect,asm ens6f0np0 172.18.18.0 global cluster_interconnect,asm [grid@xffdb1 ~]$ oifcfg delif -global ens9f1/172.17.17.0 [grid@xffdb1 ~]$ oifcfg getif bond0 192.168.20.0 global public ens9f0 172.16.16.0 global cluster_interconnect,asm ens6f0np0 172.18.18.0 global cluster_interconnect,asm
4. 依次重启集群三个节点(ASMNET2LSNR_ASM监听需要人工kill),集群网络替换完成(因为asm listener已经有一个,另外一个私网不准备给他们加上asm listener),如果要增加可以进行如下操作
# srvctl add asmnetwork -netnum 2 -subnet 172.18.18.0 % srvctl add listener -asmlistener -l ASMNET1LSNR_ASM -subnet 172.18.18.0