修改 rac scan

  1. 查看原始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

  2. 停止监听

    [grid@db1 ~]$ srvctl stop listener

    [grid@db1 ~]$ srvctl status

    Listener LISTENER is enabled

    Listener LISTENER is not running

  3. 停止scan和scan_listener (先停scan_listener,再停scan)

    [grid@db1 ~]$ srvctl stop scan_listener

    [grid@db1 ~]$ srvctl stop scan

  4. 查看

    [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 

  5. 编辑两节点/etc/hosts下的scan 的ip

  6. 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

  7. 启动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   

  8. 启动监听

    [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  

  9. 重启数据库(这步是关键)

  10. 测试

    [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

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值