论坛徽章:: 0

电梯直达

1楼 [收藏(0)] [报告]

发表于 2006-03-13 11:24 |只看该作者 |倒序浏览

System parameter file is /usr1/ora9i/product/9.2.0/network/admin/listener.ora
Log messages written to /usr1/ora9i/product/9.2.0/network/log/listener.log
Trace information written to /usr1/ora9i/product/9.2.0/network/trace/listener.tr
c
Trace level is currently 0

Started with pid=22457
Error listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
TNS-12542: TNS:address already in use
TNS-12560: TNS:protocol adapter error
TNS-00512: Address already in use
Linux Error: 98: Address already in use
13-MAR-2006 10:48:32 * 12502
TNS-12502: TNS:listener received no CONNECT_DATA from client

这是怎么回事?

文库|博客

blue_stone

荣誉版主

论坛徽章:: 0

2楼 [报告]

发表于 2006-03-13 13:21 |只看该作者

监听已经启动了吧
先用lsnrctl stat看一下当前监听程序的状态

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

caribe

丰衣足食

论坛徽章:: 0

3楼 [报告]

发表于 2006-03-13 14:28 |只看该作者

客户端的问题，打开日志可以看到。。。

实战分享：从技术角度谈机器学习入门| 【大话IT】RadonDB低门槛向MySQL集群下战书 | ChinaUnix打赏功能已上线！ | 新一代分布式关系型数据库RadonDB知多少？

ruochen

版主

论坛徽章:: 8

4楼 [报告]

发表于 2006-03-13 21:44 |只看该作者

楼主看下你的出错信息:
TNS-12542: TNS:address already in use
TNS-12560: TNS:protocol adapter error

从这两个方面看下!
把我的listener.ora给你看下,看你能参照该下不?
我的是oracle10g

[root@Ruochen oradata]# more /usr/u01/app/oracle/product/10.2.0.1/network/admin/listener.ora
# listener.ora Network Configuration File: /usr/u01/app/oracle/product/10.2.0.1/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
(SID_DESC =
   (SID_NAME = PLSExtProc)
   (ORACLE_HOME = /usr/u01/app/oracle/product/10.2.0.1)
   (PROGRAM = extproc)
)
  )

LISTENER =
  (DESCRIPTION_LIST =
(DESCRIPTION =
   (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
   (ADDRESS = (PROTOCOL = TCP)(HOST = ***.***.***.***)(PORT = 1521))
)
  )