还是监听问题

显示全部楼层 · 2007-5-25 20:05:13

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /oracle/app/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /oracle/app/oracle/oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=gw151.mimoclub)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
TNS-12547: TNS:lost contact
TNS-12560: TNS

rotocol adapter error
TNS-00517: Lost contact
Linux Error: 104: Connection reset by peer
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS

rotocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused

google了很多，但是还是没有解决？大家给点意见
开始的时候数据库监听就起不来，我自己又重新安装了一遍还是不行。谢谢

千问 · 2007-5-25 20:05:13

lsnrctl start报什么错了

千问 · 2007-5-25 20:05:13

协议匹配错误你用IP地址试试看

千问 · 2007-5-25 20:05:13

监听问题是个麻烦问题

千问 · 2007-5-25 20:05:13

[oracle@oracle bin]$ ./lsnrctl start

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 17-OCT-2007 16:44:21

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

Starting /oracle/app/oracle/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /oracle/app/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /oracle/app/oracle/oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=202.130.137.151)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
TNS-12547: TNS:lost contact
TNS-12560: TNS

rotocol adapter error
TNS-00517: Lost contact
Linux Error: 104: Connection reset by peer
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=202.130.137.151)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS

rotocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused

千问 · 2007-5-25 20:05:13

我这个是刚刚重新安装的oracle

千问 · 2007-5-25 20:05:13

最初由 xiaomi_1006 发布
[B][oracle@oracle bin]$ ./lsnrctl start

LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 17-OCT-2007 16:44:21

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

Starting /oracle/app/oracle/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.1.0 - Production
System parameter file is /oracle/app/oracle/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /oracle/app/oracle/oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC0)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=202.130.137.151)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
TNS-12547: TNS:lost contact
TNS-12560: TNS

rotocol adapter error
TNS-00517: Lost contact
Linux Error: 104: Connection reset by peer
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=202.130.137.151)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS

rotocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused [/B]
检查linux是否开了防火墙（或者叫IP过滤）！有可能是主机阻塞了1521端口。

千问 · 2007-5-25 20:05:13

我的防火墙是关着的！

千问 · 2007-5-25 20:05:13

关键还是配置文件！监听器没有这么多问题吧！我都从来没有在监听器上碰到过问题！