ITPub博客

首页 > 数据库 > Oracle > Oracle 11G 修改scan_ip

Oracle 11G 修改scan_ip

原创 Oracle 作者:zjjxyh 时间:2022-10-21 11:46:24 0 删除 编辑

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;


来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/27192222/viewspace-2919585/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2013-01-20

  • 博文量
    52
  • 访问量
    31167