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
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)))
)
)
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+ 引入)。