oracle 19c rac 修改私网、公网网络IP

已于 2023-03-06 08:33:58 修改
阅读量1.5k 收藏 3
点赞数 1
分类专栏： oracle 文章标签： 数据库 Powered by 金山文档
于 2023-03-05 16:55:39 首次发布
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/hot_815/article/details/129347871
版权

oracle 19c RAC 修改私网/公网/虚拟IP/scanip 的网段和ip

版本：oracle 19C

IP规划

解析名

类型

Old IP

New ip

Old ifname

New ifname

node1

Public

192.168.100.10

192.168.200.10

bond0

bond0

node2

Public

192.168.100.20

192.168.200.20

bond0

bond0

node1-vip

VIP

192.168.100.11

192.168.200.11

bond0

bond0

node2-vip

VIP

192.168.100.21

192.168.200.21

bond0

bond0

node1-priv

Private

192.168.10.10

192.168.20.10

bond1

bond1

node2-priv

Private

192.168.10.20

192.168.20.20

bond1

bond1

racdb-scan

Scan

192.168.100.30

192.168.200.30

bond0

bond0

  1. 修改私网IP

19C 集群私网涉及到集群间通信和ASM网络。主要涉及集群资源。

操作主要在grid用户下，集群中一台主机上执行。

1. 当前环境状态检查

（1）当前集群状态检查,确保集群中所有节点都已正常启动

[grid@node1 ~]$ crsctl status res -t

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

Name Target State Server State details

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

Local Resources

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

ora.LISTENER.lsnr

ONLINE ONLINE node1 STABLE

ONLINE OFFLINE node2 STABLE

ora.chad

ONLINE ONLINE node1 STABLE

ONLINE ONLINE node2 STABLE

ora.net1.network

ONLINE ONLINE node1 STABLE

ONLINE OFFLINE node2 STABLE

ora.ons

ONLINE ONLINE node1 STABLE

ONLINE OFFLINE node2 STABLE

ora.proxy_advm

OFFLINE OFFLINE node1 STABLE

OFFLINE OFFLINE node2 STABLE

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

Cluster Resources

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

ora.ARCH.dg(ora.asmgroup)

1 ONLINE ONLINE node1 STABLE

2 ONLINE ONLINE node2 STABLE

ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)

1 ONLINE ONLINE node1 STABLE

2 ONLINE ONLINE node2 STABLE

ora.DATA.dg(ora.asmgroup)

1 ONLINE ONLINE node1 STABLE

2 ONLINE ONLINE node2 STABLE

ora.LISTENER_SCAN1.lsnr

1 ONLINE ONLINE node1 STABLE

ora.OCR.dg(ora.asmgroup)

1 ONLINE ONLINE node1 STABLE

2 ONLINE ONLINE node2 STABLE

ora.asm(ora.asmgroup)

1 ONLINE ONLINE node1 Started,STABLE

2 ONLINE ONLINE node2 Started,STABLE

ora.asmnet1.asmnetwork(ora.asmgroup)

1 ONLINE ONLINE node1 STABLE

2 ONLINE ONLINE node2 STABLE

ora.cvu

1 ONLINE ONLINE node1 STABLE

ora.racdb.db

1 OFFLINE OFFLINE Instance Shutdown,ST

ABLE

2 OFFLINE OFFLINE Instance Shutdown,ST

ABLE

ora.node1.vip

1 ONLINE ONLINE node1 STABLE

ora.node2.vip

1 ONLINE INTERMEDIATE node1 FAILED OVER,STABLE

ora.qosmserver

1 ONLINE ONLINE node1 STABLE

ora.scan1.vip

1 ONLINE ONLINE node1 STABLE

  1. 查看asm是否启用flex

[grid@node1 ~]$ asmcmd

ASMCMD> showclustermode

ASM cluster : Flex mode enabled - Direct Storage Access

ASMCMD> showclusterstate

Normal

  1. 备份GPNP配置文件

私网信息不加存在OCR中还存放到GPNP的profile.xml配置文件中，可以预先进行备份

cd $ORACLE_HOME/gpnp/node1/profiles/peer

[grid@node1 peer]$ cp profile.xml profile.xml230207

  1. 查看当前配置的网络

[grid@node1 peer]$ oifcfg getif

bond0 192.168.200.0 global public

bond1 192.168.20.0 global cluster_interconnect,asm

  1. 新添加一个集群私网信息

[grid@node1 peer]$oifcfg setif -global bond1/192.168.200.0:cluster_interconnect,asm

[grid@node1 peer]$ oifcfg getif

bond0 192.168.200.0 global public

bond1 192.168.20.0 global cluster_interconnect,asm

bond1 192.168.10.0 global cluster_interconnect,asm

  1. 修改ASMLISTENER

asmlistener被用作私有网络，如果对其修改则会影响 ASMLISTENER。需要添加一个新的 ASMLISTENER 及新的网络配置。如果 ASM 的子网网络没有改变则跳过这一步

（1）查看当前ASMLISTENER配置

[grid@node1 peer]$ srvctl config asm

ASM home: <CRS home>

Password file: +OCR/orapwASM

Backup of Password file: +OCR/orapwASM_backup

ASM listener: LISTENER

ASM instance count: 2

Cluster ASM listener: ASMNET1LSNR_ASM

[grid@node1 peer]$ srvctl config listener -asmlistener

Name: ASMNET1LSNR_ASM

Type: ASM Listener

Owner: grid

Subnet: 192.168.10.0

Home: <CRS home>

End points: TCP:1525

Listener is enabled.

Listener is individually enabled on nodes:

Listener is individually disabled on nodes:

（2）添加一个新的ASM监听

srvctl add listener -asmlistener -l ASMNET2LSNR_ASM -subnet 192.168.20.0

（3）添加新ASM监听后配置

[grid@node1 peer]$ srvctl config listener -asmlistener

Name: ASMNET1LSNR_ASM

Type: ASM Listener

Owner: grid

Subnet: 192.168.10.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: 192.168.20.0

Home: <CRS home>

End points: TCP:1526

Listener is enabled.

Listener is individually enabled on nodes:

Listener is individually disabled on nodes:

（4）删除原来的asm监听

srvctl update listener -listener ASMNET1LSNR_ASM -asm -remove -force

（5）查看修改后配置

[grid@node1 peer]$ srvctl config listener -asmlistener

Name: ASMNET2LSNR_ASM

Type: ASM Listener

Owner: grid

Subnet: 192.168.20.0

Home: <CRS home>

End points: TCP:1526

Listener is enabled.

Listener is individually enabled on nodes:

Listener is individually disabled on nodes:

[grid@node1 peer]$ srvctl config asm

ASM home: <CRS home>

Password file: +OCR/orapwASM

Backup of Password file: +OCR/orapwASM_backup

ASM listener: LISTENER

ASM instance count: 2

Cluster ASM listener: ASMNET2LSNR_ASM

  1. 两个节点关闭和禁用crs

节点一：

[root@node1 ~]# cd /app/19.0.0/grid/bin/

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

[root@node1 bin]# ./crsctl disable crs

CRS-4621: Oracle High Availability Services autostart is disabled.

节点二：

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

[root@node2 bin]# ./crsctl disable crs

CRS-4621: Oracle High Availability Services autostart is disabled.

  1. 所有节点操作系统层修改私网IP,/etc/hosts

节点一：

[root@node1 network-scripts]# vi ifcfg-bond1

BONDING_OPTS=mode=active-backup

TYPE=Bond

BONDING_MASTER=yes

PROXY_METHOD=none

BROWSER_ONLY=no

BOOTPROTO=static

IPADDR=192.168.20.10 --->192.168.10.10 改成192.168.20.10

NETMASK=255.255.255.0

DEFROUTE=yes

IPV4_FAILURE_FATAL=no

NAME=bond1

DEVICE=bond1

ONBOOT=yes

nucli c reload

nucli d reapply bond1

vi /etc/hosts

#public ip

192.168.100.10 node1

192.168.100.20 node2

#vip

192.168.100.11 node1-vip

192.168.100.21 node2-vip

#private ip

192.168.20.10 node1-priv

192.168.20.20 node2-priv

#scan ip

192.168.100.30 racdb-scan

节点二操作同节点一，注意IP。

  1. 两个节点激活、启动crs

节点一：

[root@node1 ~]# cd /app/19.0.0/grid/bin/

[root@node1 bin]# ./crsctl enable crs

CRS-4621: Oracle High Availability Services autostart is enabled.

[root@node1 bin]# ./crsctl start crs

节点二：

[root@node2 bin]# ./crsctl disable crs

CRS-4621: Oracle High Availability Services autostart is disabled.

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

  1. 删除旧网络接口信息

[grid@node1 ~]$ oifcfg getif

bond0 192.168.100.0 global public

bond1 192.168.20.0 global cluster_interconnect,asm

bond1 192.168.10.0 global cluster_interconnect,asm

[grid@node1 ~]$ oifcfg delif -global bond1/192.168.10.0

[grid@node1 ~]$ oifcfg getif

bond0 192.168.200.0 global public

bond1 192.168.200.0 global cluster_interconnect,asm

  1. 更新 ora.asmnet1.asmnetwork 资源

Root用户执行

#移除原资源

[root@node1 bin]# ./srvctl remove asmnetwork -netnum 1 -force

#增加新资源

[root@node1 bin]# ./srvctl add asmnetwork -netnum 1 -subnet 192.168.20.0

#启动新资源

[root@node1 bin]#./srvctl start asmnetwork -netnum 1

  1. 查看当前集群状态

[root@node1 bin]# ./crsctl status res -t

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

Name Target State Server State details

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

Local Resources

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

ora.LISTENER.lsnr

ONLINE ONLINE node1 STABLE

ONLINE OFFLINE node2 STABLE

ora.chad

ONLINE ONLINE node1 STABLE

ONLINE ONLINE node2 STABLE

ora.net1.network

ONLINE ONLINE node1 STABLE

ONLINE OFFLINE node2 STABLE

ora.ons

ONLINE ONLINE node1 STABLE

ONLINE OFFLINE node2 STABLE

ora.proxy_advm

OFFLINE OFFLINE node1 STABLE

OFFLINE OFFLINE node2 STABLE

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

Cluster Resources

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

ora.ARCH.dg(ora.asmgroup)

1 ONLINE ONLINE node1 STABLE

2 ONLINE ONLINE node2 STABLE

ora.ASMNET2LSNR_ASM.lsnr(ora.asmgroup)

1 ONLINE ONLINE node1 STABLE

2 ONLINE ONLINE node2 STABLE

ora.DATA.dg(ora.asmgroup)

1 ONLINE ONLINE node1 STABLE

2 ONLINE ONLINE node2 STABLE

ora.LISTENER_SCAN1.lsnr

1 ONLINE ONLINE node1 STABLE

ora.OCR.dg(ora.asmgroup)

1 ONLINE ONLINE node1 STABLE

2 ONLINE ONLINE node2 STABLE

ora.asm(ora.asmgroup)

1 ONLINE ONLINE node1 Started,STABLE

2 ONLINE ONLINE node2 Started,STABLE

ora.asmnet1.asmnetwork(ora.asmgroup)

1 ONLINE ONLINE STABLE

2 ONLINE ONLINE STABLE

ora.cvu

1 ONLINE ONLINE node1 STABLE

ora.racdb.db

1 OFFLINE OFFLINE Instance Shutdown,ST

ABLE

2 OFFLINE OFFLINE Instance Shutdown,ST

ABLE

ora.node1.vip

1 ONLINE ONLINE node1 STABLE

ora.node2.vip

1 ONLINE INTERMEDIATE node1 FAILED OVER,STABLE

ora.qosmserver

1 ONLINE ONLINE node1 STABLE

ora.scan1.vip

1 ONLINE ONLINE node1 STABLE

  1. 两个节点重启服务器，测试集群是否能正常启动

  1. 修改公网IP、VIP、SCAN IP

  1. 查看当前集群状态

[grid@node1 ~]$ crsctl status res -t

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

Name Target State Server State details

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

Local Resources

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

ora.LISTENER.lsnr

ONLINE ONLINE node1 STABLE

ONLINE OFFLINE node2 STABLE

ora.chad

ONLINE ONLINE node1 STABLE

ONLINE ONLINE node2 STABLE

ora.net1.network

ONLINE ONLINE node1 STABLE

ONLINE OFFLINE node2 STABLE

ora.ons

ONLINE ONLINE node1 STABLE

ONLINE OFFLINE node2 STABLE

ora.proxy_advm

OFFLINE OFFLINE node1 STABLE

OFFLINE OFFLINE node2 STABLE

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

Cluster Resources

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

ora.ARCH.dg(ora.asmgroup)

1 ONLINE ONLINE node1 STABLE

2 ONLINE ONLINE node2 STABLE

ora.ASMNET2LSNR_ASM.lsnr(ora.asmgroup)

1 ONLINE ONLINE node1 STABLE

2 ONLINE ONLINE node2 STABLE

ora.DATA.dg(ora.asmgroup)

1 ONLINE ONLINE node1 STABLE

2 ONLINE ONLINE node2 STABLE

ora.LISTENER_SCAN1.lsnr

1 ONLINE ONLINE node1 shuSTABLE

ora.OCR.dg(ora.asmgroup)

1 ONLINE ONLINE node1 STABLE

2 ONLINE ONLINE node2 STABLE

ora.asm(ora.asmgroup)

1 ONLINE ONLINE node1 Started,STABLE

2 ONLINE ONLINE node2 Started,STABLE

ora.asmnet1.asmnetwork(ora.asmgroup)

1 ONLINE ONLINE node1 STABLE

2 ONLINE ONLINE node2 STABLE

ora.cvu

1 ONLINE ONLINE node1 STABLE

ora.racdb.db

1 OFFLINE OFFLINE Instance Shutdown,ST

ABLE

2 OFFLINE OFFLINE Instance Shutdown,ST

ABLE

ora.node1.vip

1 ONLINE ONLINE node1 STABLE

ora.node2.vip

1 ONLINE INTERMEDIATE node1 FAILED OVER,STABLE

ora.qosmserver

1 ONLINE ONLINE node1 STABLE

ora.scan1.vip

1 ONLINE ONLINE node1 STABLE

  1. 停用监听

#用grid用户在其中一个节点执行

[grid@node1 ~]$srvctl stop listener

[grid@node1 ~]$srvctl disable listener

  1. 停止数据库

#用oracle用户在其中一个节点执行

[oracle@node1 ~]$srvctl stop database -d racdb -o immediate

[oracle@node1 ~]$srvctl disable database -d racdb

  1. 停止VIP服务

#使用root用户在其中一个节点执行禁止VIP

cd /app/19.0.0/grid/bin/

[root@node1 bin]#./srvctl disable vip -i node1-vip

[root@node1 bin]#./srvctl disable vip -i node2-vip

#用grid用户在其中一个节点停止VIP

[grid@node1 ~]$ srvctl stop vip -n node1

[grid@node1 ~]$ srvctl stop vip -n node2

  1. 停止scan和scan_listener

#用grid用户在其中一个节点停止禁用scan_listener

[grid@node1 ~]$ srvctl stop scan_listener

[grid@node1 ~]$ srvctl disable scan_listener

#用root用户在其中一个节点停止禁用scan

cd /app/19.0.0/grid/bin/

[root@node1 bin]#./srvctl stop scan

[root@node1 bin]#./srvctl disable scan

  1. 停止crs

#用root用户在两个节点分别停止crs

cd /app/19.0.0/grid/bin/

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

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

  1. 修改/etc/hosts和网卡IP

#两个节点分别执行修改

vi /etc/hosts

#public ip

192.168.200.10 node1 --> 192.168.100.10改成192.168.200.20

192.168.200.20 node2

#vip

192.168.200.11 node1-vip

192.168.200.21 node2-vip

#private ip

192.168.20.10 node1-priv

192.168.20.20 node2-priv

#scan ip

192.168.200.30 racdb-scan

修改网卡IP此处略，参看修改网卡私网IP

  1. 启动集群

#用root用户在两个节点分别启动crs

cd /app/19.0.0/grid/bin/

[root@node1 bin]#./crsctl start crs

[root@node2 bin]#./crsctl start crs

  1. 修改公网IP信息

#删除原公网信息

[grid@node1 ~]$ oifcfg delif -global bond0/192.168.100.0

[grid@node1 ~]$ oifcfg getif

bond1 192.168.20.0 global cluster_interconnect,asm

#增加新公网信息

[grid@node1 ~]$ oifcfg setif -global bond0/192.168.200.0:public

[grid@node1 ~]$ oifcfg getif

bond1 192.168.20.0 global cluster_interconnect,asm

bond0 192.168.200.0 global public

  1. 修改VIP 信息

#查看原vip 信息

[grid@node1 ~]$ srvctl config nodeapps -a

Network 1 exists

Subnet IPv4: 192.168.100.0/255.255.255.0/bond0, static

Subnet IPv6:

Ping Targets:

Network is enabled

Network is individually enabled on nodes:

Network is individually disabled on nodes:

VIP exists: network number 1, hosting node node1

VIP Name: node1-vip

VIP IPv4 Address: 192.168.100.11

VIP IPv6 Address:

VIP is enabled.

VIP is individually enabled on nodes:

VIP is individually disabled on nodes:

VIP exists: network number 1, hosting node node2

VIP Name: node2-vip

VIP IPv4 Address: 192.168.100.21

VIP IPv6 Address:

VIP is enabled.

VIP is individually enabled on nodes:

VIP is individually disabled on nodes:

#用root用户在其中一个节点执行修改vip信息

cd /app/19.0.0/grid/bin/

[root@node1 bin]# ./srvctl modify nodeapps -n node1 -A 192.168.200.11/255.255.255.0/bond0

[root@node1 bin]# ./srvctl modify nodeapps -n node2 -A 192.168.200.21/255.255.255.0/bond0

#验证更改后的配置

[root@node1 bin]# ./srvctl config nodeapps -a

网络1存在

子网 IPv4: 192.168.200.0/255.255.255.0/bond0, static

子网 IPv6:

试通目标:

网络已启用

网络已在以下节点上分别启用:

网络已在以下节点上分别禁用:

VIP 存在: 网络编号 1, 托管节点 node1

VIP 名称: node1-vip

VIP IPv4 地址: 192.168.200.11

VIP IPv6 地址:

VIP 已启用。

VIP 已在以下节点上分别启用:

VIP 已在以下节点上分别禁用:

VIP 存在: 网络编号 1, 托管节点 node2

VIP 名称: node2-vip

VIP IPv4 地址: 192.168.200.21

VIP IPv6 地址:

VIP 已启用。

VIP 已在以下节点上分别启用:

VIP 已在以下节点上分别禁用:

  1. 修改集群scanip

#使用root用户在其中一个节点操作修改scanip

#查看原来状态

[grid@node1 ~]$ srvctl config scan

SCAN name: racdb-scan, Network: 1

Subnet IPv4: 192.168.100.0/255.255.255.0/bond0, static

Subnet IPv6:

SCAN 1 IPv4 VIP: 192.168.100.30

SCAN VIP is enabled.

#修改scanip

cd /app/19.0.0/grid/bin/

[root@node1 bin]# ./srvctl modify scan -n 192.168.200.30

  1. 启动集群监听、vip、scan和数据库

#用root用户在其中一个节点执行

[root@node1 ~]# cd /app/19.0.0/grid/bin/

[root@node1 bin]# ./srvctl enable listener

[root@node1 bin]# ./srvctl enable vip -i node1-vip

[root@node1 bin]# ./srvctl enable vip -i node2-vip

[root@node1 bin]# ./srvctl enable scan_listener

[root@node1 bin]# ./srvctl enable scan

[root@node1 bin]# ./srvctl enable database -d racdb

[root@node1 bin]# ./srvctl start listener

[root@node1 bin]# ./srvctl start vip -n node1

[root@node1 bin]# ./srvctl start vip -n node2

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

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

[root@node1 bin]# ./srvctl start database -d racdb

  1. 查看监听状态

[grid@node1 ~]$ lsnrctl status

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 07-FEB-2023 15:20:48

Copyright (c) 1991, 2021, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=node1-vip)(PORT=1551)))

STATUS of the LISTENER

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

Alias LISTENER

Version TNSLSNR for Linux: Version 19.0.0.0.0 - Production

Start Date 07-FEB-2023 15:19:14

Uptime 0 days 0 hr. 1 min. 33 sec

Trace Level off

Security ON: Local OS Authentication

SNMP OFF

Listener Parameter File /app/19.0.0/grid/network/admin/listener.ora

Listener Log File /app/grid/diag/tnslsnr/node1/listener/alert/log.xml

Listening Endpoints Summary...

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.200.10)(PORT=1551)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.200.11)(PORT=1551)))

Services Summary...

Service "racdb" has 1 instance(s).

Instance "hnkdb1", status UNKNOWN, has 1 handler(s) for this service...

The command completed successfully

  1. 修改ASM 和 database的VIP

修改listener.ora, tnsnames.ora和LOCAL_LISTENER/REMOTE_LISTENER 参数反应 VIP 的改变

#grid asm修改

Sqlplus / as sysasm

alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.200.11)((PORT=1551))' scope=both sid=’+ASM1';

alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.200.21)((PORT=1551))' scope=both sid=’+ASM2';

#ORACLE db修改

Sqlplus / as sysdba

alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.200.11)((PORT=1551))' scope=both sid='hnkdb1';

alter system set local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.200.21)((PORT=1551))' scope=both sid='hnkdb2';

Listener.ora 和tnsname.ora 修改，此处略

  1. 查看集群状态

[grid@node1 ~]$ crsctl status res -t

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

Name Target State Server State details

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

Local Resources

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

ora.LISTENER.lsnr

ONLINE ONLINE node1 STABLE

ONLINE OFFLINE node2 STABLE

ora.chad

ONLINE ONLINE node1 STABLE

ONLINE ONLINE node2 STABLE

ora.net1.network

ONLINE ONLINE node1 STABLE

ONLINE OFFLINE node2 STABLE

ora.ons

ONLINE ONLINE node1 STABLE

ONLINE OFFLINE node2 STABLE

ora.proxy_advm

OFFLINE OFFLINE node1 STABLE

OFFLINE OFFLINE node2 STABLE

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

Cluster Resources

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

ora.ARCH.dg(ora.asmgroup)

1 ONLINE ONLINE node1 STABLE

2 ONLINE ONLINE node2 STABLE

ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)

1 ONLINE ONLINE node1 STABLE

2 ONLINE ONLINE node2 STABLE

ora.DATA.dg(ora.asmgroup)

1 ONLINE ONLINE node1 STABLE

2 ONLINE ONLINE node2 STABLE

ora.LISTENER_SCAN1.lsnr

1 ONLINE ONLINE node1 shuSTABLE

ora.OCR.dg(ora.asmgroup)

1 ONLINE ONLINE node1 STABLE

2 ONLINE ONLINE node2 STABLE

ora.asm(ora.asmgroup)

1 ONLINE ONLINE node1 Started,STABLE

2 ONLINE ONLINE node2 Started,STABLE

ora.asmnet1.asmnetwork(ora.asmgroup)

1 ONLINE ONLINE node1 STABLE

2 ONLINE ONLINE node2 STABLE

ora.cvu

1 ONLINE ONLINE node1 STABLE

ora.racdb.db

1 OFFLINE OFFLINE Instance Shutdown,ST

ABLE

2 OFFLINE OFFLINE Instance Shutdown,ST

ABLE

ora.node1.vip

1 ONLINE ONLINE node1 STABLE

ora.node2.vip

1 ONLINE INTERMEDIATE node1 FAILED OVER,STABLE

ora.qosmserver

1 ONLINE ONLINE node1 STABLE

ora.scan1.vip

1 ONLINE ONLINE node1 STABLE

  1. 两个节点重启验证

热海鲜橙
关注
  • 1
    点赞
  • 踩
  • 3
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 1
    评论
专栏目录
ORACLE RAC CLUSTER更改心跳网卡的子网掩码
xielong8866的博客
11-03 963
ORACLE RAC CLUSTER更改心跳网卡的子网掩码
RHEL 8.4 安装Oracle 19c RAC+RU 19.13 文档.docx
11-25
文档主要记录Red Hat Enterprise Linux Server release 8.4上安装19c RAC + RU 19.13 步骤
Oracle 11g RAC 修改服务器各类ip地址【转载】
qq_32838955的博客
04-25 2249
此文转载自“架构君” ，地址：https://javajgs.com/archives/72358 此文说明较为详细，所以留作参考，详细内容如下。 Oracle 11g RAC 修改各类IP地址 首先，我们都知道Oracle 11g RAC中的IP主要有：Public IP、VIP、SCAN VIP、Private IP这几种。 一般这类改IP地址或者网卡名称的需求主要场景有： 机房搬迁网络变更、系统上线由测试IP更改为生产IP、系统层面双网卡绑定或者解绑等。 我这里实验环境的需求是： 之前在Virtual
Oracle中TAF与SCANIP全面解析
最新发布
专注于数据库技术分享，包含但不限于Oracle，MySQL，PostgreSQL，ElasticSearch及国产数据库等
06-01 618
SCAN IP是Oracle RAC（Real Application Clusters）环境中的一个核心组件，它提供了一个单一的逻辑接入点，允许客户端通过一个域名来连接到Oracle RAC集群，而不是直接连接到各个节点的VIP（Virtual IP）。TAF是Oracle数据库提供的一个高级特性，旨在实现应用程序在数据库连接中断时的透明重连。它允许应用程序在数据库故障发生时，无需修改代码或手动干预，就能自动连接到新的数据库实例，保证了事务的连续性和应用的高可用性。
RAC修改IP地址
u014650965的博客
11-30 448
修改IP地址，重新配置hosts、tnsnames，重新配置VIP。用root用户刷新scan vip。
rac ip地址的修改
wll的专栏
01-13 935
阿斯蒂芬啊 阿斯蒂芬 阿斯顿发放  1、停止数据库   停止两边节点数据库，监听,并且停止crs grid用户 srvctl stop database -d gdcdc -o immediate srvctl stop listener -n rac1 srvctl stop listener -n rac2 root用户 cd /grid/app/
Oracle RAC修改IP和VIP地址
cuge240620的博客
02-03 386
背景：RAC测试环境停掉一段时间后重启发现IP和其它环境IP冲突，所以决定修改RAC测试环境的IP地址 操作系统版本： redhat 5.2 oracle版本: ORACLE 10.2.0.4 +ASM ...
Oracle19c RAC+ RACDG配置详细部署文档
07-13
1，Oracle19c RAC+ RACDG配置详细部署文档 2，Oracle19c RAC+ RACDG+racdg2配置详细部署文档 涉及主库备库参数配置、spfile、crs资源配置更新及实施过程中故障排除等； 来自于现实上亿级生产系统的实操记录。
Redhat7.6 Oracle 19C RAC部署手册
03-29
Redhat7.6 Oracle 19C RAC部署手册
阿里云ECS环境下CentOS-linux 7.6系统Oracle 19C RAC双节点集群安装部署-优化-维护手册.pdf
12-17
阿里云ECS环境下的Oracle 19C RAC双节点集群安装部署是一个复杂的过程，涉及到多个环节和系统配置。在CentOS 7.6操作系统上搭建这样的环境，首先要确保满足Oracle 19C的软硬件需求。官方推荐的操作系统版本为Linux ...
在线修改oracle RAC集群scanIP地址.docx
09-23
在线修改oracle RAC集群scanIP地址，修改scan ip无需停止数据库实例，asm或crs
19c rac环境修改pubic， vip，scan ip步骤
kevinyu998的博客
05-16 796
19c rac环境第一次修改public、vip和scan ip，和11g还是稍有不同。一、编辑/etc/sysconfig/network-scripts/ifcfg-bond0,3.通过操作系统命令修改public、vip和scan ip地址----两个主机上都操作。二、修改/etc/hosts文件将public IP地址,VIP地址,SCAN地址。1、修改public地址，关闭实例后使用root用户操作。6、. 修改 SCAN IP--在节点一上操作。4.启动has----两个主机上操作。
ORACLE 11GR2 RAC的网络规划解析
塔山上的山
12-28 2189
在ORACLE 11gR2中，安装RAC发生了显著变化。在10g以及11gR1的时代，安装RAC的步骤是先安装CRS，再安装DB，而到了11gR2的时代，crs与asm被集成在一起，合称为GRID，必须先安装GRID后，才能继续安装DB，否则，你就跟11gR2的RAC无缘了，呵呵。下面我们说一下ORACLE 11g R2  RAC的网络规划，从ORACLE 11.2开始，对网络IP地址有特殊要求，
GRID下sqlnet.ora 设置错误导致ASM访问不了
jnrjian的博客
09-21 812
--sqlnet.ora 错了启动不了，启动后打开也没有用。--------------正常情况。
把 Oracle 数据库从 Windows 系统迁移到 Linux Oracle Rac 集群环境（4）—— 修改 oracle11g rac 集群的 scanIP
睿思达DBA
06-22 900
修改 oracle rac 集群的scanIP
Oracle 11G r2 Rac修改IP
数据库
04-08 196
昨日一例 现在的公司是做容灾备份的，现阶段主要攻克11G RAC ASM 所以需要大量的搭建RAC环境。我这个人比较懒，就把测试机装成了esxi，又装了Vcenter（为了使用克隆功能） 然后搭建了一套11G 2.0.3 for RHEL5.6的RAC。 在这套rac的基础上，通过克隆两个机器，克隆后修改相应盘符，成功的进行了rac克隆 在克隆完成以后，需要修改IP，使之变成两个RAC(...
为 Oracle Rac 添加多个 SCAN IP
sqlora的专栏
12-01 696
为 Oracle Rac 添加多个 SCAN IP
Oracle RAC集群IP地址修改
dbhang的博客
07-25 2747
修改集群IP地址：（跨网段修改） 修改前规划： 当前IP地址配置： IP地址 映射名 网卡名 备注 192.168.199.203 rac1 eth0 一节点公网IP 192.168.199.204 rac2 eth0 二节点 公网IP 192.168.199.201 rac1-vip / 一节点 VIP 192.168.199.202 rac2-vip / 二节点 VIP 172.16.1.10 rac1-priv eth1 一节点 私网IP 172.16.1.20
oracle 19c-rac-OEL7.9
05-25
Oracle 19c RAC (Real Application Clustering) 在 Oracle Linux Enterprise 7.9 (OEL7.9) 环境下的安装和配置涉及到一系列关键步骤，主要关注于集群的高可用性和网络配置。以下将详细介绍在这个环境中实施Oracle ...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

热海鲜橙

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值