Database - RAC/Scalability (MOSC)

MOSC Banner

SCAN and TNSNAMES entry

edited Mar 1, 2013 9:46AM in Database - RAC/Scalability (MOSC) 4 commentsAnswered
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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center