在ORACLE 9i RAC 環境下,為了做到高可用性,需要對客戶端的tnsnames.ora這個檔案進行配置,在oracle中這樣的配置叫做TAF,這個配置不能使用NETCA配置程式生成。其中ORA是RAC資料庫的資料庫名,另外,各個不同的節點的例項名分別為ORA1和ORA2,以下配置中的兩個連線配置分別互為備份,切換時間為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 9i和oracle 10g。