欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

11Gr2 RAC 修改scan IP

程序员文章站 2024-01-18 09:00:58
...

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