好得很程序员自学网

<tfoot draggable='sEl'></tfoot>

11Gr2RAC修改scanIP

11Gr2环境需要更改scan ip, 基本的原理就是更改DNS或者hosts文件内的IP地址,然后通过srvctl 命令去同步CRS内的信息,完成scan ip的修改。 Before, need modify all the node /etc/hosts, set the new ip address. 1. Stop the SCAN listener and the SCAN V

11Gr2环境需要更改scan ip, 基本的原理就是更改DNS或者hosts文件内的IP地址,然后通过srvctl 命令去同步CRS内的信息,完成scan ip的修改。


Before, need modify all the node /etc/hosts, set the new ip address.

1.
Stop the SCAN listener and the SCAN VIP resources:

2.需要先停止服务,测试时候由于没有停止服务,最后出现scan listener没有启动,后手动启动,同时parameter remote_listener值丢失,重新设置的。
# $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        


3.
# To check the current IP address(es) of the SCAN VIPs, run the following commands as the root user:
$GRID_HOME/bin/srvctl config scan

    SCAN name: qr01-scan, Network: 1/192.0.2.0/255.255.255.0/eth0      SCAN VIP name: scan1, IP: /qr01-scan.example.com/192.0.2.21     


4.
# Next refresh the SCAN VIPs with the new IP addresses from the DNS entry:
$GRID_HOME/bin/srvctl modify scan -n
5.
# To check if the SCAN VIPs have been changed, run the following command, it should now show the new IP addresses.
$GRID_HOME/bin/srvctl config scan

    SCAN name: qr01-scan, Network: 1/192.0.2.0/255.255.255.0/eth0      SCAN VIP name: scan1, IP: /qr01-scan.example.com/192.0.2.31     


6.
Start SCAN and the SCAN listener:
# $GRID_HOME/bin/srvctl start scan
# $GRID_HOME/bin/srvctl start scan_listener
7.
check parameter
SQL> show parameter remote

    NAME                                 TYPE        VALUE      ------------------------------------ ----------- ------------------------------     remote_listener                      string      qr01-scan:1521     


8.
check listener status

$ps -ef|grep tns

    oracle    4992     1  0 16:12 ?        0 /u01/app/11.2.0/grid/bin/tnslsnr LISTENER_SCAN1 -inherit      oracle    5004     1  0 16:12 ?        0 /u01/app/11.2.0/grid/bin/tnslsnr LISTENER -inherit     oracle    9816  5529  0 17:45 pts/0    0 grep tns     

需要到grid用户下执行下面命令
$lsnrctl status LISTENER_SCAN1

    LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 07-MAY-2012 17:46:25           Copyright (c) 1991, 2010, 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.2.0 - Production     Start Date                07-MAY-2012 12:12:11     Uptime                    0 days 1 hr. 34 min. 14 sec     Trace Level               off     Security                  ON: Local OS Authentication     SNMP                      OFF     Listener Parameter File   /u01/app/11.2.0/grid/network/admin/listener.ora     Listener Log File         /u01/app/11.2.0/grid/log/diag/tnslsnr/qr01db02/listener_scan1/alert/log.xml     Listening Endpoints Summary...       ( DESCRIPTION  =(  ADDRESS  =(  PROTOCOL  =  ipc  )(  KEY  =  LISTENER_SCAN1  )))        ( DESCRIPTION  =(  ADDRESS  =(  PROTOCOL  =  tcp  )(  HOST  =  192  .0.2.31)(  PORT  =  1521  )))      Services Summary...     Service "dbm.example.com" has 2 instance(s).       Instance "dbm1", status READY, has 1 handler(s) for this service...       Instance "dbm2", status READY, has 1 handler(s) for this service...     Service "dbmXDB.example.com" has 2 instance(s).       Instance "dbm1", status READY, has 1 handler(s) for this service...       Instance "dbm2", status READY, has 1 handler(s) for this service...     The command completed successfully     

查看更多关于11Gr2RAC修改scanIP的详细内容...

  阅读:41次