昨天安装了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:11Copyright (c) 1997, 2003, Oracle. All rights reserved.Used parameter files:
E:\oracle\product\10.1.0\Db_1\network\admin\sqlnet.oraUsed 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防火墙全关了....还是不行...真没办法了....请大侠救命啊....
# 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:11Copyright (c) 1997, 2003, Oracle. All rights reserved.Used parameter files:
E:\oracle\product\10.1.0\Db_1\network\admin\sqlnet.oraUsed 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防火墙全关了....还是不行...真没办法了....请大侠救命啊....
要看tnsname.ora配置,确保配置没有问题
# Generated by Oracle configuration tools.TEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = webserver)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test)
)
)ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = webserver)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 10.1.0.2.0 - Produ
ction
Start Date 03-2月 -2010 08:55:03
Uptime 0 days 4 hr. 55 min. 13 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File E:\oracle\product\10.1.0\Db_1\network\admin\listener.o
ra
Listener Log File E:\oracle\product\10.1.0\Db_1\network\log\listener.logListening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROCipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=webserver)(PORT=8080))(Presentation=
HTTP)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=webserver)(PORT=2100))(Presentation=
FTP)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=webserver)(PORT=8080))(Presentation=
HTTP)(Session=RAW))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=webserver)(PORT=2100))(Presentation=
FTP)(Session=RAW))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
Instance "orcl", status READY, has 2 handler(s) for this service...
Service "test" has 1 instance(s).
Instance "test", status READY, has 1 handler(s) for this service...
Service "testXDB" has 1 instance(s).
Instance "test", status READY, has 1 handler(s) for this service...
The command completed successfully
sqlplus user/pwd@test
tnsping 192.168.128.39/test
tnsping 192.168.128.39:1521/test
也是报一样的错...但
tnsping 127.0.0.1
tnsping 127.0.0.1/test
tnsping 127.0.0.1:1521/test
就都说OK
ORA-12541: TNS:no listener
楼上的..有QQ吗?...加一下我好吗?.有几个问题想不通想请教
2.tnsping test看是否通,不通的话就参看tnsnames.ora
3.装了oracle后不要随便修改机器名和ip地址
tnsnames.ora在上面写了.
这句有问题..............修改为主机名字吧 HOST=主机名...................