Ocm Configure Services With A Primary Instance And An Available Instance Jp
TAF Setup
#tnsnames.ora
# OLTP: t01 = prefer, t02 = availabel 
# OLAP: t01 = not use, t02 = prefer
 
OLTP_PRECONNECT =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = t01-vip)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = t02-vip)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = OLTP_PRECONNECT)
      (FAILOVER_MODE =
        (BACKUP = OLTP)
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )
 
OLAP =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = t01-vip)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = t02-vip)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = OLAP)
      (FAILOVER_MODE =
        (BACKUP = OLAP_PRECONNECT)
        (TYPE = SELECT)
        (METHOD = PRECONNECT)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )
 
OLAP_PRECONNECT =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = t01-vip)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = t02-vip)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = OLAP_PRECONNECT)
      (FAILOVER_MODE =
        (BACKUP = OLAP)
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )
 
OLTP =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = t01-vip)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = t02-vip)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = OLTP)
      (FAILOVER_MODE =
        (BACKUP = OLTP_PRECONNECT)
        (TYPE = SELECT)
        (METHOD = PRECONNECT)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
  )
-- check the connction
SELECT MACHINE, FAILOVER_TYPE, FAILOVER_METHOD, FAILED_OVER, COUNT(*)
FROM V$SESSION
GROUP BY MACHINE, FAILOVER_TYPE, FAILOVER_METHOD, FAILED_OVER;