【RAC】如何修改SCAN IP的IP地址、名稱、埠等資訊

---

---

RAC 增加SCAN IP ：http://blog.itpub.net/26736162/viewspace-2155652/

---

---

How to Update the IP Address of the SCAN VIP Resources (ora.scan{n}.vip) (文件 ID 952903.1)

In this Document

Goal

Solution

References

---

APPLIES TO:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.

GOAL

The purpose of this document is to explain how to change the IP addresses associated with the SCAN VIPs in a 11gR2 Grid (CRS) environment. 

The IP addresses associated with the SCAN VIP resources are initially set when the SCAN resources are created. 
Any changes to the DNS entry for the SCAN are not automatically propagated to the clusterware and need to be done manually.

This applies only to installations that are not using GNS.

The information in this note can also be helpful in cases where SCAN was originally configured with just one address and is now being expanded to accommodate three IP addresses.

SOLUTION

1. Before the SCAN VIPs can be changed, the entry for the SCAN name on the Domain Name Server (DNS) needs to be updated with the new IP addresses. This usually will be done by a network administrator. To check the current setting, the following command can be used:
   
   nslookup <scan_name>
2. 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
3. Stop the SCAN listeners and SCAN
   $GRID_HOME/bin/srvctl stop scan_listener 
   $GRID_HOME/bin/srvctl stop scan
4. Next refresh the SCAN VIPs with the new IP addresses from the DNS entry:
   $GRID_HOME/bin/srvctl modify scan -n <scan_name
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
6. Restart SCAN & SCAN listener:
   $GRID_HOME/bin/srvctl start scan 
   $GRID_HOME/bin/srvctl start scan_listener
    
7. If the number of SCAN VIPs has changed, the SCAN listener needs to be updated:
   
   $GRID_HOME/bin/srvctl modify scan_listener -u
    

A lookup of the SCAN on the DNS server shows that the entry has already been updated with the new IP addresses:

Stop the SCAN listener and the SCAN VIP resources:

The SCAN VIP resources still show the old IP addresses:

Now tell CRS to update the SCAN VIP resources:

To verify that the change was successful, check the SCAN configuration again:

 
Start SCAN and the SCAN listener:

 

---

---

How to Modify SCAN Setting or SCAN Listener Port after Installation (文件 ID 972500.1)

In this Document

Goal

Solution

A. To update SCAN setting

B. To modify SCAN listener port

References

---

APPLIES TO:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.

GOAL

This note provides steps to update 11gR2 Grid Infrastructure (CRS) Single Client Access Name (SCAN) setting or SCAN listener port setting if it's not setup properly or if it's changed after setup. 

Note:

1. This procedure does not apply when GNS is being used
2. Even though clustername and SCAN name is set to the same during 'typical' installation, changing SCAN name will not affect clustername as change of clustername requires deconfigure and reconfigure of the entire cluster.

SOLUTION

 

A. To update SCAN setting

1. As per documentation "Oracle Grid Infrastructure Installation Guide", Oracle strongly recommend to configure SCAN name in either DNS or GNS as /etc/hosts file can only resolve to one IP address.

SCAN IP must be in same subnet as public and VIP. If the new SCAN IP will be in different subnet, refer to note 276434.1 to change nodeapps/network resource first. 

1a. If you intend to use /etc/hosts for SCAN name resolution, the same and only entry for SCAN name must exist on all nodes. 

1b. If you intend to use DNS for SCAN name resolution, remove entries for SCAN name from /etc/hosts on all nodes, and make sure nslookup returns good result on all nodes, for example:

2. Once #1a or #1b is configured properly, execute the following to modify:

If name resolution for SCAN is being switched from local hosts file to DNS, be sure to remove SCAN name in local hosts file on all nodes prior to execute below commands. 

2.1. To modify SCAN name or SCAN VIP addresses:

2.1.1. As grid user stop resources:

2.1.2. As root user modify SCAN:

Once SCAN name is changed, update database init.ora/spfile parameter remote_listener to the new one.

2.1.3. As grid user modify and start resources:

2.1.4. To confirm the change

2.2. To change SCAN to be on second network:

By default, SCAN will be configured on first public network (ora.net1.network), however in multiple public network environment, SCAN can run on second or other network.

There's no option to modify SCAN to use non-first network, to change to second or other network, scan_listener and scan resources need to be removed and added back.

In this example, we'll move SCAN from net1 to net2

2.2.1. As grid user stop resources and remove scan_listener:

2.2.2. As root user remove and add SCAN:

Once SCAN name is changed, update database init.ora/spfile parameter remote_listener to the new one.

2.2.3. As grid user add scan_listener and start resources:

B. To modify SCAN listener port

As grid user:

1. Modify SCAN listener port:

Update 11gR2 database init.ora parameter: alter system set remote_listener='<SCAN-name>:<new-port-number>' scope=both;



2. Restart SCAN listener so the new port will be effective:

3. Confirm the change:

 

REFERENCES

NOTE:975457.1 - How to Troubleshoot Connectivity Issue with 11gR2 SCAN Name
NOTE:276434.1 - How to Modify Public Network Information including VIP in Oracle Clusterware
NOTE:887471.1 - PRVF-4664 PRVF-4657: Found inconsistent name resolution entries for SCAN name
NOTE:887522.1 - Grid Infrastructure Single Client Access Name (SCAN) Explained

NOTE:359277.1 - Changing Default Listener Port Number

小麥苗課程

小麥苗課堂開課啦，如下是現有的課程，歡迎諮詢小麥苗：

課程名稱	課時	上課時間	價格
OCP（從入門到專家）	每年1期，35課時左右/期	20：00-22：00	1588(可優惠)
OCM認證	每年N期，9課時/期	20：00-22：00	22888
高可用課程（rac+dg+ogg）	每年1期，20課時左右/期	20：00-22：00	1888(可優惠)
Oracle初級入門	每年1期，15課時左右/期	20：00-22：00	800
Oracle健康檢查指令碼	可微信或微店購買。		88
Oracle資料庫技能直通車	包含如下3個課程： ①《11g OCP網路課程培訓》（面向零基礎） 價值1600元 ②《11g OCM網路班課程培訓》（Oracle技能合集）價值10000+元 ③《RAC + DG + OGG 高可用網路班課程》 價值2000元 以上3個課程全部打包只要5888，只要5888所有課程帶回家，終身指導！所有課程都是線上講課，不是播放視訊，課件全部贈送！ 注意：以上OCP和OCM課程只包括培訓課程，不包括考試費用。OCM提供培訓+視訊，但是不提供練習環境和資料。報名一次，OCP和高可用的課程可以免費終身迴圈聽課。		5888
OCP+高可用（rac+dg+ogg）	報名OCP+高可用課程，可以優惠300元，優惠後的價格為3188.		3188(可優惠)

注意：

1、每次上課前30分鐘答疑。

2、OCM實時答疑，提供和考試一樣的練習模擬環境，只要按照老師講的方式來練習，可以保證100%通過。

3、授課方式：YY語音網路直播講課（非視訊） + QQ互動答疑 + 視訊複習。

4、OCP課時可以根據大家學習情況進行增加或縮減。

5、以上所有課程均可迴圈聽課。

6、12c OCM課程私聊。

7、Oracle初級入門課程，只教大家最實用+最常用的Oracle操作維護知識。

8、以上所有課程，可以加小麥苗微信（lhrbestxh）或QQ（646634621）詳聊，優惠多多。
 

培訓專案	連線地址
DB筆試面試歷史連線	http://mp.weixin.qq.com/s/Vm5PqNcDcITkOr9cQg6T7w
OCP培訓說明連線	https://mp.weixin.qq.com/s/2cymJ4xiBPtTaHu16HkiuA
OCM培訓說明連線	https://mp.weixin.qq.com/s/7-R6Cz8RcJKduVv6YlAxJA
高可用（RAC+DG+OGG）培訓說明連線	https://mp.weixin.qq.com/s/4vf042CnOdAD8zDyjUueiw
OCP最新題庫解析歷史連線（052）	http://mp.weixin.qq.com/s/bUgn4-uciSndji_pUbLZfA
微店地址	https://weidian.com/s/793741433?wfr=c&ifr=shopdetail

---

---

About Me

............................................................................................................................................. ● 本文作者：小麥苗，部分內容整理自網路，若有侵權請聯絡小麥苗刪除 ● 本文在itpub（http://blog.itpub.net/26736162/abstract/1/）、部落格園（http://www.cnblogs.com/lhrbest）和個人微信公眾號（xiaomaimiaolhr）上有同步更新 ● 本文itpub地址：http://blog.itpub.net/26736162/abstract/1/ ● 本文部落格園地址：http://www.cnblogs.com/lhrbest ● 本文pdf版、個人簡介及小麥苗雲盤地址：http://blog.itpub.net/26736162/viewspace-1624453/ ● 資料庫筆試面試題庫及解答：http://blog.itpub.net/26736162/viewspace-2134706/ ● DBA寶典今日頭條號地址：http://www.toutiao.com/c/user/6401772890/#mid=1564638659405826 ............................................................................................................................................. ● QQ群號：230161599（滿）、618766405 ● 微信群：可加我微信，我拉大家進群，非誠勿擾 ● 聯絡我請加QQ好友（646634621），註明新增緣由 ● 於 2018-07-01 06:00 ~ 2018-07-31 24:00 在魔都完成 ● 最新修改時間：2018-07-01 06:00 ~ 2018-07-31 24:00 ● 文章內容來源於小麥苗的學習筆記，部分整理自網路，若有侵權或不當之處還請諒解 ● 版權所有，歡迎分享本文，轉載請保留出處 ............................................................................................................................................. ● 小麥苗的微店：https://weidian.com/s/793741433?wfr=c&ifr=shopdetail ● 小麥苗出版的資料庫類叢書：http://blog.itpub.net/26736162/viewspace-2142121/ ● 小麥苗OCP、OCM、高可用網路班：http://blog.itpub.net/26736162/viewspace-2148098/ ............................................................................................................................................. 使用微信客戶端掃描下面的二維碼來關注小麥苗的微信公眾號（xiaomaimiaolhr）及QQ群（DBA寶典）、新增小麥苗微信，學習最實用的資料庫技術。    小麥苗的微信公眾號      小麥苗的DBA寶典QQ群2       小麥苗的微信二維碼          小麥苗的微店 .............................................................................................................................................

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/26736162/viewspace-2157372/，如需轉載，請註明出處，否則將追究法律責任。