1.cmd窗口中执行:lsnrctl status
报出“监听程序不支持服务”
原因:D:\Oracle\install\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora丢失……
于是从其他电脑复制一个,重新启动监听,问题解决,下面是好的listener.ora
# listener.ora Network Configuration File: D:\Oracle\install\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = ORCL)
(SID_NAME = ORCL)
)
)
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
2.检查监听器状态:
C:\Users>lsnrctl status
LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 29-10月-2014 16:28:50
Copyright (c) 1991, 2010, Oracle. All rights reserved.
正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))
TNS-12541: TNS: 无监听程序
TNS-12560: TNS: 协议适配器错误
TNS-00511: 无监听程序
64-bit Windows Error: 61: Unknown error
3.尝试登陆本地数据库:
C:\Users>sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on 星期三 10月 29 16:30:23 2014