ORA-12154: TNS:无法解析指定的连接标志符和ERROR - ORA-12541: TNS:no listener 请问如何解决?
我在XP上装完数据库,当时可以用SQL PLUS登陆
但是重新启动机器后,就不能用SQL PLUS登陆了,提示
ORA-12154: TNS:无法解析指定的连接标志符
数据库应该是启动的,在任务里面能看到.
今天启动用SYSTEM用户用SQL PLUS登陆时,又报 ERROR - ORA-12541: TNS:no listener
tnsnames.ora文件内容如下
# tnsnames.ora Network Configuration File: D:\oracleDB\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = liz)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = ORCL)
(PRESENTATION = RO)
)
)
listener.ora文件的内容如下
# listener.ora Network Configuration File: D:\oracleDB\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = orcl)
(ORACLE_HOME = D:\oracleDB)
(PROGRAM = extproc)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = liz)(PORT = 1521))
)
)
)
sqlnet.ora文件内容如下
# sqlnet.ora Network Configuration File: D:\oracleDB\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.
SQLNET.AUTHENTICATION_SERVICES= (NTS)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
我用lsnrctl start 显示下面的信息
C:\Documents and Settings\user>lsnrctl start
LSNRCTL for 32-bit Windows: Version 10.1.0.2.0 - Production on 18-6月 -2009 12:0
1:28
Copyright (c) 1991, 2004, Oracle. All rights reserved.
Starting tnslsnr: please wait...
Service OracleOraDb10g_home1TNSListener already running.
TNS-12560: TNS:protocol adapter error
TNS-00530: Protocol adapter error
32-bit Windows Error: 1056: Unknown error
请高手帮忙看看是什么地方出错了,详细指点一下具体怎么修改。