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 RAC修改public, VIP, SCAN IPOracle
- Oracle RAC修改Scan IP,Public IP的方法Oracle
- Oracle 11gr2修改RAC叢集的scan ip,並處理ORA-12514問題Oracle
- 【RAC】如何修改SCAN IP的IP地址、名稱、埠等資訊
- RAC修改IP地址
- 【RAC】Oracle rac修改IP地址及埠號命令參考Oracle
- RAC 增加SCAN IP
- Oracle 11G 修改scan_ipOracle
- 11g RAC 修改PUBLIC-IP、VIP、PRIV-IP、SCAN-IP
- Oracle 11g RAC SCAN ip的原理及配置Oracle
- Oracle 12.2 RAC修改public ip address或public ip(subnet (netmask) or interface)Oracle
- oracle rac scan監聽更改埠號Oracle
- Oracle RAC 11gR2開啟歸檔Oracle
- 更改rac scanIP IP的地址
- 【RAC】Oracle RAC如何修改心跳網路Oracle
- ORACLE 11GR2 RAC的網路規劃解析Oracle
- oracle rac的scan監聽狀態Not All Endpoints RegisteredOracle
- 【RAC】Oracle rac 如何修改公網及vipOracle
- ubuntu系統 IP地址修改Ubuntu
- ubuntu22.04修改IP地址Ubuntu
- CentOS8修改IP地址CentOS
- 【NETWORK】Oracle RAC 心跳地址配置說明Oracle
- 如何修改 Rancher Server 的 IP 地址Server
- 新增SCAN IP
- Oracle 12C ORA-12545 While Connecting to RAC through SCAN NameOracleWhile
- 11gR2 RAC convert ONENODE
- 11gR2 OneNode Convert RAC
- Oracle RAC修改引數檔案位置Oracle
- Linux IP地址修改與配置問題Linux
- Oracle 11gR2 RAC 單網路卡轉雙網路卡繫結配置Oracle
- win10 ip地址怎麼設定_win10修改ip地址的方法Win10
- ubuntu修改mac地址及配置靜態ipUbuntuMac
- Oracle 11gR2 RAC 叢集服務啟動與關閉總結Oracle
- 修改IP地址選擇高質量IP波段選用技巧!
- Oracle Rac 修改SGA_TARGET值無變化Oracle
- 學習hadoop01-- 修改IP地址問題Hadoop
- win10怎麼修改ip_WIN10如何改ip地址Win10
- 11gR2 RAC新增節點步驟
- Oracle RAC修改網路配置知識點彙總Oracle