Oracle 11G 修改scan_ip

来源:这里教程网 时间:2026-03-03 18:02:16 作者:

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;

相关推荐