以下转自张乐奕的ppt:
1. 本机的tnsnames.ora设置为:
INTERTOL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.37.3.201)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.37.3.202)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.37.3.203)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.37.3.204)(PORT = 1521))
(LOAD_BALANCE = yes)
)
(CONNECT_DATA =
(SERVICE_NAME = intertol)
(FAILOVER_MODE=
(TYPE=SELECT)
(METHOD=BASIC))
)
)
[@more@]