-
查看原始scan
[grid@db1 ~]$srvctl config scan
SCAN name: db-scan, Network: 1/172.18.42.0/255.255.255.0/bond0
SCAN VIP name: scan1, IP: /db-scan/172.18.42.232
这里可以看出scan的ip别名是db-scan,ip是172.18.42.232
-
停止监听
[grid@db1 ~]$ srvctl stop listener
[grid@db1 ~]$ srvctl status
Listener LISTENER is enabled
Listener LISTENER is not running
-
停止scan和scan_listener (先停scan_listener,再停scan)
[grid@db1 ~]$ srvctl stop scan_listener
[grid@db1 ~]$ srvctl stop scan
-
查看
[grid@db1 ~]$ srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is not running
[grid@db1 ~]$ srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is not running
[grid@db1 ~]$ crs_stat -t |grep scan
ora.scan1.vip ora....ip.type OFFLINE OFFLINE
[grid@db1 ~]$ crs_stat -t |grep lsnr
ora....ER.lsnr ora....er.type OFFLINE OFFLINE
ora....N1.lsnr ora....er.type OFFLINE OFFLINE
ora....B1.lsnr application OFFLINE OFFLINE
ora....B2.lsnr application OFFLINE OFFLINE
-
编辑两节点/etc/hosts下的scan 的ip
-
root用户,grid环境修改scan的ip
[grid@db1 ~]$ su
Password:
[root@db1 grid]# srvctl modify scan -n db-scan
[root@db1 grid]# srvctl config scan
SCAN name: db-scan, Network: 1/172.18.42.0/255.255.255.0/bond0
SCAN VIP name: scan1, IP: /db-scan/172.18.42.237
-
启动scan和listener
[root@db1 grid]# su - grid
[grid@db1 ~]$ srvctl start scan
[grid@db1 ~]$ srvctl start scan_listener
[grid@db1 ~]$ crs_stat -t | grep scan
ora.scan1.vip ora....ip.type ONLINE ONLINE db2
[grid@db1 ~]$ crs_stat -t | grep lsnr
ora....ER.lsnr ora....er.type OFFLINE OFFLINE
ora....N1.lsnr ora....er.type ONLINE ONLINE db2
ora....B1.lsnr application OFFLINE OFFLINE
ora....B2.lsnr application OFFLINE OFFLINE
-
启动监听
[grid@db1 ~]$ srvctl start listener
[grid@db1 ~]$ srvctl start listener crs_stat -t | grep lsnr
ora....ER.lsnr ora....er.type ONLINE ONLINE db1
ora....N1.lsnr ora....er.type ONLINE ONLINE db2
ora....B1.lsnr application ONLINE ONLINE db1
ora....B2.lsnr application ONLINE ONLINE db2
-
重启数据库(这步是关键)
-
测试
[grid@db1 ~]$ ping 172.18.42.237
PING 172.18.42.237 (172.18.42.237) 56(84) bytes of data.
64 bytes from 172.18.42.237: icmp_seq=1 ttl=64 time=1.30 ms
64 bytes from 172.18.42.237: icmp_seq=2 ttl=64 time=0.189 ms
64 bytes from 172.18.42.237: icmp_seq=3 ttl=64 time=0.168 ms
64 bytes from 172.18.42.237: icmp_seq=4 ttl=64 time=0.257 ms
并且:
sqlplus zxx/zxx@172.18.42.237/orcl 或者 sqlplus zxx/zxx@db-scan/orcl
修改 rac scan
最新推荐文章于 2024-01-30 17:25:29 发布