ORA-12154问题
我用SQL登陆数据库时报了ORA-12154的问题,在网上看了一些解决方法,看不懂。希望大侠们给指点一下!
这个是监听:
# listener.ora Network Configuration File: d:\oracle\product\10.1.0\Db_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\oracle\product\10.1.0\Db_1)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = PC-201206131517)(PORT = 1521))
)
)
)
这个是tns:
# tnsnames.ora Network Configuration File: D:\oracle\product\10.1.0\Db_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
ZLSJDBP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.250.97)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ZLSJDBP)
)
)
TE =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.250.224)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = TE)
)
)
GHMESQ =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.250.85)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ghmesq)
)
)
GHMESP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.250.82)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ghmesp)
)
)
COMM23 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.250.94)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = COMM23)
)
)
QGREPORT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.250.193)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = qgreport)
)
)
QGMESP2160 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.250.220)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = QGMESP)
)
)
TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = DELL-91011216)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
<