Oracle 11gR2 RAC修改SCAN IP地址
1、環境介紹
Oracle 11gR2 RAC 64bit
Oracle Enterprise Linux 5.7 64bit
2、/etc/hosts內容
192.168.1.201 jzh1.oracle.com jzh1
192.168.1.203 jzh2.oracle.com jzh2
10.10.10.201 jzh1-priv
10.10.10.203 jzh2-priv
192.168.1.202 jzh1-vip
192.168.1.204 jzh2-vip
192.168.1.205 jzh-cluster jzh-cluster-scan
Oracle 11gR2 RAC 64bit
Oracle Enterprise Linux 5.7 64bit
2、/etc/hosts內容
192.168.1.201 jzh1.oracle.com jzh1
192.168.1.203 jzh2.oracle.com jzh2
10.10.10.201 jzh1-priv
10.10.10.203 jzh2-priv
192.168.1.202 jzh1-vip
192.168.1.204 jzh2-vip
192.168.1.205 jzh-cluster jzh-cluster-scan
3、測試需求
將scan ip 192.168.1.205改為192.168.1.206
4、檢視當前scan ip狀態資訊 (需以root使用者執行)
[root@jzh1 bin]# ./srvctl config scan
SCAN name: jzh-cluster-scan, Network: 1/192.168.1.0/255.255.255.0/eth0
SCAN VIP name: scan1, IP: /jzh-cluster-scan/192.168.1.205
5、以root使用者停止scan_listener,scan ip服務
[root@jzh1 bin]# ./srvctl stop scan_listener
[root@jzh1 bin]# ./srvctl stop scan
[root@jzh1 bin]# ./srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is not running
6、在所有節點/etc/hosts檔案中修改新scan ip地址
192.168.1.201 jzh1.oracle.com jzh1
192.168.1.203 jzh2.oracle.com jzh2
10.10.10.201 jzh1-priv
10.10.10.203 jzh2-priv
192.168.1.202 jzh1-vip
192.168.1.204 jzh2-vip
192.168.1.206 jzh-cluster jzh-cluster-scan
7、以root使用者修改scan ip
[root@jzh1 bin]# ./srvctl modify scan -n 192.168.1.206
8、修改後確認
[root@jzh1 bin]# ./srvctl config scan
SCAN name: 192.168.1.206, Network: 1/192.168.1.0/255.255.255.0/eth0
SCAN VIP name: scan1, IP: /192.168.1.206/192.168.1.206
可以看到已經修改過來了。
9、啟動scan_listener,scan
[root@jzh1 bin]# ./srvctl start scan
[root@jzh1 bin]# ./srvctl start scan_listener
10、進行ping測試
[root@jzh1 bin]# ping 192.168.1.206
PING 192.168.1.206 (192.168.1.206) 56(84) bytes of data.
64 bytes from 192.168.1.206: icmp_seq=1 ttl=64 time=1.78 ms
64 bytes from 192.168.1.206: icmp_seq=2 ttl=64 time=1.23 ms
64 bytes from 192.168.1.206: icmp_seq=3 ttl=64 time=0.444 ms
64 bytes from 192.168.1.206: icmp_seq=4 ttl=64 time=0.512 ms
64 bytes from 192.168.1.206: icmp_seq=5 ttl=64 time=0.891 ms
11、確認scan,scan_listener.ora狀態
[grid@jzh1 ~]$ crs_stat -t | grep scan
ora.scan1.vip ora....ip.type ONLINE ONLINE jzh2
[grid@jzh1 ~]$ crs_stat -t | grep lsnr
ora....ER.lsnr ora....er.type ONLINE ONLINE jzh1
ora....N1.lsnr ora....er.type ONLINE ONLINE jzh2
ora....H1.lsnr application ONLINE ONLINE jzh1
ora....H2.lsnr application ONLINE ONLINE jzh2
修改scan ip無需停止資料庫例項,asm或crs。
將scan ip 192.168.1.205改為192.168.1.206
4、檢視當前scan ip狀態資訊 (需以root使用者執行)
[root@jzh1 bin]# ./srvctl config scan
SCAN name: jzh-cluster-scan, Network: 1/192.168.1.0/255.255.255.0/eth0
SCAN VIP name: scan1, IP: /jzh-cluster-scan/192.168.1.205
5、以root使用者停止scan_listener,scan ip服務
[root@jzh1 bin]# ./srvctl stop scan_listener
[root@jzh1 bin]# ./srvctl stop scan
[root@jzh1 bin]# ./srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is not running
6、在所有節點/etc/hosts檔案中修改新scan ip地址
192.168.1.201 jzh1.oracle.com jzh1
192.168.1.203 jzh2.oracle.com jzh2
10.10.10.201 jzh1-priv
10.10.10.203 jzh2-priv
192.168.1.202 jzh1-vip
192.168.1.204 jzh2-vip
192.168.1.206 jzh-cluster jzh-cluster-scan
7、以root使用者修改scan ip
[root@jzh1 bin]# ./srvctl modify scan -n 192.168.1.206
8、修改後確認
[root@jzh1 bin]# ./srvctl config scan
SCAN name: 192.168.1.206, Network: 1/192.168.1.0/255.255.255.0/eth0
SCAN VIP name: scan1, IP: /192.168.1.206/192.168.1.206
可以看到已經修改過來了。
9、啟動scan_listener,scan
[root@jzh1 bin]# ./srvctl start scan
[root@jzh1 bin]# ./srvctl start scan_listener
10、進行ping測試
[root@jzh1 bin]# ping 192.168.1.206
PING 192.168.1.206 (192.168.1.206) 56(84) bytes of data.
64 bytes from 192.168.1.206: icmp_seq=1 ttl=64 time=1.78 ms
64 bytes from 192.168.1.206: icmp_seq=2 ttl=64 time=1.23 ms
64 bytes from 192.168.1.206: icmp_seq=3 ttl=64 time=0.444 ms
64 bytes from 192.168.1.206: icmp_seq=4 ttl=64 time=0.512 ms
64 bytes from 192.168.1.206: icmp_seq=5 ttl=64 time=0.891 ms
11、確認scan,scan_listener.ora狀態
[grid@jzh1 ~]$ crs_stat -t | grep scan
ora.scan1.vip ora....ip.type ONLINE ONLINE jzh2
[grid@jzh1 ~]$ crs_stat -t | grep lsnr
ora....ER.lsnr ora....er.type ONLINE ONLINE jzh1
ora....N1.lsnr ora....er.type ONLINE ONLINE jzh2
ora....H1.lsnr application ONLINE ONLINE jzh1
ora....H2.lsnr application ONLINE ONLINE jzh2
修改scan ip無需停止資料庫例項,asm或crs。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10271187/viewspace-1478341/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle 11gR2 RAC修改SCAN IPOracle
- Oracle RAC修改public, VIP, SCAN IPOracle
- Oracle RAC 修改 IP 地址Oracle
- Oracle RAC修改Scan IP,Public IP的方法Oracle
- Oracle 11g修改RAC SCAN IPOracle
- Oracle RAC修改public,private,vip scan IPOracle
- oracle 11gR2 修改 DNS 方式 SCAN IPOracleDNS
- 【RAC】如何修改SCAN IP的IP地址、名稱、埠等資訊
- 修改grid scan ip地址
- Oracle RAC修改IP和VIP地址Oracle
- RAC修改IP地址
- oracle 11gR2 如何修改scan vip 地址 /etc/hosts方式Oracle
- 11gr2 rac改IP系列之三:修改SCAN IP為同網段其它IP
- 11gR2 RAC修改IP
- 【RAC】Oracle rac修改IP地址及埠號命令參考Oracle
- oracle 11gR2 scan ip (DNS模式)OracleDNS模式
- 修改scan ip
- oracle 11g rac 修改VIP、scan VIP、priv IP操作文件Oracle
- Oracle 11gr2修改RAC叢集的scan ip,並處理ORA-12514問題Oracle
- RAC重建SCAN IP
- RAC 增加SCAN IP
- Oracle 11G 修改scan_ipOracle
- 11g RAC 修改PUBLIC-IP、VIP、PRIV-IP、SCAN-IP
- Oracle RAC中的Public IP, VIP和Internal IP,SCANOracle
- oracle 11gR2 如何修改public ipOracle
- oracle 11gR2 如何修改 private ipOracle
- Solaris下修改RAC環境節點IP地址
- RAC改VIP和SCAN IP
- 修改RAC 地址
- 11gr2 rac改IP系列之四:修改私網IP為其它IP
- ORACLE RAC 環境下修改IPOracle
- Oracle9i RAC 修改IPOracle
- Oracle 11g RAC SCAN ip的原理及配置Oracle
- RAC修改叢集兩個節點public ip地址
- rac 手動漂移scan ip vip
- Oracle 11g RAC 叢集 SCAN IP Listener說明Oracle
- 11gr2 rac改IP系列之一:修改公網IP為同網段其它IP
- RAC_網路_VIP漂移_SCAN IP