Linux下Oracle下监听服务动不动停止Listener.ora :WARNING: Subscription for node down event still pending
来源:互联网 发布:serverless 阿里云 编辑:程序博客网 时间:2024/05/17 01:51
今天做实验,发现listener.ora文件里有这个报错:WARNING: Subscription for node down event still pending。
网上查了一下,大概有如下几种说法:
Issue is fixed in 10.2.0.3 Patch Set
Oracle Support recommends patching to 10.2.0.4 as this the lastest release
- OR -
Apply Patch 4518443 for the problem (if a patch is available)
- OR -
As a workaround, two steps should be done:
1. The following parameter can be added to listener.ora
SUBSCRIBE_FOR_NODE_DOWN_EVENT_<listener_name>=OFF
Where <listener_name> should be replaced with the actual listener name configured in the LISTENER.ORA file. This parameter is to be placed by itself on an empty line / at the end of file.
For example, if the listener name is LISTENER (default), the parameter would be:
SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF
2. Locate the ons.config file in the 10g(rdbms) home and rename it to something else.
For example:
cd $ORACLE_HOME/opmn/conf
mv ons.config ons.config.orig
The listener needs to be restarted after these changes.
Oracle Support recommends patching to 10.2.0.4 as this the lastest release
- OR -
Apply Patch 4518443 for the problem (if a patch is available)
- OR -
As a workaround, two steps should be done:
1. The following parameter can be added to listener.ora
SUBSCRIBE_FOR_NODE_DOWN_EVENT_<listener_name>=OFF
Where <listener_name> should be replaced with the actual listener name configured in the LISTENER.ORA file. This parameter is to be placed by itself on an empty line / at the end of file.
For example, if the listener name is LISTENER (default), the parameter would be:
SUBSCRIBE_FOR_NODE_DOWN_EVENT_LISTENER=OFF
2. Locate the ons.config file in the 10g(rdbms) home and rename it to something else.
For example:
cd $ORACLE_HOME/opmn/conf
mv ons.config ons.config.orig
The listener needs to be restarted after these changes.
--end--
-----------------------------------------------------------------------------------------------------------------------------------------------------------------
检查时会发现系统上存在两个监听器进程,其中一个是另外一个的子进程。
检查监听 ps -ef | grep tnslsnr
KILL掉一个子进程,恢复正常
在Metalink上可以找到相关问题的很多解释,这个问题被最终确认为一个BUG,BUG号为:4518443
Oracle称在较大压力下,监听进程可能出现间歇性停止服务,此时Oracle会spaw出另外一个监听进程,进而导致两个监听进程互相影响的故障。
- Linux下Oracle下监听服务动不动停止Listener.ora :WARNING: Subscription for node down event still pending
- oracle 监听hang,监听日志报错:WARNING: Subscription for node down event still pending' in Listener Log
- oracle监听问题:WARNING: Subscription for node down event still pending
- WARNING: Subscription for node down event still pending
- WARNING: Subscription for node down event still pending
- WARNING: Subscription for node down event still pending
- 'WARNING: Subscription for node down event still pending'
- WARNING: Subscription for node down event still pending
- WARNING: Subscription for node down event still pending
- Master Note:'Warning: Subscription For Node Down Event Still Pending' In Listener Log
- 因为/etc/hosts中问题导致监听挂起-报错:WARNING: Subscription for node down event still pending
- linux下oracle数据库服务和监听的启动停止
- linux下oracle数据库服务和监听的启动停止
- linux下oracle数据库服务和监听的启动停止
- linux下oracle数据库服务和监听的启动停止
- linux下oracle数据库服务和监听的启动停止
- linux下oracle数据库服务和监听的启动停止
- linux 、unix下启动停止oracle服务和监听
- 常用的排序算法的时间复杂度和空间复杂度
- 2013 ACM/ICPC Asia Regional Hangzhou Online 个人总结
- demo2_简单的报数游戏
- Sample Adaptive Offset 1 (SAO 样例自适应补偿)
- apk漏洞记录1:伪加密+设备管理器不可删+webview漏洞
- Linux下Oracle下监听服务动不动停止Listener.ora :WARNING: Subscription for node down event still pending
- iOS AppDelegate协议方法
- oracle 新功能model子句的简单使用
- Virtualbox报错------> VirtualBox虚拟机下鼠标不正常的解决方法
- 事件处理
- 黑马程序员——java第十八、十九天:IO流(一)
- 九月,写满了记忆的芬芳
- 阿道夫.希特勒和他的第三帝国
- phpcms v9后台美化