Oracle 11.2 RAC改 Private IP步驟
>>背景:
資料庫割接時需要修改準生產的public IP 和VIP(期間會做與生產庫的網路隔離),為了保證期間DSG正常同步,需修改準生產Private IP和生產IP網段相同,已供DSG同步使用 。
現準生產Private IP :192.168.1.138 /139
需要調整為:192.168.140.115/116 192.168.140.138/139
參考文件:
How to Modify Private Network Information in Oracle Clusterware(文件 ID 283684.1)
1、檢查、保留原資訊
1.1、 $ cat /etc/hosts
132.78.140.138 cnzddb1
132.78.140.140 cnzddb1-vip
192.168.1.138 cnzddb1-priv
132.78.140.139 cnzddb2
132.78.140.141 cnzddb2-vip
192.168.1.139 cnzddb2-priv
132.78.140.142 cnzddb-cluster-scan
1.2、 心跳網路卡資訊
grid@cnzddb2:/home/grid> $GRID_HOME/bin/oifcfg getif
en6 132.78.140.128 global public
en7 192.168.1.128 global cluster_interconnect
1.3、 IP網路卡資訊:
admin1@cnzddb1:/home/admin1 >ifconfig -a
en6: flags=1e080863,c0<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,CHECKSUM_OFFLOAD(ACTIVE),LARGESEND,CHAIN>
inet 132.78.140.138 netmask 0xffffffe0 broadcast 132.78.140.159
inet 132.78.140.140 netmask 0xffffffe0 broadcast 132.78.140.159
inet 132.78.140.142 netmask 0xffffffe0 broadcast 132.78.140.159
tcp_sendspace 131072 tcp_recvspace 65536 rfc1323 0
en7: flags=1e080863,c0<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,CHECKSUM_OFFLOAD(ACTIVE),LARGESEND,CHAIN>
inet 192.168.1.138 netmask 0xffffffe0 broadcast 192.168.1.159
inet 169.254.165.70 netmask 0xffff0000 broadcast 169.254.255.255
tcp_sendspace 131072 tcp_recvspace 65536 rfc1323 0
lo0: flags=e08084b,c0<UP,BROADCAST,LOOPBACK,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,LARGESEND,CHAIN>
inet 127.0.0.1 netmask 0xff000000 broadcast 127.255.255.255
inet6 ::1%1/0
tcp_sendspace 131072 tcp_recvspace 131072 rfc1323 1
admin1@cnzddb2:/home/admin1 >ifconfig -a
en6: flags=1e080863,c0<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,CHECKSUM_OFFLOAD(ACTIVE),LARGESEND,CHAIN>
inet 132.78.140.139 netmask 0xffffffe0 broadcast 132.78.140.159
inet 132.78.140.141 netmask 0xffffffe0 broadcast 132.78.140.159
tcp_sendspace 131072 tcp_recvspace 65536 rfc1323 0
en7: flags=1e080863,c0<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,CHECKSUM_OFFLOAD(ACTIVE),LARGESEND,CHAIN>
inet 192.168.1.139 netmask 0xffffffe0 broadcast 192.168.1.159
inet 169.254.98.11 netmask 0xffff0000 broadcast 169.254.255.255
tcp_sendspace 131072 tcp_recvspace 65536 rfc1323 0
lo0: flags=e08084b,c0<UP,BROADCAST,LOOPBACK,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,LARGESEND,CHAIN>
inet 127.0.0.1 netmask 0xff000000 broadcast 127.255.255.255
inet6 ::1%1/0
tcp_sendspace 131072 tcp_recvspace 131072 rfc1323 1
2、停資料庫 && 修改OCR私有網路卡資訊
2.1、 停庫
$ srvctl stop database -d cnzddb
2.2、 修改OCR私有網路卡資訊:
#grid使用者
$GRID_HOME/bin/oifcfg setif -global en7/192.168.140.96:cluster_interconnect ##需要換算IP資料哪個段中
$GRID_HOME/bin/oifcfg delif -global en7/192.168.1.128
3、作業系統層面修改(以root使用者):
修改網路卡上的IP地址為新地址
修改/etc/hosts,全部對應新地址:
##$ cat /etc/hosts
132.78.140.138 cnzddb1
132.78.140.140 cnzddb1-vip
192.168.140.115 cnzddb1-priv
132.78.140.139 cnzddb2
132.78.140.141 cnzddb2-vip
192.168.140.116 cnzddb2-priv
132.78.140.142 cnzddb-cluster-scan
4、重啟crs && 資料庫
# crsctl stop crs
# crsctl disable crs
# crsctl enable crs
# crsctl start crs
$ srvctl start database -d cnzddb
注:2.2步的網段換算方法
--換算舉例:(115/116屬於96段!)
netmask 0xffffff e0
1 - e0 = 1- 1110 0000 = 0001 1111 = 31
即每32個地址為一個段,0~31,32~63,64~95,96~127,128~159 。。。
所以IP地址115/116 屬於 96~127,即96段:
$GRID_HOME/bin/oifcfg setif -global en7/192.168.140.96:cluster_interconnect ##需要換算IP資料哪個段中
資料庫割接時需要修改準生產的public IP 和VIP(期間會做與生產庫的網路隔離),為了保證期間DSG正常同步,需修改準生產Private IP和生產IP網段相同,已供DSG同步使用 。
現準生產Private IP :192.168.1.138 /139
需要調整為:192.168.140.115/116 192.168.140.138/139
參考文件:
How to Modify Private Network Information in Oracle Clusterware(文件 ID 283684.1)
1、檢查、保留原資訊
1.1、 $ cat /etc/hosts
132.78.140.138 cnzddb1
132.78.140.140 cnzddb1-vip
192.168.1.138 cnzddb1-priv
132.78.140.139 cnzddb2
132.78.140.141 cnzddb2-vip
192.168.1.139 cnzddb2-priv
132.78.140.142 cnzddb-cluster-scan
1.2、 心跳網路卡資訊
grid@cnzddb2:/home/grid> $GRID_HOME/bin/oifcfg getif
en6 132.78.140.128 global public
en7 192.168.1.128 global cluster_interconnect
1.3、 IP網路卡資訊:
admin1@cnzddb1:/home/admin1 >ifconfig -a
en6: flags=1e080863,c0<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,CHECKSUM_OFFLOAD(ACTIVE),LARGESEND,CHAIN>
inet 132.78.140.138 netmask 0xffffffe0 broadcast 132.78.140.159
inet 132.78.140.140 netmask 0xffffffe0 broadcast 132.78.140.159
inet 132.78.140.142 netmask 0xffffffe0 broadcast 132.78.140.159
tcp_sendspace 131072 tcp_recvspace 65536 rfc1323 0
en7: flags=1e080863,c0<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,CHECKSUM_OFFLOAD(ACTIVE),LARGESEND,CHAIN>
inet 192.168.1.138 netmask 0xffffffe0 broadcast 192.168.1.159
inet 169.254.165.70 netmask 0xffff0000 broadcast 169.254.255.255
tcp_sendspace 131072 tcp_recvspace 65536 rfc1323 0
lo0: flags=e08084b,c0<UP,BROADCAST,LOOPBACK,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,LARGESEND,CHAIN>
inet 127.0.0.1 netmask 0xff000000 broadcast 127.255.255.255
inet6 ::1%1/0
tcp_sendspace 131072 tcp_recvspace 131072 rfc1323 1
admin1@cnzddb2:/home/admin1 >ifconfig -a
en6: flags=1e080863,c0<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,CHECKSUM_OFFLOAD(ACTIVE),LARGESEND,CHAIN>
inet 132.78.140.139 netmask 0xffffffe0 broadcast 132.78.140.159
inet 132.78.140.141 netmask 0xffffffe0 broadcast 132.78.140.159
tcp_sendspace 131072 tcp_recvspace 65536 rfc1323 0
en7: flags=1e080863,c0<UP,BROADCAST,NOTRAILERS,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,CHECKSUM_OFFLOAD(ACTIVE),LARGESEND,CHAIN>
inet 192.168.1.139 netmask 0xffffffe0 broadcast 192.168.1.159
inet 169.254.98.11 netmask 0xffff0000 broadcast 169.254.255.255
tcp_sendspace 131072 tcp_recvspace 65536 rfc1323 0
lo0: flags=e08084b,c0<UP,BROADCAST,LOOPBACK,RUNNING,SIMPLEX,MULTICAST,GROUPRT,64BIT,LARGESEND,CHAIN>
inet 127.0.0.1 netmask 0xff000000 broadcast 127.255.255.255
inet6 ::1%1/0
tcp_sendspace 131072 tcp_recvspace 131072 rfc1323 1
2、停資料庫 && 修改OCR私有網路卡資訊
2.1、 停庫
$ srvctl stop database -d cnzddb
2.2、 修改OCR私有網路卡資訊:
#grid使用者
$GRID_HOME/bin/oifcfg setif -global en7/192.168.140.96:cluster_interconnect ##需要換算IP資料哪個段中
$GRID_HOME/bin/oifcfg delif -global en7/192.168.1.128
3、作業系統層面修改(以root使用者):
修改網路卡上的IP地址為新地址
修改/etc/hosts,全部對應新地址:
##$ cat /etc/hosts
132.78.140.138 cnzddb1
132.78.140.140 cnzddb1-vip
192.168.140.115 cnzddb1-priv
132.78.140.139 cnzddb2
132.78.140.141 cnzddb2-vip
192.168.140.116 cnzddb2-priv
132.78.140.142 cnzddb-cluster-scan
4、重啟crs && 資料庫
# crsctl stop crs
# crsctl disable crs
# crsctl enable crs
# crsctl start crs
$ srvctl start database -d cnzddb
注:2.2步的網段換算方法
--換算舉例:(115/116屬於96段!)
netmask 0xffffff e0
1 - e0 = 1- 1110 0000 = 0001 1111 = 31
即每32個地址為一個段,0~31,32~63,64~95,96~127,128~159 。。。
所以IP地址115/116 屬於 96~127,即96段:
$GRID_HOME/bin/oifcfg setif -global en7/192.168.140.96:cluster_interconnect ##需要換算IP資料哪個段中
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/27126919/viewspace-2123956/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle 11.2 RAC改IP步驟Oracle
- oracle 10g rac modify public ip,private ip,vip實驗步驟Oracle 10g
- Oracle RAC修改public,private,vip scan IPOracle
- 【RAC】如何修改 private ip
- ORACLE RAC OCFS(步驟簡要)Oracle
- Oracle RAC環境下vip/public/private IP的區別Oracle
- Oracle 11.2 DataGuard RAC To RAC搭建Oracle
- oracle 10.2.0.4 rac 升級到oracle 10.2.0.5 rac步驟Oracle
- oracle linux 11.2 rac grid infrastructure add scan ipOracleLinuxASTStruct
- 11 g rac 安裝 11.2步
- ping rac private ip地址不通處理
- rac更改public and private的網路卡和ip
- RAC中的各種IP-PUBLIC-VIP-Private-SCAN IP
- Oracle RAC叢集解除安裝步驟Oracle
- RAC改VIP和SCAN IP
- 手動進行oracle rac vip 漂移的步驟 。Oracle
- oracle 10g rac em重建實施步驟Oracle 10g
- RAC DATABASE關機步驟Database
- Oracle 11g RAC環境下Private IP修改方法及異常處理Oracle
- 【ASK_ORACLE】Relink RAC叢集詳細步驟Oracle
- Oracle10g RAC 關閉及啟動步驟Oracle
- 在aix oracle rac 環境下,增加lv的步驟AIOracle
- oracle 11.2.0.1 rac 的 active dataguard的啟動步驟Oracle
- oracle 11gR2 如何修改 private ipOracle
- Linux6RAC步驟Linux
- Oracle 11g rac 的 active dataguard的啟動步驟Oracle
- Oracle10g RAC 刪除節點步驟及原理Oracle
- aix 6.1+hacmp+ oracle 10g rac 安裝步驟AIACMOracle 10g
- oracle 10g rac hacmp 遷移到asm實驗步驟Oracle 10gACMASM
- zt_oracle rac private network cluster interconnectOracle
- redhat linux 11.2 rac grid infrastructure add scan ipRedhatLinuxASTStruct
- 【BUILD_ORACLE】Oracle RAC配置ASM Filter Driver(ASMFD)(二)詳細配置步驟UIOracleASMFilter
- oracle 11.2 rac應用不定時中斷Oracle
- ORACLE11GR2 RAC解除安裝ASM例項步驟OracleASM
- Oracle RAC 修改 IP 地址Oracle
- Oracle重建awr步驟Oracle
- oracle 安裝步驟Oracle
- oracle升級步驟Oracle