Oracle 19C RAC IPv6改造（IPv4+IPv6双栈配置）

一、环境介绍

承接上一篇基于NFS共享存储搭建Oracle 19C RAC，现在做的都是在上一篇的基础上做的
网络信息如下

二、配置网卡

        1、配置节点1（testrac1）的网卡

        配置ifcfg-ens3

        配置ifcfg-ens4

BOOTPROTO=none
DEVICE=ens4
DHCPV6C=yes
IPV6INIT=yes
MTU=1500
ONBOOT=yes
STARTMODE=auto
TYPE=Ethernet
USERCTL=no
IPADDR=10.0.102.95
NETMASK=255.255.255.0
GATEWAY=10.0.102.2
#-----IPv6------
IPV6_AUTOCONF=no
IPV6INIT=yes
IPV6_DEFROUTE=yes
IPV6_FAILURE_FATAL=no
IPV6ADDR=2409:807e:58cc:114::a45
IPV6_DEFAULTGW=2409:807e:58cc:114::a01
DHCPV6C=none

        2、配置节点2（testrac2）的网卡

        将网络信息中的ipv6配置到系统网卡配置文件中去

        具体需要配置的参数如下：

        配置ifcfg-ens3

BOOTPROTO=none
DEVICE=ens3
DHCPV6C=yes
IPV6INIT=yes
MTU=1500
ONBOOT=yes
STARTMODE=auto
TYPE=Ethernet
USERCTL=no
IPADDR=192.168.1.161
NETMASK=255.255.255.0
GATEWAY=192.168.1.2
#-----IPv6------
IPV6_AUTOCONF=no
IPV6INIT=yes
IPV6_DEFROUTE=yes
IPV6_FAILURE_FATAL=no
IPV6ADDR=2409:807e:5804:114::274
IPV6_DEFAULTGW=2409:807e:5804:114::201
DHCPV6C=none

        配置ifcfg-ens4

BOOTPROTO=none
DEVICE=ens4
DHCPV6C=yes
IPV6INIT=yes
MTU=1500
ONBOOT=yes
STARTMODE=auto
TYPE=Ethernet
USERCTL=no
IPADDR=10.0.102.96
NETMASK=255.255.255.0
GATEWAY=10.0.102.2
#-----IPv6------
IPV6_AUTOCONF=no
IPV6INIT=yes
IPV6_DEFROUTE=yes
IPV6_FAILURE_FATAL=no
IPV6ADDR=2409:807e:58cc:114::a5b
IPV6_DEFAULTGW=2409:807e:58cc:114::a01
DHCPV6C=none

三、修改hosts文化

        把规划的testrac-vip（ipv6）及testrac-scan(ipv6)配置到hosts文件。

        配置/etc/hosts文件

        

#RAC-PUBLIC-IP-ipv4
192.168.1.160 testrac1
192.168.1.161 testrac2
#RAC-PUBLIC-IP-ipv6
2409:807e:5804:114::268 testrac1_v6
2409:807e:58cc:114::a45 testrac2_v6

#RAC-PRIVATE-IP-ipv4
10.0.102.95 testrac1-priv
10.0.102.96 testrac2-priv

#RAC-VIP-ipv4
192.168.1.65 testrac1-vip
192.168.1.66 testrac2-vip
#RAC-VIP-ipv6
2409:807e:5804:114::24c testrac1-vip_v6
2409:807e:5804:114::24d testrac2-vip_v6

#RAC-SCAN-IP-ipv4
192.168.1.67 testrac-scan
#RAC-SCAN-IP-ipv6
2409:807e:5804:114::243 testrac-scan_v6

四、修改sysctl.conf文件

        ####  ipv6  ####
        net.ipv6.conf.all.disable_ipv6 = 1
        net.ipv6.conf.default.disable_ipv6 = 1

        每个数据库节点上都将以上配置追加到/etc/sysctl.conf，然后执行“sysctl -p”让配置生效

五、查看集群配置

        其实下面这些是可以在一个节点上查看的，因为我这边的窗口是左右分布，所以就两个窗口执行了。后面关闭服务时会换成一个节点执行。

        1、srvctl config network

        /u01/app/19c/grid/bin/srvctl config network

       2、srvctl config scan

/u01/app/19c/grid/bin/srvctl config scan

        3、srvctl config scan_listener

/u01/app/19c/grid/bin/srvctl config scan_listener

        4、srvctl config vip -n 

/u01/app/19c/grid/bin/srvctl config vip -n testrac1
/u01/app/19c/grid/bin/srvctl config vip -n testrac2

        5、srvctl config listener

/u01/app/19c/grid/bin/srvctl config listener

        6、srvctl config nodeapps

/u01/app/19c/grid/bin/srvctl config nodeapps

        7、srvctl config cvu

/u01/app/19c/grid/bin/srvctl config cvu

        8、oifcfg getif

/u01/app/19c/grid/bin/oifcfg getif

六、停止集群服务检查状态

        1、srvctl stop listener

/u01/app/19c/grid/bin/srvctl stop listener

        2、srvctl stop scan_listener

/u01/app/19c/grid/bin/srvctl stop scan_listener

        3、srvctl stop database -db orcl

/u01/app/19c/grid/bin/srvctl stop database -db orcl

        4、srvctl stop cvu

/u01/app/19c/grid/bin/srvctl stop cvu

        5、srvctl stop vip -n testrac1 

/u01/app/19c/grid/bin/srvctl stop vip -n rac19c1
/u01/app/19c/grid/bin/srvctl stop vip -n rac19c2

        6、srvctl stop scan

/u01/app/19c/grid/bin/srvctl stop scan

        7、srvctl stop nodeapps -f

/u01/app/19c/grid/bin/srvctl stop nodeapps -f

        8、crsctl stat res -t

/u01/app/19c/grid/bin/crsctl stat res -t

七、添加IPv6网络资源

        集群中一个节点执行即可

        1、添加IPv6网络资源

/u01/app/19c/grid/bin/srvctl modify network -netnum 1 -subnet 2409:807e:5804:114::0//ens3

        2、修改VIP

        首先先删除节点VIP，然后再重新添加

/u01/app/19c/grid/bin/srvctl remove vip -vip testrac1
/u01/app/19c/grid/bin/srvctl add vip -node testrac1 -netnum 1 -address 192.168.1.65/255.255.255.0/ens3
/u01/app/19c/grid/bin/srvctl modify vip -node testrac1 -netnum 1 -address 2409:807e:5804:114::24c//ens3

/u01/app/19c/grid/bin/srvctl remove vip -vip testrac2
/u01/app/19c/grid/bin/srvctl add vip -node testrac2 -netnum 1 -address 192.168.1.66/255.255.255.0/ens3
/u01/app/19c/grid/bin/srvctl modify vip -node testrac2 -netnum 1 -address 2409:807e:5804:114::24d//ens3

        3、添加公共接口

        使用 oifcfg 将新的公共接口添加到集群。

        4、扫描集群名

/u01/app/19c/grid/bin/srvctl modify scan -scanname testrac-scan

        5、修改网络资源并激活IPv6配置

/u01/app/19c/grid/bin/srvctl modify network -iptype both
/u01/app/19c/grid/bin/srvctl start nodeapps
/u01/app/19c/grid/bin/srvctl start cvu
/u01/app/19c/grid/bin/srvctl start listener
/u01/app/19c/grid/bin/srvctl start scan_lintener
/u01/app/19c/grid/bin/crsctl stat res -t

八、验证

        那现在就可以使用第三方工具去测试，下面使用的是plsql developer来进行测试：
        首先得先给win的主机配置上ipv6