oracle 启动监听提示 :The listener supports no services
来源:互联网 发布:风电场风速数据下载 编辑:程序博客网 时间:2024/03/29 14:40
转自: http://blog.csdn.net/liqfyiyi/article/details/6941464
lsnrctl start
提示:
The listener supports no services
The command completed successfully
这样启动后远程连接会造成
oracle ORA-12514:TNS:listener does not currently know of service requested in connect descriptor
---方案一---------原因:数据库实例注册到listener-----------------------------------
--登录数据库
$sqlplus / as sysdba
--显示服务名
SQL>show parameter service_names
--强制注册服务
SQL>alter system register;
--查看监听状态
$lsnrctl status
-----方案二--------------------------------------
问题解决了
在listener.ora里面添加了一行
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = globe)
(SID_NAME = globe)
)
)
-----方案三-------------------------
后发现Oracle有个Net Manager可用:
在下图的Listeners->Database Services中配置要监听的SID及ORACLE_HOME,退出保存。
linux上面:
[root@localhost oracle]# xhost +
[root@localhost oracle]# su - oracle
[oracle@localhost ~]$ netmgr========================================================================================
Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))
TNS-12535: TNS:operation timed out
TNS-12560: TNS:protocol adapter error
TNS-00505: Operation timed out
Linux Error: 110: Connection timed out
LSNRCTL>
今天在启动监听的时候发现需要等很长时间,而且还报错。想想这两天机器做过的改变,只有防火墙动了一下(由于是测试机我试验一下iptables的一些配置)。我马上暂停了防火墙服务,监视服务起来了而且没有任何错误。马上搜一下,是由于我没有在本地防火墙里添加可以127.0.0.1的IP INPUT许可原因。其实只要ping 一下自己的机器名,如果通就可以了。
- 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
- HDOJ 题目4941Magical Forest(STL)
- 一点想法
- HDU 3081 Marriage Match II(二分+并查集+最大流)
- [ATL/WTL]_[中级]_[保存CBitmap到文件-保存屏幕内容到文件]
- Eclipse搭建SSH(Struts2+Spring3+Hibernate3)框架项目教程
- oracle 启动监听提示 :The listener supports no services
- 用GDB调试程序
- Linux core 文件介绍
- 把Matlab里求相关函数的xcorr命令彻底搞清楚
- 炼数成金--shell实例 3
- cocos2d-x CC_CALLBACK和std::bind 的关系
- Oracel启动和停止服务方法
- 黑马程序员——block和protocol小结
- servlet中的service方法