D:\oracle\product\10.2.0\client\NETWORK\ADMIN\tnsnames.ora
#内部测试环境中心库
CNCP.TEST.NC.CENTER =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.xxx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = centerdb)
)
)
#测试分站库1_内网地址
CNCP.TEST.NC.SUBSITE1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.xxx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = subdb1)
)
)
#测试分站库2_内网地址
CNCP.TEST.NC.SUBSITE2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.xxx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = subdb2)
)
)
CNPAY_TEST_DB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 61.xxx.xxx.xxx)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = mydb)
)
)
#内部测试环境中心库
CNCP.TEST.NC.CENTER =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.xxx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = centerdb)
)
)
#测试分站库1_内网地址
CNCP.TEST.NC.SUBSITE1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.xxx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = subdb1)
)
)
#测试分站库2_内网地址
CNCP.TEST.NC.SUBSITE2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.xxx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = subdb2)
)
)
CNPAY_TEST_DB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 61.xxx.xxx.xxx)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = mydb)
)
)