Oracle监听日志频繁报unknown connect data 12537错误诊断
来源:互联网 发布:2016淘宝618报名入口 编辑:程序博客网 时间:2024/04/20 22:16
数据库巡检,发现监听日志中频繁报出如下错误
Mon Mar 13 14:52:11 201713-MAR-2017 14:52:11 * <unknown connect data> * 12537TNS-12537: TNS:connection closed TNS-12560: TNS:protocol adapter error TNS-00507: Connection closed
在此期间,数据库及应用都没有任何异常。
在MOS中找到一篇文档解释这个现象:
Listener Log Intermittently Reports: and either * 12537 or * 12569 errors (文档 ID 1664901.1)
节选重要信息如下:
结论:
These errors are not caused by an Oracle product, but are most likely caused by a 3rd party tool.
原因:
What is happening is something, such as a 3rd party probe, is trying to connect to the listener, but the listener does not understand this connection because it is NOT a sqlnet connection. It knows this because sqlnet uses a unique header to identify itself.
复现方法
After 60 seconds, the listener will give up trying to identify this connection and report a TNS-12525 error.However, if the unknown connection attempt is terminated BEFORE the 60 seconds, then you get the error in the listener log: * <unknown connect data> * 12537TNS-12537: TNS:connection closedTNS-12560: TNS:protocol adapter errorTNS-00507: Connection closed <possible OS error here>Reproducing the error is easy:On the server, simply ssh to yourself on the listener port.For example: ssh -p 1521 oracle@listener_hostnameIf you kill this command after a few seconds with CTRL-C, check the appropriate listener log to see the error.
根据文档上提供的复现该问题的方法,测试了一下,成功复现出了相同的错误信息。
0 0
- Oracle监听日志频繁报unknown connect data 12537错误诊断
- Postfix 日志 connect from unknown错误
- 诊断一次Oracle日志切换频繁的问题
- Mycat之——日志报Unknown charsetIndex:224错误
- Oracle常见错误诊断
- Oracle常见错误诊断
- datatables报Requested unknown...错误
- 根据 MySQL 错误日志来诊断错误
- 记录今天因oracle监听不能启动,报错误问题
- Oracle建DataBase的时候报监听错误
- oracle登录报ORA-12541:无监听程序 ! 错误
- Oracle 注解 主键 错误 Unknown integral data type for ids : java.lang.String
- Oracle 监听日志
- oracle 监听日志清除
- oracle的监听日志
- Oracle备份监听日志
- 清理ORACLE监听日志
- oracle11g首先报监听程序配置错误,然后报listener does not currently know of SID given in connect descriptor
- Kotlin的属性委托:无上下文情况下Android的赋值(KAD 15)
- CF 135 DIV2 B Special Offer! Super Price 999 Bourles! 思维
- rtems源码贡献步骤
- Android中关于menu(菜单)的创建与使用
- Android入门之——百度地图开发(一)
- Oracle监听日志频繁报unknown connect data 12537错误诊断
- Handler作为Activity的内部类所引起的内存泄露问题
- Gson对字符串null的字段转换为空字符串输出
- 【第6题】360校园招聘2015届技术类笔试题
- ccf/201409-3 /字符串匹配---java
- 紫书搜索 习题7-3 UVA
- android中fragment出现replace方法参数不匹配
- 函数模板---上
- java 观察者模式