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)
)
)
QGMESP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.250.220)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = qgmesp)
)
)
FCEL2DB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.173.6)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = FCEL2DB)
)
)
Thickness =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.204.234)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = Thickness)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
QGLZMESL=
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = 10.3.247.33)
(PORT = 1521)
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = QGLZMESL)
)
)
QGLZMESD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.247.44)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = qglzmesd)
)
)
LZMESP=
(DESCRIPTION=
(LOAD_BALANCE=yes)
(ADDRESS_LIST=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=10.3.247.23)
(PORT=1521)
)
(ADDRESS=
(PROTOCOL=TCP)
(HOST=10.3.247.24)
(PORT=1521)
)
)
(CONNECT_DATA=
(SERVER=dedicated)
(SERVICE_NAME=lzmesdb)
)
)
LZREPORT =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.247.47)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = lzreport)
)
)
COMM_LZ_25 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.247.26)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = QGLZCOMMT)
)
)
qgoqsd =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.250.29)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = qgoqsd)
)
)
QGSXMESD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.3.198.134)(PORT = 1522))
)
(CONNECT_DATA =
(SERVICE_NAME = QGSXMESD)
)
)
QGSXMESP=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=10.3.250.192)
(PORT=1521)
)
(CONNECT_DATA=
(SERVER=dedicated)
(SERVICE_NAME=QGSXMESP)
)
)
GHMESPD=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=10.3.247.148)
(PORT=1521)
)
(CONNECT_DATA=
(SERVER=dedicated)
(SERVICE_NAME=GHMESPD)
)
)
怎么解决，小白，具体点，谢啦。
[解决办法]
错误的提示信息也不贴一下~~ - -
