我在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重新建立下监听看看