Thursday, July 03, 2008

Oracle RAC TAF Tnsnames.ora client entry

This is the entry that works for me..

XXX =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 202.188.88.10)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 202.188.88.11)(PORT = 1521))
(FAILOVER = on)
(LOAD_BALANCE = on)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = xxx)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = PRECONNECT)
(RETRIES = 180)
(DELAY = 5)
)
)
)

No comments: