客户端配置文件tnsname.ora

ARP2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 182.168.1.173)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 182.168.1.174)(PORT = 1521))
(LOAD_BALANCE = yes)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = arp2.zdyf.com)
)
)

ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ZDYF-KF-PC)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)

客户端配置文件tnsname.ora

原文：http://www.cnblogs.com/kuailewangzi1212/p/4040809.html