当前位置:Gxlcms > mysql > 11Gr2RAC修改scanIP

11Gr2RAC修改scanIP

时间:2021-07-01 10:21:17 帮助过:59人阅读

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

  1. SCAN VIP scan1 is enabled
  2. SCAN VIP scan1 is not running

# $GRID_HOME/bin/srvctl status scan_listener

  1. SCAN Listener LISTENER_SCAN1 is enabled
  2. 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

  1. SCAN name: qr01-scan, Network: 1/192.0.2.0/255.255.255.0/eth0
  2. 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

  1. SCAN name: qr01-scan, Network: 1/192.0.2.0/255.255.255.0/eth0
  2. 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

  1. NAME TYPE VALUE
  2. ------------------------------------ ----------- ------------------------------
  3. remote_listener string qr01-scan:1521


8.
check listener status

$ps -ef|grep tns

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

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

  1. LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 07-MAY-2012 17:46:25
  2. Copyright (c) 1991, 2010, Oracle. All rights reserved.
  3. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))
  4. STATUS of the LISTENER
  5. ------------------------
  6. Alias LISTENER_SCAN1
  7. Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production
  8. Start Date 07-MAY-2012 12:12:11
  9. Uptime 0 days 1 hr. 34 min. 14 sec
  10. Trace Level off
  11. Security ON: Local OS Authentication
  12. SNMP OFF
  13. Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora
  14. Listener Log File /u01/app/11.2.0/grid/log/diag/tnslsnr/qr01db02/listener_scan1/alert/log.xml
  15. Listening Endpoints Summary...
  16. (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))
  17. (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.0.2.31)(PORT=1521)))
  18. Services Summary...
  19. Service "dbm.example.com" has 2 instance(s).
  20. Instance "dbm1", status READY, has 1 handler(s) for this service...
  21. Instance "dbm2", status READY, has 1 handler(s) for this service...
  22. Service "dbmXDB.example.com" has 2 instance(s).
  23. Instance "dbm1", status READY, has 1 handler(s) for this service...
  24. Instance "dbm2", status READY, has 1 handler(s) for this service...
  25. The command completed successfully

人气教程排行