The listener supports no services问题解决

最新推荐文章于 2020-07-31 15:01:12 发布

cuilun4325

最新推荐文章于 2020-07-31 15:01:12 发布

阅读量245

点赞数

环境是11.2.0.4，查看监听状态是 The listener supports no services

[oracle@oracle11gtest admin]$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 06-MAR-2017 18:54:40
Copyright (c) 1991, 2013, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oracle11gtest)(PORT=1521)(IP=FIRST)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.4.0 - Production
Start Date 06-MAR-2017 18:54:15
Uptime 0 days 0 hr. 0 min. 24 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /alidata1/app/oracle/11.2.0/db_1/network/admin/listener.ora
Listener Log File /alidata1/app/oracle/diag/tnslsnr/oracle11gtest/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.3.171)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC)))
The listener supports no services
The command completed successfully

解决办法是，在listener.ora文件里添加如下内容，把gps修改为相应的实例名

重启监听后就可以连接了。

附完整listener.ora内容

[oracle@oracle11gtest admin]$ more listener.ora
# listener.ora Network Configuration File: /alidata1/app/oracle/11.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = oracle11gtest)(PORT = 1521))
)
)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = gps)
(SID_NAME = gps)
)
)
ADR_BASE_LISTENER = /alidata1/app/oracle

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/20893244/viewspace-2134802/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/20893244/viewspace-2134802/

关注