tnsnames TAF entry on the client side
I have a production RAC system with a database named DTBS, instances DTBS1 and DTBS2.
Here is the entire tnsnames.ora file from the RAC nodes, and you can see how TAF entry is configured:
DTBS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1-cc1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2-cc1-vip)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DTBS)
)
)
DTBS2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac2-cc1-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DTBS)
(INSTANCE_NAME = DTBS2)
)
)
DTBS1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = rac1-cc1-vip)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = DTBS)