昨天安装了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
防火墙全关了....还是不行...真没办法了....请大侠救命啊....
------解决方案--------------------
重新启动服务
重新启动监听
重新启动数据库
------解决方案--------------------
如需要阅读该回复，请登录或注册CSDN!