rac tnsnames

时间：2010-06-12 来源：drew

hso32 =
(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.145.10.10)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.145.10.11)(PORT = 1521))
    (load_balance=yes)
    (FAILOVER=ON)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = hso32)
      (FAILOVER_MODE =
        (TYPE = SELECT)
        (METHOD = BASIC)
        (RETRIES = 180)
        (DELAY = 5)
      )
    )
)

hso321 =
(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.145.10.10)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = hso32)
      (INSTANCE_NAME = hso321)
    )
)

hso322 =
(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.145.10.11)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = hso32)
      (INSTANCE_NAME = hso322)
    )
)

LISTENERS_hso32 =
(ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.145.10.10)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = 145.145.10.11)(PORT = 1521))
)

相关阅读更多 +