急等！！！监听器服务已经启动，仍然报 无监听程序 错误

[xmisgenius]

监听器服务已经启动，客户端用pl/sql连接提示ora-12541 :tns:无监听程序
用lsnrctl
显示如下
c:\Users\Administrator>lsnrctl

SNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 17-11月
:28

opyright (c) 1991, 2010, Oracle. All rights reserved.

欢迎来到LSNRCTL, 请键入"help"以获得信息。

SNRCTL> status
正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=WIN-NM8EE5E9RF2)(
)
NS-12541: TNS: 无监听程序
TNS-12560: TNS: 协议适配器错误
TNS-00511: 无监听程序
64-bit Windows Error: 61: Unknown error
SNRCTL>

可有大侠知道怎么处理

[ning_wnn2014]

用tnsping 连接串名，测试一下通不通，如果通了则说明服务器的监听开启了。没通就在服务器端执行lcnrctl start ，开启监听。

[ffshao]

能把详细情况发一下嘛

[xmisgenius]

数据库是oracle 11.2.0 执行tnsping 结果如下：

C:\Users\Administrator>tnsping test

TNS Ping Utility for 64-bit Windows: Version 11.2.0.1.0 - Production on 18-11月-
2014 17:01:18

Copyright (c) 1997, 2010, Oracle.  All rights reserved.

已使用的参数文件:
D:\oracle11g\product\11.2.0\dbhome_1\NETWORK\ADMIN\sqlnet.ora


已使用 TNSNAMES 适配器来解析别名
尝试连接 (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.1
68.1.2)(PORT = 1521))) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = TEST)))
TNS-12541: TNS: 无监听程序

listener,ora内容如下

# listener.ora Network Configuration File: D:\oracle11g\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

DIRECT_HANDOFF_TTC_LISTENER = OFF
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = d:\oracle11g\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:d:\oracle11g\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
    (SID_DESC =
      (SID_NAME = CLRExtProc)
      (ORACLE_HOME = d:\oracle11g\product\11.2.0\dbhome_1)
      (PROGRAM = extproc)
      (ENVS = "EXTPROC_DLLS=ONLY:d:\oracle11g\product\11.2.0\dbhome_1\bin\oraclr11.dll")
    )
    (SID_DESC =
      (GLOBAL_DBNAME = TEST)
      (ORACLE_HOME = d:\oracle11g\product\11.2.0\dbhome_1)
      (SID_NAME = TEST)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.2)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

ADR_BASE_LISTENER = d:\oracle11g

sqlnet.ora内容如下： # sqlnet.ora Network Configuration File: D:\oracle11g\product\11.2.0\dbhome_1\NETWORK\ADMIN\sqlnet.ora # Generated by Oracle configuration tools. # This file is actually generated by netca. But if customers choose to # install "Software Only", this file wont exist and without the native # authentication, they will not be able to connect to the database on NT. SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT) ADR_BASE = d:\oracle11g\product\11.2.0\dbhome_1\log tnsnames.ora内容如下：

# tnsnames.ora Network Configuration File: d:\oracle11g\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

TEST =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.2)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = TEST)
    )
  )
ORACLR_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
    )
  )

lsnrctl命令结果如下：

C:\Users\Administrator>lsnrctl

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 18-11月-2014 17:2
9:56

Copyright (c) 1991, 2010, Oracle.  All rights reserved.

欢迎来到LSNRCTL, 请键入"help"以获得信息。

LSNRCTL> status
正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.55)(PORT=1521)))
TNS-12541: TNS: 无监听程序
 TNS-12560: TNS: 协议适配器错误
  TNS-00511: 无监听程序
   64-bit Windows Error: 61: Unknown error
正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521)))
TNS-01153: 未能处理字符串: 愲?
LSNRCTL>

listener\alert\log.xml内容如下：

<msg time='2014-11-18T17:41:51.241+08:00' org_id='oracle' comp_id='tnslsnr'
 type='UNKNOWN' level='16' host_id='WIN-tttt'
 host_addr='192.168.1.2>
 <txt>TNS-12560: TNS: 协议适配器错误
 TNS-00530: 协议适配器错误
  64-bit Windows Error: 53: Unknown error
   TNS-12518: TNS: 监听程序无法分发客户机连接
    TNS-12571: TNS: 包写入程序失败
     TNS-12560: TNS: 协议适配器错误
      TNS-00530: 协议适配器错误
       64-bit Windows Error: 54: Unknown error
 </txt>
</msg>

-----------------分割-------- 用sqlplus能正常登陆，执行相关操作 还需要什么信息的，尽管告诉我，有劳各位大虾大神了，都快疯了

[xmisgenius]

C:\Users\Administrator>lsnrctl 这里执行的ip应改成192.168.1.2，手误

[bw555]

这这个lsnrctl需要在服务器上查看的，本机监听起不起没啥关系

[xmisgenius]

是在服务器上执行的

[bw555]

执行lsnrctl start

[xmisgenius]

执行lsnrctl start就说名称监听程序已经启动

[xmisgenius]

分给我自己吧，已经解决了

[qq_33928908]

怎么解决的？？？？

[xmisgenius]

日志文件太大了，删除就行了

[qq_34603283]

我也遇到了同样的问题 你说的日志文件路径在哪啊？

[HQBUPT]

listener.log日志文件写满导致，删去即恢复正常。 参见：http://www.cnblogs.com/hanbo112/p/4583047.html