lm**** wrote:short answer- yes ,you can but specify the scan name to take actual advantage of this feature.
Can i use mulitiple scan IP in TNS name like we use for VIP
text.test.com = (DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dg654-vip.autodesk.com)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = dg656-vip.autodesk.com)(PORT = 1521))
(LOAD_BALANCE = off)(CONNECT_DATA =(SERVER = DEDICATED)
(SERVICE_NAME = text.test.com)
(FAILOVER_MODE =(TYPE = SELECT)(METHOD = BASIC)
(RETRIES = 180)(DELAY = 5))))
TRLange wrote:The only issue I have seen in extensive testing, is that the 10g WILL use the first IP address returned from DNS. If that SCAN address is down, it may abort/error, however, if there is a retry, it will attempt to resolve the address again and would successfully connect to a surviving node. I have seen a application using the SCAN name only in 10g client successfully for more than a year now. While the docs (SCAN.pdf) say one thing, the reality is that it
The originator of this thread never mentioned what release of Oracle Client they are using to connect to the database.
I believe that Sebastian makes a valid point here when he says "(Pre 11.2 clients need all 3 SCAN IPs addresses in the connect string (tnsnames.ora) to use all SCAN IP adresses, since a 10g client cannot resolve the SCAN to 3 IP addresses)".
I use the same three SCAN IP address setup in my TNSNAMES.ORA entry, because I'm using a 10.2 client. So, onedbguru, is my SCAN understanding severely lacking as well? I would always want to understand the environment before criticizing.