Dear All,
In earlier versions, for 2-Node Oracle RAC, we used to use the connection string (in tnsnames.ora) like:
<TNS Name> =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = VIP-Node1)(PORT = <PortNumber>))
(ADDRESS = (PROTOCOL = TCP)(HOST = VIP-Node2)(PORT = <PortNumber>))
(LOAD_BALANCE = yes)
)
(CONNECT_DATA =
(SERVICE_NAME = <ServiceName>)
)
)
Now with Oracle 11g RAC, we have SCAN in place; how the TNS Entry will look like? Will it be like:
<TNS Name> =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = SCAN Name)(PORT = <PortNumber>))
)
(CONNECT_DATA =
(SERVICE_NAME = <ServiceName>)
)
)
Regards,
Muhammad Riaz