当前位置: 代码迷 >> Oracle管理 >> oracle监听程序不支持服务 求大侠帮忙解决思路
  详细解决方案

oracle监听程序不支持服务 求大侠帮忙解决思路

热度:25   发布时间:2016-04-24 05:09:50.0
oracle监听程序不支持服务 求大侠帮忙
我在fedora 16下装了oracle 11gr1 还有sql developer ,启动监听时出现:监听程序不支持服务
------------------------------------

[oracle@localhost admin]$ lsnrctl start

LSNRCTL for Linux: Version 11.1.0.6.0 - Production on 26-7月 -2012 16:31:24

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

启动/u01/app/oracle/product/11.1.0/dbhome_1/bin/tnslsnr: 请稍候...

TNSLSNR for Linux: Version 11.1.0.6.0 - Production
系统参数文件为/u01/app/oracle/product/11.1.0/dbhome_1/network/admin/listener.ora
写入/u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml的日志信息
监听: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
监听: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.137.164)(PORT=1521)))

正在连接到 (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))
LISTENER 的 STATUS
------------------------
别名 LISTENER
版本 TNSLSNR for Linux: Version 11.1.0.6.0 - Production
启动日期 26-7月 -2012 16:31:24
正常运行时间 0 天 0 小时 0 分 0 秒
跟踪级别 off
安全性 ON: Local OS Authentication
SNMP OFF
监听程序参数文件 /u01/app/oracle/product/11.1.0/dbhome_1/network/admin/listener.ora
监听程序日志文件 /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
监听端点概要...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.137.164)(PORT=1521)))
监听程序不支持服务
命令执行成功
--------------------------------------------------------
listener.ora 内容

 LISTENER =
  (DESCRIPTION_LIST =
  (DESCRIPTION =
  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.137.164)(PORT = 1521))
  )
  )
 -------------------------------------------
 tnsnames.ora 文件内容 

LISTENER_DB11G =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.137.164)(PORT = 1521))
 
 
 ORCL =
  (DESCRIPTION =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.137.164)(PORT = 1521))
  (CONNECT_DATA =
  (SERVER = DEDICATED)
  (SERVICE_NAME = orcl)
  )
  )
---------------------------------------------
有方法说把 数据库里的local_listener参数的内容与tnsnames.ora里的改成一致
alter system set local_listener=LISTENER_DB11G
我试了,但监听还是提示“监听程序不支持服务”

求大侠帮忙 我是菜鸟,请说详细点,谢谢了

------解决方案--------------------
用netca重新建立下监听看看
  相关解决方案