?看下12c中对SCAN 的修改,修改包括2个方面:
(1) 修改SCAN 的名称。
(2) 修改SCAN 的IP 地址。
?
如果使用的是/etc/hosts里的SCAN,那么只需要修改hosts文件就可以,如果使用DNS的,就需要从DNS 来修改,我这里使用DNS的RAC环境,所以修改DNS为例,进行示范。
?
另外,修改会停止SCAN,所以如果数据库是用SCAN 连链接的,就需要停部分操作,这部分可以转换到用VIP连链接,修改期间,数据库可以正常运行,其他操作不受影响。
?
1 当前环境
?
[grid@rac1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....SM.lsnr ora....er.type ONLINE ONLINE rac1
ora....ER.lsnr ora....er.type ONLINE ONLINE rac1
ora....N1.lsnr ora....er.type ONLINE ONLINE rac2
ora....N2.lsnr ora....er.type ONLINE ONLINE rac1
ora....N3.lsnr ora....er.type ONLINE ONLINE rac1
ora.MGMTLSNR ora....nr.type ONLINE ONLINE rac1
ora.OCR.dg ora....up.type ONLINE ONLINE rac1
ora.asm ora.asm.type ONLINE ONLINE rac1
ora.cvu ora.cvu.type ONLINE ONLINE rac1
ora.mgmtdb ora....db.type ONLINE ONLINE rac1
ora....network ora....rk.type ONLINE ONLINE rac1
ora.oc4j ora.oc4j.type ONLINE ONLINE rac1
ora.ons ora.ons.type ONLINE ONLINE rac1
ora.proxy_advm ora....vm.type ONLINE ONLINE rac1
ora....C1.lsnr application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip ora....t1.type ONLINE ONLINE rac1
ora....C2.lsnr application ONLINE ONLINE rac2
ora.rac2.ons application ONLINE ONLINE rac2
ora.rac2.vip ora....t1.type ONLINE ONLINE rac2
ora.scan1.vip ora....ip.type ONLINE ONLINE rac2
ora.scan2.vip ora....ip.type ONLINE ONLINE rac1
ora.scan3.vip ora....ip.type ONLINE ONLINE rac1
?
[grid@rac1 ~]$ srvctl config scan
SCAN name: scan.cndba.cn, Network: 1
Subnet IPv4:192.168.56.0/255.255.255.0/eth0
Subnet IPv6:
SCAN 0 IPv4 VIP: 192.168.56.21
SCAN name: scan.cndba.cn, Network: 1
Subnet IPv4:192.168.56.0/255.255.255.0/eth0
Subnet IPv6:
SCAN 1 IPv4 VIP: 192.168.56.22
SCAN name: scan.cndba.cn, Network: 1
Subnet IPv4:192.168.56.0/255.255.255.0/eth0
Subnet IPv6:
SCAN 2 IPv4 VIP: 192.168.56.20
[grid@rac1 ~]$
?
这里是2个节点的RAC 集群。
?
SCAN 名称是:scan.cndba.cn
3个SCAN IP:
192.168.56.20
192.168.56.21
192.168.56.22
?
?
2 修改SCAN
?
2.1 停止SCAN
?
[grid@rac1 ~]$ srvctl stop scan_listener
[grid@rac1 ~]$ srvctl stop scan
[grid@rac1 ~]$ srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is not running
SCAN VIP scan2 is enabled
SCAN VIP scan2 is not running
SCAN VIP scan3 is enabled
SCAN VIP scan3 is not running
?
2.2 修改SCAN 信息
?
这里我们修改SCAN 名称和IP 地址。
?
这里将SCAN 名称从SCAN 修改成cndba-scan.
?
IP 地址修改成:
192.168.56.30
192.168.56.31
192.168.56.32
?
关于SCAN的修改,参考如下链接:
Oracle 12c RAC 集群使用DNS 实现 SCAN
http://blog.csdn.net/tianlesoftware/article/details/42917867
?
修改之后,如下:
?
[grid@rac1 grid]$ nslookupcndba-scan.cndba.cn
Server: 192.168.56.200
Address: 192.168.56.200#53
?
Name: cndba-scan.cndba.cn
Address: 192.168.56.30
Name: cndba-scan.cndba.cn
Address: 192.168.56.31
Name: cndba-scan.cndba.cn
Address: 192.168.56.32
?
[grid@rac2 ~]$ nslookup cndba-scan.cndba.cn
Server: 192.168.56.200
Address: 192.168.56.200#53
?
Name: cndba-scan.cndba.cn
Address: 192.168.56.31
Name: cndba-scan.cndba.cn
Address: 192.168.56.32
Name: cndba-scan.cndba.cn
Address: 192.168.56.30
?
2.3 执行修改操作
?
用root用户执行如下操作。
?
[grid@rac1 ~]$ which srvctl
/u01/gridsoft/12.1.0/bin/srvctl
?
[grid@rac1 ~]$ which crsctl
/u01/gridsoft/12.1.0/bin/crsctl
?
[root@rac1 /]# /u01/gridsoft/12.1.0/bin/srvctlmodify scan -n cndba-scan.cndba.cn