DB 서버 IP 2개일 경우에 tnsnames세팅 예제

 DB 서버 IP 2개일 경우에 tnsnames세팅 예제

EPS_REAL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (LOAD_BALANCE = ON)
      (FAILOVER = YES)     
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.100.88.26)(PORT = 1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.100.88.27)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = EPS)
      (FAILOVER_MODE =
         (TYPE = SELECT)(METHOD = BASIC))
    )
  )