SCAN and TNSNAMES entry
We have installed a 2 node 11.2.0.3 RAC on Windows 2008
We have configured SCAN using DNS
Prior to 11g R2, we had 10g RAC and the applications were using the following connection information to connect to the database
APPS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = NODE-1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = NODE-2)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = apps)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 180)
(DELAY = 5)
)
)
)
Now, with SCAN, do we need to change the above connection properties?
If yes, how and what would be the advantage of using SCAN instead of the above that
we currently use?
We have configured SCAN using DNS
Prior to 11g R2, we had 10g RAC and the applications were using the following connection information to connect to the database
APPS =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = NODE-1)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = NODE-2)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = apps)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 180)
(DELAY = 5)
)
)
)
Now, with SCAN, do we need to change the above connection properties?
If yes, how and what would be the advantage of using SCAN instead of the above that
we currently use?
0