Oracle启动监听提示:The listener supports no services 的处理方法
来源:互联网 发布:linux设置共享目录 编辑:程序博客网 时间:2024/04/20 09:27
[oracle@localhost admin]$ lsnrctl status
LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 19-APR-2016 10:51:08
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.230.129)(PORT=1521)))
STATUS of the LISTENER
Alias LISTENER
Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date 19-APR-2016 10:43:19
Uptime 0 days 0 hr. 7 min. 49 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/12.1.0/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening Endpoints Summary…
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.230.129)(PORT=1521)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1521)))
The listener supports no services
The command completed successfully
这样启动后远程连接会造成
oracle ORA-12514:TNS:listener does not currently know of service requested in connect descriptor
–查看监听状态
$lsnrctl status
- 解决方案
Oracle Net Manager修改配置
在下图的Listeners->Database Services中配置要监听的SID及ORACLE_HOME,退出保存。
在Liunx环境下使用netmgr命令完成!!!
[oracle@localhost bin]$ netmgr
- Oracle启动监听提示:The listener supports no services 的处理方法
- oracle 启动监听提示 :The listener supports no services
- oracle 启动监听提示 :The listener supports no services
- oracle 启动监听提示 :The listener supports no services
- ORACLE启动监听出现The listener supports no services
- oracle 监听启动报错:the listener supports no services
- oracle 监听无法启动(the listener supports no services)
- 数据库和监听启动后,监听中提示The listener supports no services
- Oracle启动监听报错:The listener supports no services The command completed successfully
- Oracle启动监听报错:The listener supports no services解决
- (总结)Oracle启动监听报错:The listener supports no services解决
- Oracle启动监听报错:The listener supports no services解决
- Oracle启动监听报错:The listener supports no services解决
- Oracle启动监听报错:The listener supports no services解决
- Oracle启动监听报错:The listener supports no services解决
- (总结)Oracle启动监听报错:The listener supports no services解决
- Oracle启动监听报错:The listener supports no services解决
- ORACLE监听器 The listener supports no services 问题解决方法
- Java_处理日期的工具类
- Jenkins配置自动化构建
- Statistical Decision Theory and Bayesian Analysis 笔记
- storm学习笔记
- 谈谈iOS7及以上版本navigationBar带来的坑
- Oracle启动监听提示:The listener supports no services 的处理方法
- 多线程学习04-NSThread创建
- Struts 原理
- mongod 配置
- Java Builder模式 初体验
- XMPP
- xml 代码注释快捷键
- Android shape使用
- Tomcat基础使用知识