19c ipv4 RAC 通过集群注册ipv6监听

新装好的19.3 ipv4 RAC 升级完19.6后，还需要再添加一个ipv6的监听，原本计划在oracle用户上面创建，但不便于管理，最后还是想了个办法注册到集群中。

由于注册的ipv6是本机物理地址，在集群故障时无法进行漂移，生产业务慎用。

具体操作配置如下

1. ipv6地址配置

ipv6我是配在ipv4网卡上，可以共用，不冲突，改完后重启network生效。

[root@xydb5node1 network-scripts]# more ifcfg-bond0 
BOOTPROTO=static
DEVICE=bond0
NAME=bond0
TYPE=Bond
BONDING_MASTER=yes
ONBOOT=yes
IPADDR=192.168.122.66
PREFIX=24
GATEWAY=192.168.122.254
IPV6INIT=yes
IPV6_FAILURE_FATAL=no
IPV6ADDR=2409:8760:1282:0001:0F11:0000:0000:0042/120
IPV6_DEFAULTGW=2409:8760:1282:0001:0F11:0000:0000:00FF
BONDING_OPTS="miimon=100 mode=1"

2. 修改grid的listener.ora文件

在listener监听中增加ipv6的地址，IP=FIRST 这个优先级配置不能省略，如果2个节点都要配置ipv6，都需要进行修改。

[grid@xydb5node1 admin]$ vi /u01/app/19.3.0/grid/network/admin/listener.ora

#LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))))           #  这一行注释掉
LISTENER=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER))(ADDRESS = (PROTOCOL = TCP)(HOST =2409:8760:1282:1:f11::42)(PORT = 1521)(IP=FIRST)))) #  增加ipv6的地址
LISTENER_SCAN1=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1))))                # line added by Agent
ASMNET1LSNR_ASM=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=ASMNET1LSNR_ASM))))              # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_ASMNET1LSNR_ASM=ON               # line added by Agent
VALID_NODE_CHECKING_REGISTRATION_ASMNET1LSNR_ASM=SUBNET         # line added by Agent
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER_SCAN1=ON                # line added by Agent
VALID_NODE_CHECKING_REGISTRATION_LISTENER_SCAN1=OFF             # line added by Agent - Disabled by Agent because REMOTE_REGISTRATION_ADDRESS is set
ENABLE_GLOBAL_DYNAMIC_ENDPOINT_LISTENER=ON              # line added by Agent
VALID_NODE_CHECKING_REGISTRATION_LISTENER=SUBNET                # line added by Agent
~

3. 重启监听

两个节点都改完后重启监听，记得在root下操作。

#停止
[root@xydb5node1 ~]# srvctl stop listener

#启动
[root@xydb5node1 ~]# srvctl start listener

4. 查看监听状态

重启完后ipv6就监听上了，asm监听启动会慢一点，别着急。

[oracle@xydb5node1 ~]$ Ls

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 11-MAR-2020 23:53:05

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                11-MAR-2020 23:18:09
Uptime                    0 days 0 hr. 34 min. 55 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/19.3.0/grid/network/admin/listener.ora
Listener Log File         /u01/app/grid/diag/tnslsnr/xydb5node1/listener/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=2409:8760:1282:1:f11::42)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.122.66)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.122.68)(PORT=1521)))
Services Summary...
Service "+ASM" has 1 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_CRSDG" has 1 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_DATADG1" has 1 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "+ASM_FRADG" has 1 instance(s).
  Instance "+ASM1", status READY, has 1 handler(s) for this service...
Service "db5node" has 1 instance(s).
  Instance "db5node1", status READY, has 1 handler(s) for this service...
Service "db5nodeXDB" has 1 instance(s).
  Instance "db5node1", status READY, has 1 handler(s) for this service...
The command completed successfully

• 总结

今年都在推ipv6整改，相对ipv4，个人学习理解起来都感觉比较费劲，计划抽时间再整理一下ipv6的知识点。