重庆思庄Oracle、、PostgreSQL、Redhat认证学习论坛

标题: oracle rac 添加多个scan ip [打印本页]

作者: mahan 时间: 前天 20:46
标题: oracle rac 添加多个scan ip
实施环境
两台节点组成的oracle 19c rac，新增了一个scan ip。

原scan ip 10.10.10.44

新增后的scan ip 为10.10.10.44 和10.10.10.45

停止监听
–关闭两边节点的scan监听

--查看scan监听状态
# /u01/app/19.3.0/grid/bin/srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node rac19c01

# /u01/app/19.3.0/grid/bin/srvctl config scan
SCAN name: rac19c-scan, Network: 1
Subnet IPv4: 10.10.10.0/255.255.255.0/ens33, static
Subnet IPv6:
SCAN 1 IPv4 VIP: 10.10.10.44
SCAN VIP is enabled.

--关闭scan监听
# /u01/app/19.3.0/grid/bin/srvctl stop scan_listener
# /u01/app/19.3.0/grid/bin/srvctl stop scan

# /u01/app/19.3.0/grid/bin/srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is not running

修改hosts文件
--修改前备份hosts文件
cp /etc/hosts /etc/hosts`date "+%F"`.bak

--原hosts:
## RAC1 Public IP
10.10.10.40 rac19c01
## RAC1 Virtual IP
10.10.10.41 rac19c01-vip
## RAC1 Private IP
10.10.20.40 rac19c01-priv
10.10.20.41 rac19c01-priv1

## RAC2 IP's: rac19c02

## RAC2 Public IP
10.10.10.42 rac19c02
## RAC2 Virtual IP
10.10.10.43 rac19c02-vip
## RAC2 Private IP
10.10.20.42 rac19c02-priv
10.10.20.43 rac19c02-priv1

## SCAN IP
10.10.10.44 rac19c-scan

--修改后的hosts：
#########new-address##############
## RAC1 Public IP
10.10.10.40 rac19c01
## RAC1 Virtual IP
10.10.10.41 rac19c01-vip
## RAC1 Private IP
10.10.20.40 rac19c01-priv
10.10.20.41 rac19c01-priv1

## RAC2 IP's: rac19c02

## RAC2 Public IP
10.10.10.42 rac19c02
## RAC2 Virtual IP
10.10.10.43 rac19c02-vip
## RAC2 Private IP
10.10.20.42 rac19c02-priv
10.10.20.43 rac19c02-priv1

## SCAN IP
10.10.10.44 rac19c-scan
10.10.10.45 rac19c-scan

PS：文件新增了10.10.10.45这个scan ip，注意两个节点都要修改！！！
修改scan ip
--更改scan配置
# /u01/app/19.3.0/grid/bin/srvctl modify scan -n rac19c-scan

# /u01/app/19.3.0/grid/bin/srvctl config scan
SCAN name: rac19c-scan, Network: 1
Subnet IPv4: 10.10.10.0/255.255.255.0/ens33, static
Subnet IPv6:
SCAN 1 IPv4 VIP: 10.10.10.44
SCAN VIP is enabled.
SCAN 2 IPv4 VIP: 10.10.10.45
SCAN VIP is enabled.
到这一步，我们修改了scan ip的配置，发现新增的ip已经再里面，但如果没有执行srvctl modify scan_listener -u，我们看下会有什么问题。

–先把scan启动，看看新增的scan ip能否使用

--启动scan监听
# /u01/app/19.3.0/grid/bin/srvctl start scan
# /u01/app/19.3.0/grid/bin/srvctl start scan_listener

[root@rac19c01:~]# /u01/app/19.3.0/grid/bin/srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node rac19c01
–查看主机ip地址

[root@rac19c01:~]# ip a
2: ens33: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP group default qlen 1000
link/ether 00:0c:29:33:a5:5f brd ff:ff:ff:ff:ff:ff
inet 10.10.10.40/24 brd 10.10.10.255 scope global ens33
   valid_lft forever preferred_lft forever
inet 10.10.10.41/24 brd 10.10.10.255 scope global secondary ens33:1
   valid_lft forever preferred_lft forever
inet 10.10.10.44/24 brd 10.10.10.255 scope global secondary ens33:2
   valid_lft forever preferred_lft forever
inet6 fe80::20c:29ff:fe33:a55f/64 scope link
   valid_lft forever preferred_lft forever

[root@rac19c02:~]# ip a
2: ens33: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast state UP group default qlen 1000
link/ether 00:0c:29:69:d7:ee brd ff:ff:ff:ff:ff:ff
inet 10.10.10.42/24 brd 10.10.10.255 scope global ens33
   valid_lft forever preferred_lft forever
inet 10.10.10.45/24 brd 10.10.10.255 scope global secondary ens33:2
   valid_lft forever preferred_lft forever
inet 10.10.10.43/24 brd 10.10.10.255 scope global secondary ens33:3
   valid_lft forever preferred_lft forever
inet6 fe80::20c:29ff:fe69:d7ee/64 scope link
   valid_lft forever preferred_lft forever
可以发现10.10.10.44 和10.10.10.45 分别启动在其中一个节点上。

–测试使用10.10.10.44 和10.10.10.45能否连接数据库

$ sqlplus system/oracle@10.10.10.44/rac19c

SQL*Plus: Release 19.0.0.0.0 - Production on Sun Apr 13 23:02:56 2025
Version 19.22.0.0.0

Copyright (c) 1982, 2023, Oracle.  All rights reserved.

Last Successful login time: Fri Apr 11 2025 14:18:13 +08:00

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.22.0.0.0

SQL> quit

$ sqlplus system/oracle@10.10.10.45/rac19c

SQL*Plus: Release 19.0.0.0.0 - Production on Sun Apr 13 23:03:00 2025
Version 19.22.0.0.0

Copyright (c) 1982, 2023, Oracle.  All rights reserved.

ERROR:
ORA-12541: TNS:no listener
可以看到10.10.10.44可以连接，但新增的10.10.10.45报错，没有发现监听。

–看下集群状态

[grid@rac19c01:~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name          Target  State       Server                State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
            ONLINE  ONLINE    rac19c01                STABLE
            ONLINE  ONLINE    rac19c02                STABLE
ora.chad
            ONLINE  ONLINE    rac19c01                STABLE
            ONLINE  ONLINE    rac19c02                STABLE
ora.net1.network
            ONLINE  ONLINE    rac19c01                STABLE
            ONLINE  ONLINE    rac19c02                STABLE
ora.ons
            ONLINE  ONLINE    rac19c01                STABLE
            ONLINE  ONLINE    rac19c02                STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
   1       ONLINE  ONLINE    rac19c01                STABLE
   2       ONLINE  ONLINE    rac19c02                STABLE
ora.DATA.dg(ora.asmgroup)
   1       ONLINE  ONLINE    rac19c01                STABLE
   2       ONLINE  ONLINE    rac19c02                STABLE
ora.LISTENER_SCAN1.lsnr
   1       ONLINE  ONLINE    rac19c01                STABLE
ora.OCR.dg(ora.asmgroup)
   1       ONLINE  ONLINE    rac19c01                STABLE
   2       ONLINE  ONLINE    rac19c02                STABLE
ora.asm(ora.asmgroup)
   1       ONLINE  ONLINE    rac19c01                Started,STABLE
   2       ONLINE  ONLINE    rac19c02                Started,STABLE

........................
发现只有一个scan的监听LISTENER_SCAN1

更新SCAN IP的个数
–使用srvctl modify scan_listener -u

[root@rac19c01:~]# /u01/app/19.3.0/grid/bin/srvctl modify scan_listener -u
[root@rac19c01:~]# /u01/app/19.3.0/grid/bin/srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node rac19c01
SCAN VIP scan2 is enabled
SCAN VIP scan2 is running on node rac19c02

[grid@rac19c01:~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name          Target  State       Server                State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
            ONLINE  ONLINE    rac19c01                STABLE
            ONLINE  ONLINE    rac19c02                STABLE
ora.chad
            ONLINE  ONLINE    rac19c01                STABLE
            ONLINE  ONLINE    rac19c02                STABLE
ora.net1.network
            ONLINE  ONLINE    rac19c01                STABLE
            ONLINE  ONLINE    rac19c02                STABLE
ora.ons
            ONLINE  ONLINE    rac19c01                STABLE
            ONLINE  ONLINE    rac19c02                STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
   1       ONLINE  ONLINE    rac19c01                STABLE
   2       ONLINE  ONLINE    rac19c02                STABLE
ora.DATA.dg(ora.asmgroup)
   1       ONLINE  ONLINE    rac19c01                STABLE
   2       ONLINE  ONLINE    rac19c02                STABLE
ora.LISTENER_SCAN1.lsnr
   1       ONLINE  ONLINE    rac19c01                STABLE
ora.LISTENER_SCAN2.lsnr
   1       OFFLINE OFFLINE                            STABLE
........................
可以发现使用srvctl modify scan_listener -u更新后，多了一个LISTENER_SCAN2，并且状态为offline。

把这个LISTENER_SCAN2启动后，在查看集群状态

[grid@rac19c01:~]$ srvctl start scan_listener -scannumber 2
[grid@rac19c01:~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name          Target  State       Server                State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
            ONLINE  ONLINE    rac19c01                STABLE
            ONLINE  ONLINE    rac19c02                STABLE
ora.chad
            ONLINE  ONLINE    rac19c01                STABLE
            ONLINE  ONLINE    rac19c02                STABLE
ora.net1.network
            ONLINE  ONLINE    rac19c01                STABLE
            ONLINE  ONLINE    rac19c02                STABLE
ora.ons
            ONLINE  ONLINE    rac19c01                STABLE
            ONLINE  ONLINE    rac19c02                STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
   1       ONLINE  ONLINE    rac19c01                STABLE
   2       ONLINE  ONLINE    rac19c02                STABLE
ora.DATA.dg(ora.asmgroup)
   1       ONLINE  ONLINE    rac19c01                STABLE
   2       ONLINE  ONLINE    rac19c02                STABLE
ora.LISTENER_SCAN1.lsnr
   1       ONLINE  ONLINE    rac19c01                STABLE
ora.LISTENER_SCAN2.lsnr
   1       ONLINE  ONLINE    rac19c02                STABLE
.............................
连接测试
–LISTENER_SCAN2启动后、重新进行SCAN ip 连接测试。

$ sqlplus system/oracle@10.10.10.44/rac19c

SQL*Plus: Release 19.0.0.0.0 - Production on Sun Apr 13 23:02:56 2025
Version 19.22.0.0.0

Copyright (c) 1982, 2023, Oracle.  All rights reserved.

Last Successful login time: Fri Apr 11 2025 14:18:13 +08:00

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.22.0.0.0

SQL> quit

$ sqlplus system/oracle@10.10.10.45/rac19c

SQL*Plus: Release 19.0.0.0.0 - Production on Sun Apr 13 23:15:58 2025
Version 19.22.0.0.0

Copyright (c) 1982, 2023, Oracle.  All rights reserved.

Last Successful login time: Sun Apr 13 2025 23:02:56 +08:00

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.22.0.0.0

SQL>

复制
可以看到10.10.10.44 和10.10.10.45都能连接成功了。

总结
在修改scan ip时需注意如果新增了scan ip的个数，则需执行srvctl modify scan_listener -u进行更新，若不执行该命令，将只有一个listener_scan1监听，执行后将根据scan ip数自动增加listener_scan2，listener_scan3。

欢迎光临重庆思庄Oracle、、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)