| 用途 | Node 1 | Node 2 |
|---|---|---|
| Public IP (應用連線) | 172.16.19.11 | 172.16.19.12 |
| VIP (故障轉移) | 172.16.19.211 | 172.16.19.212 |
| Private Interconnect | 192.168.18.11 | 192.168.18.12 |
| Heartbeat | 192.168.19.11 | 192.168.19.12 |
| Hostname | db210-rac1 | db210-rac2 |
127.0.0.1 localhost
# Node 1
172.16.19.11 db210-rac1 db210-rac1.hurray.com.cn loghost
172.16.19.211 db210-rac1vip db210-rac1vip.hurray.com.cn
192.168.18.11 db210-rac1priv db210-rac1priv.hurray.com.cn
192.168.19.11 db210-rac1hb db210-rac1hb.hurray.com.cn
# Node 2
172.16.19.12 db210-rac2 db210-rac2.hurray.com.cn
172.16.19.212 db210-rac2vip db210-rac2vip.hurray.com.cn
192.168.18.12 db210-rac2priv db210-rac2priv.hurray.com.cn
192.168.19.12 db210-rac2hb db210-rac2hb.hurray.com.cn
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)))
)
)
關鍵:`HOST = db210-rac1vip` 綁定 VIP,節點故障時 VIP 自動飄移到存活節點,Listener 隨之服務,實現透明故障轉移。
EYGLE1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db210-rac1vip)(PORT = 1521))
(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = eygle)(INSTANCE_NAME = eygle1))
)
EYGLE2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db210-rac2vip)(PORT = 1521))
(CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = eygle)(INSTANCE_NAME = eygle2))
)
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))
)
)
LISTENERS_EYGLE =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = db210-rac1vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = db210-rac2vip)(PORT = 1521))
)
RAC 網路配置核心在於 **VIP + Listener 綁定 VIP + Client 端 LOAD_BALANCE/FAILOVER**。照著 hosts/listener/tnsnames 三檔案對照修改,再做一次故障轉移演練,即可交付高可用 RAC 環境。