ORACLE 9i RAC 環境下,為了做到高可用性,需要對客戶端的tnsnames.ora這個檔案進行配置,在oracle中這樣的配置叫做TAF,這個配置不能使用NETCA配置程式生成。其中ORARAC資料庫的資料庫名,另外,各個不同的節點的例項名分別為ORA1ORA2,以下配置中的兩個連線配置分別互為備份,切換時間為5秒。
以下所示為配置示例。

 

ORA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.13)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.14)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ORA)
      (INSTANCE_NAME = ORA1)
      (INSTANCE_ROLE = PRIMARY)
      (FAILOVER_MODE =
        (BACKUP = ORA_BACKUP)
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 30)
        (DELAY = 5)
      )
    )
  )

 

ORA_BACKUP =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.14)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.13)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ORA)
      (INSTANCE_NAME = ORA2)
      (INSTANCE_ROLE = PRIMARY)
      (FAILOVER_MODE =
        (BACKUP = ORA)
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 30)
        (DELAY = 5)
      )
    )
  )
在以上示例中所標紅部分為TNS的別名及備份TNS別名,可按使用者應用的需要自行修改。
    在以上示例中所標藍部分,分別為RAC資料庫的服務名和各節點的例項名,可按節點數量的不同及服務名的不同自行修改。
       此配置適用於oracle 9ioracle 10g