从D:\\oracle\\ora92\\network\\admin目录下找到tnsnames.ora
# TNSNAMES.ORA Network Configuration File: D:\\oracle\\ora92\\NETWORK\\ADMIN\\tnsnames.ora
# Generated by Oracle configuration tools.
TESTL001 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.159.8)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = testl001)
)
)
ZJYTEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.159.8)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = zjytest)
)
)
DUC08 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.159.8)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = duc08)
)
)
XC14 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.159.8)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = xc14)
)
)
AEC12 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.159.8)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = aec12)
)
)
AYC11 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.159.8)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ayc11)
)
)
VVC06 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.159.8)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = vvc06)
)
)
PACKC03 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.159.8)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = packc03)
)
)
ABC13=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.159.8)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = abc13)
)
)
NZC04=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.159.8)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = nzc04)
)
)
QCC16=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.159.8)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = qcc16)
)
)
QTC15=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.159.8)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = qtc15)
)
)
查看是否配置好了服务