Oracle 11G 修改scan_ip

1.srvctl config scan  檢視當前 vip  設定

 

     p570a@root#  ./srvctl config scan

     SCAN name: 192.168.128.100, Network: 1/192.168.128.0/255.255.255.0/en0

     SCAN VIP name: scan1, IP: /scan-vip/192.168.128.100

    

2.  用 root  使用者停止 scan_listener  和 sacn vip

 

     $GRID_HOME/bin/  srvctl stop scan_listener

     $GRID_HOME/bin  /srvctl stop scan

    

     $GRID_HOME/bin/  srvctl status scan

     SCAN VIP scan1 is enabled

     SCAN VIP scan1 is not running 

    

     $GRID_HOME/bin/  srvctl status scan_listener

     SCAN Listener LISTENER_SCAN1 is enabled

     SCAN listener LISTENER_SCAN1 is not running

    

兩個節點修改  /etc/hosts  對應的  scan-ip

 

3.  用 root  使用者修改 scan vip

      $GRID_HOME/bin/srvctl modify scan -n scan-nam(/etc/hosts  定義的  scan ip  的  alias)

      e.g. $GRID_HOME/bin  /srvctl modify scan –n wstgov-scan

     

4.  檢查是否修改成功

      p570a@root#  ./srvctl config scan

     SCAN name: 10.76.31.111 , Network: 1/10.76.31.0/255.255.255.0/en0

     SCAN VIP name: scan1, IP: /scan-vip/10.76.31.111  

       

5.  啟動 scan  和 scan_listener

      $GRID_HOME/bin/  srvctl start scan

      $GRID_HOME/bin/  srvctl start scan_listener

 

[grid@rac2 ~]$ lsnrctl status listener_scan1

 

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 09-MAR-2018 16:22:04

 

Copyright (c) 1991, 2013, Oracle.  All rights reserved.

 

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))

STATUS of the LISTENER

------------------------

Alias                     LISTENER_SCAN1

Version                   TNSLSNR for Linux: Version 11.2.0.4.0 - Production

Start Date                09-MAR-2018 16:14:50

Uptime                    0 days 0 hr. 7 min. 13 sec

Trace Level               off

Security                  ON: Local OS Authentication

SNMP                      OFF

Listener Parameter File   /oracle/grid/crs_1/network/admin/listener.ora

Listener Log File         /oracle/grid/crs_1/log/diag/tnslsnr/rac2/listener_scan1/alert/log.xml

Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))

  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=  192.168.56.56  )(PORT=1521)))

The listener supports no services

The command completed successfully

 

6.  登入資料庫

show parameter remote;

Alter system set REMOTE_LISTENER='rac-scan:1521' scope=both sid='*';

alter system register;