萬盛學電腦網

您现在的位置: 萬盛學電腦網 >> 程式設計 >  >> 資料庫 >> Oracle 教學

Oracle 10g RAC 網路配置完整實戰:hosts、listener.ora、tnsnames.ora、VIP 故障轉移

環境規劃(兩節點)

用途Node 1Node 2
Public IP (應用連線)172.16.19.11172.16.19.12
VIP (故障轉移)172.16.19.211172.16.19.212
Private Interconnect192.168.18.11192.168.18.12
Heartbeat192.168.19.11192.168.19.12
Hostnamedb210-rac1db210-rac2

/etc/hosts 完整範例

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.ora (Node 1 範例)

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 隨之服務,實現透明故障轉移。

tnsnames.ora (Client 端通用)

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))
  )

關鍵參數解析

  • `LOAD_BALANCE = yes`:Client 隨機挑選 Address,達到連線負載均衡。
  • `FAILOVER_MODE`:`TYPE=SELECT` 只對查詢故障轉移;`METHOD=BASIC` 重新建立連線;`RETRIES=180, DELAY=5` → 最多重試 15 分鐘。
  • `INSTANCE_NAME`:指定具體 Instance,用於管理操作(如 `SRVCTL`)。

驗證清單

  1. 兩節點 `lsnrctl status LISTENER_DB210-RAC1/2` 均顯示 `READY`。
  2. Client `tnsping EYGLE` 成功、SQL*Plus 連線正常。
  3. 模擬 Node 1 關機 → VIP 飄移至 Node 2 → Client 現有查詢在 `RETRIES/DELAY` 內自動重連成功。

結語

RAC 網路配置核心在於 **VIP + Listener 綁定 VIP + Client 端 LOAD_BALANCE/FAILOVER**。照著 hosts/listener/tnsnames 三檔案對照修改,再做一次故障轉移演練,即可交付高可用 RAC 環境。

copyright © 萬盛學電腦網 all rights reserved