Database - RAC/Scalability (MOSC)

MOSC Banner

FAILOVER clause in tnsnames entry

edited Jul 20, 2013 1:14AM in Database - RAC/Scalability (MOSC) 1 commentAnswered
Hi,

We have a 11g RAC database. 11.2.0.3 to be precise.
There are 2 nodes

We have the following tnsnames entry to connect to this database using "TEST" service


TEST =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.10)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.10.11)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = test.db.net)
      (FAILOVER_MODE =
              (TYPE = SELECT)
              (METHOD = BASIC)
              (RETRIES = 180)
              (DELAY = 5)
      )
    )
  )


The properties of "TEST" service are as below

Service name: test
Service is enabled
Server pool: PROD_test
Cardinality: 2
Disconnect: false
Service role: PRIMARY
Management policy: AUTOMATIC
DTP transaction: false
AQ HA notifications: false
Failover type: SELECT
Failover method: BASIC
TAF failover retries: 180

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