日期:2014-05-17  浏览次数:21371 次

plsql developer连接时提示ORA-12541: TNS:no listener
昨天安装了orcle10g时,用plsql developer还可以连入的,但今天重启后就出现了这个提示,用iSqlplus连接时用127.0.0.1/test可以连接(我是本机登入的),但直接输test或192.168.128.39/test (192.168.128.39是本机IP地址)也不行,也提示ORA-12541: TNS:no listener,我的listener.ora如下:
# listener.ora Network Configuration File: E:\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 = E:\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 = webserver)(PORT = 1521))
  )
  )
  )

试过用
tnsping 127.0.0.1正常
但用IP 192.168.128.39或 webserver连接出错提示如下:
TNS Ping Utility for 32-bit Windows: Version 10.1.0.2.0 - Production on 03-2月 -
2010 12:37:11

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

Used parameter files:
E:\oracle\product\10.1.0\Db_1\network\admin\sqlnet.ora

Used EZCONNECT adapter to resolve the alias
Attempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=webserver))(ADDRE
SS=(PROTOCOL=TCP)(HOST=192.168.128.39)(PORT=1521)))
TNS-12541: TNS:no listener

晕.....

用netstat查看端口
  Proto Local Address Foreign Address State
  TCP webserver:1047 webserver:1521 ESTABLISHED
  TCP webserver:1048 webserver:1521 ESTABLISHED
  TCP webserver:1521 webserver:1047 ESTABLISHED
  TCP webserver:1521 webserver:1048 ESTABLISHED
  TCP webserver:5152 webserver:1781 CLOSE_WAIT

防火墙全关了....还是不行...真没办法了....请大侠救命啊....

------解决方案--------------------
重新启动服务
重新启动监听

重新启动数据库
------解决方案--------------------