合 Oracle rac 修改SCAN IP信息
Tags： Oraclerac监听remote_listener修改端口号listener.oralocal_listenerSCAN IP1521增加scan ip个数
👉 本文共约4854个字，系统预计阅读时间或需19分钟。
目录
- 修改SCAN主机名、端口号、增加scan ip的个数
- 示例：增加scan ip个数
- 修改rac的默认端口号为1522
- 检查
- How to Update the IP Address of the SCAN VIP Resources (ora.scan{n}.vip) (文档 ID 952903.1)
- APPLIES TO:
- GOAL
- SOLUTION
- How to Modify SCAN Setting or SCAN Listener Port after Installation (文档 ID 972500.1)
- APPLIES TO:
- GOAL
- SOLUTION
- A. To update SCAN setting
- B. To modify SCAN listener port
- REFERENCES
- 总结
修改SCAN主机名、端口号、增加scan ip的个数
在集群正常运行的情况下，首先修改所有节点/etc/hosts文件后，再执行如下命令，其中raclhr-scan是修改后的SCAN主机名：
1 2 3 4 5 6 7 | srvctl config scan srvctl stop scan_listener srvctl stop scan srvctl modify scan -n raclhr-scan srvctl config scan srvctl start scan srvctl start scan_listener |
如果SCAN IP的个数改变了，那么还需要执行如下命令进行更新：
1 | srvctl modify scan_listener -u |
需要注意的是，以上步骤也适用于修改SCAN的IP地址或增加SCAN IP的个数。
修改SCAN的端口号的命令如下所示：
1 | srvctl modify scan_listener -p 1522 |
示例：增加scan ip个数
对新配置的oracle RAC环境增配2个SCAN IP地址，192.168.59.175以及192.168.59.176。
配置前信息
默认情况下配置RA 只有1个scan IP，1个 scan listener。
查看scan的配置信息
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 | [root@raclhr-11gR2-N1 ~]# cat /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 #Public IP 192.168.59.170 raclhr-11gR2-N1 192.168.59.171 raclhr-11gR2-N2 #Private IP 192.168.2.110 raclhr-11gR2-N1-priv 192.168.2.111 raclhr-11gR2-N2-priv #Virtual IP 192.168.59.172 raclhr-11gR2-N1-vip 192.168.59.173 raclhr-11gR2-N2-vip #Scan IP 192.168.59.174 raclhr-11gR2-scan [root@raclhr-11gR2-N1 ~]# srvctl config scan SCAN name: raclhr-11gR2-scan, Network: 1/192.168.59.0/255.255.255.0/eth0 SCAN VIP name: scan1, IP: /raclhr-11gR2-scan/192.168.59.174 |
查看scan的状态以及scan ip所处节点
1 2 3 4 5 6 7 | [root@raclhr-11gR2-N1 ~]# srvctl status scan SCAN VIP scan1 is enabled SCAN VIP scan1 is running on node raclhr-11gr2-n2 [root@raclhr-11gR2-N1 ~]# |
查看scan listener
1 2 3 4 5 | [root@raclhr-11gR2-N1 ~]# srvctl config scan_listener SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521 [root@raclhr-11gR2-N1 ~]# |
修改rac所有节点的/etc/hosts信息
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 | [root@raclhr-11gR2-N1 ~]# cat /etc/hosts 127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4 ::1 localhost localhost.localdomain localhost6 localhost6.localdomain6 #Public IP 192.168.59.170 raclhr-11gR2-N1 192.168.59.171 raclhr-11gR2-N2 #Private IP 192.168.2.110 raclhr-11gR2-N1-priv 192.168.2.111 raclhr-11gR2-N2-priv #Virtual IP 192.168.59.172 raclhr-11gR2-N1-vip 192.168.59.173 raclhr-11gR2-N2-vip #Scan IP 192.168.59.174 raclhr-11gR2-scan 192.168.59.175 raclhr-11gR2-scan ----->>>>新增的SCAN IP 192.168.59.176 raclhr-11gR2-scan ----->>>>新增的SCAN IP |
停止scan 监听，注意先停监听才能停scan
1 2 3 4 5 6 7 8 9 | srvctl stop scan_listener srvctl stop scan srvctl status scan_listener srvctl status scan |
配置scan，注意需要用root权限执行
修改scan信息，-n 后面接 hosts中的san ip 网络名：
1 2 3 4 5 6 7 8 9 10 11 12 13 | [root@raclhr-11gR2-N1 ~]# srvctl modify scan -h Modifies the SCAN name. Usage: srvctl modify scan -n -n Domain name qualified SCAN name -h Print usage [root@raclhr-11gR2-N1 ~]# [root@raclhr-11gR2-N1 ~]# srvctl modify scan -n raclhr-11gR2-scan |
本人提供Oracle(OCP、OCM)、MySQL(OCP)、PostgreSQL(PGCA、PGCE、PGCM)等数据库的培训和考证业务，私聊QQ646634621或微信db_bao，谢谢！
