首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫

Oracle 10g RAC 網絡配置詳解:Hosts、Listener、TNS 三層架構

     編輯:Oracle 資料庫相關知識

1. /etc/hosts 規劃四網段

127.0.0.1 localhost
172.16.19.11 db210-rac1 db210-rac1.hurray.com.cn
172.16.19.211 db210-rac1vip db210-rac1vip.hurray.com.cn # 公網 VIP
192.168.18.11 db210-rac1priv db210-rac1priv.hurray.com.cn # 私網互聯
192.168.19.11 db210-rac1hb db210-rac1hb.hurray.com.cn # 心跳網
... rac2 節點對應 .12/.212/.12/.12

2. Listener.ora 綁定 VIP

LISTENER_DB210-RAC1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST = (ADDRESS = (PROTOCOL=TCP)(HOST=db210-rac1vip)(PORT=1521)(IP=FIRST)))
(ADDRESS_LIST = (ADDRESS = (PROTOCOL=TCP)(HOST=172.16.19.11)(PORT=1521)(IP=FIRST)))
(ADDRESS_LIST = (ADDRESS = (PROTOCOL=IPC)(KEY=EXTPROC)))
)
)

3. TNSNAMES.ORA 負載均衡與故障轉移

EYGLE = (DESCRIPTION =
(ADDRESS = (PROTOCOL=TCP)(HOST=db210-rac1vip)(PORT=1521))
(ADDRESS = (PROTOCOL=TCP)(HOST=db210-rac2vip)(PORT=1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER=DEDICATED)(SERVICE_NAME=eygle)
(FAILOVER_MODE = (TYPE=SELECT)(METHOD=BASIC)(RETRIES=180)(DELAY=5))
)
)

VIP 故障自動遷移,SCAN IP 簡化客戶端配置(11g+ 引入)。

  1. 上一篇文章:
  2. 下一篇文章:
Copyright © 程式碼之家 All Rights Reserved