我的oracle For Red Hat 9的Listener问题

javanow 2004-09-17 02:01:14
1:无法启动listener
2:dbca打开后无法关闭窗口(这个先不急)

我的ora文件内容

# TNSNAMES.ORA Network Configuration File: /opt/ora9/product/9.2/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

DKF3594.LOCALDOMAIN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = dkf3594)
)
)

INST1_HTTP.LOCALDOMAIN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = MODOSE)
(PRESENTATION = http://HRService)
)
)

EXTPROC_CONNECTION_DATA.LOCALDOMAIN =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
EXTPROC_CONNECTION_DATA,EXTPROC_CONNECTION_DATA.WORLD=
( DESCRIPTION=
(ADDRESS_LIST=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
(CONNECT_DATA=(SID=PLSExtProc))
)

部分LOG

TNSLSNR for Linux: Version 9.2.0.4.0 - Production on 17-SEP-2004 01:48:32

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

System parameter file is /opt/ora9/product/9.2/network/admin/listener.ora
Log messages written to /opt/ora9/product/9.2/network/log/listener.log
Trace information written to /opt/ora9/product/9.2/network/trace/listener.trc
Trace level is currently 0

Started with pid=4219
17-SEP-2004 01:48:32 * 12502
TNS-12502: TNS:listener received no CONNECT_DATA from client
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

我试了很多方法都无法解决.麻烦您了
...全文
105 11 打赏 收藏 转发到动态 举报
写回复
用AI写文章
11 条回复
切换为时间正序
请发表友善的回复…
发表回复
javanow 2004-09-19
  • 打赏
  • 举报
回复
唉,问题并没有解决。我现在删除了linux下的oracle。不玩了。太累了。

乖乖呆在win 2k as下面。
zhaokeke2004 2004-09-18
  • 打赏
  • 举报
回复
你的LISTENER.ORA有改过吗?
black_snail 2004-09-18
  • 打赏
  • 举报
回复
改成IP试一下
houlong 2004-09-18
  • 打赏
  • 举报
回复
不懂,up
javanow 2004-09-18
  • 打赏
  • 举报
回复
re:
你的LISTENER.ORA有改过吗?

没有改过。

我决定 不用Linux下的oracle了,很多问题,某些窗口不能关闭(dbca),某些窗口不能输入(netca).所以没法用。
javanow 2004-09-17
  • 打赏
  • 举报
回复
# LISTENER.ORA Network Configuration File: /opt/ora9/product/9.2/network/admin/listener.ora
# Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
)
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /opt/ora9/product/9.2)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = dkf3594)
(ORACLE_HOME = /opt/ora9/product/9.2)
(SID_NAME = ora001)
)
)

在线等待.谢谢.
zealot_zk 2004-09-17
  • 打赏
  • 举报
回复
应该是监听的地址已经在用了,你试试重新创建一个新的监听器,试试(不使用默认的端口,要确保所使用的端口不在用)
wylwyl1130 2004-09-17
  • 打赏
  • 举报
回复
贴出listener.ora看看吧
zhaokeke2004 2004-09-17
  • 打赏
  • 举报
回复
楼主请不要混淆listener和TNSNAMES
zhihaitao 2004-09-17
  • 打赏
  • 举报
回复
用netca配一个监听器就是了
drabit 2004-09-17
  • 打赏
  • 举报
回复
无法启动listener贴tnsnames。ora有什么用?
启动listener需要的是listener。ora

17,377

社区成员

发帖
与我相关
我的任务
社区描述
Oracle 基础和管理
社区管理员
  • 基础和管理社区
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告
暂无公告

试试用AI创作助手写篇文章吧