Tuesday, September 24, 2013

FAILOVER TNS ENTRY IN RAC ENVIRONMENT

orcl =
 (DESCRIPTION =
 (ADDRESS = (PROTOCOL = TCP)(HOST = orcl1-vip)(PORT = 1521))
 (ADDRESS = (PROTOCOL = TCP)(HOST = orcl2-vip)(PORT = 1521))
 (LOAD_BALANCE = yes)
 (CONNECT_DATA =
 (SERVER = DEDICATED)
 (SERVICE_NAME = orcl)
 (FAILOVER = ON)(FAILOVER_MODE = (TYPE = SELECT)
 (METHOD = BASIC)(RETRIES = 120)(DELAY = 3)
   )
   )
  )