11 Gr 2 RAC修正scan IP


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