[转帖]TNS-12204错误信息16375-9-2--搜狗_MySQL, Oracle及数据库讨论区_Weblogic技术|Tuxedo技术|中间件技术|Oracle论坛|JAVA论坛|Linux/Unix技术|hadoop论坛_联动北方技术论坛  
网站首页 | 关于我们 | 服务中心 | 经验交流 | 公司荣誉 | 成功案例 | 合作伙伴 | 联系我们 |
联动北方-国内领先的云技术服务提供商
»  游客             当前位置:  论坛首页 »  自由讨论区 »  MySQL, Oracle及数据库讨论区 »
总帖数
2
每页帖数
101/1页1
返回列表
0
发起投票  发起投票 发新帖子
查看: 7745 | 回复: 1   主题: [转帖]TNS-12204错误信息16375-9-2--搜狗        上一篇   下一篇 
luopengfei3000
注册用户
等级:新兵
经验:71
发帖:1
精华:0
注册:2015-11-5
状态:离线
发送短消息息给luopengfei3000 加好友    发送短消息息给luopengfei3000 发消息
发表于: IP:您无权察看 2019-9-20 11:19:20 | [全部帖] [楼主帖] 楼主

检查我们的一台ORACLE数据库的监听日志发现有不少TNS-12502错误信息。如下所示

北京联动北方科技有限公司

北京联动北方科技有限公司

TNS-12502: TNS:listener received no CONNECT_DATA from client

09-DEC-2014 15:47:06 * (CONNECT_DATA=(SERVICE_NAME=epps)(CID=(PROGRAM=D:\Tasks\FGIS2MES\CEG\gmt_auto.exe)(HOST=CEGWEB1)(USER=cegadmin))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.163.21.14)(PORT=2312)) * establish * epps * 0

$ oerr tns 12502

12502, 00000, "TNS:listener received no CONNECT_DATA from client"

// *Cause: No CONNECT_DATA was passed to the listener.

// *Action: Check that the service name resolved from TNSNAMES.ORA has

// the CONNECT_DATA component of the connect descriptor.

一般出现这个错误是因为客户端tnsnames.ora中没有包含CONNECT_DATA导致,但是如上所示,客户端tnsnames.ora中已经包含了CONNECT_DATA数据,大部分时候正常,但是偶尔又会在listener.log里面发现该错误信息,而且完全没有规律可言,最后在Oracle的TNS-12502 错误原因及解决这篇文章中了解到,客户端通过telnet数据库服务器的1521端口测试连通性,也会出现如下错误。如下所示:

telnet 192.168.20.11 1521

查看/u01/app/oracle/product/10.2.0/db_1/network/log/listener.log 如下所示,你会看到TNS-12525错误信息。

北京联动北方科技有限公司

12-DEC-2014 20:40:33 * <unknown connect data> * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.125.113)(PORT=52651)) * establish * <unknown sid> * 12525

TNS-12525: TNS:listener has not received client's request in time allowed

TNS-12535: TNS:operation timed out

TNS-12606: TNS: Application timeout occurred

12-DEC-2014 20:40:37 * service_update * epps * 0

但是这个跟在监听日志中发现的错误信息有所区别:TNS-12502: TNS:listener received no CONNECT_DATA from client,我统计了TNS-12502错误出现的时间点也很难发现什么规律。很奇怪的是这个错误也不影响用户的使用。到目前为止,也一直没有弄明白为什么会出现这个错误。暂且做个记录,留待以后研究解决!




赞(0)    操作        顶端 
联动大白
注册用户
等级:列兵
经验:91
发帖:0
精华:0
注册:2015-5-27
状态:离线
发送短消息息给联动大白 加好友    发送短消息息给联动大白 发消息
发表于: IP:您无权察看 2019-12-11 0:30:00 | [全部帖] [楼主帖] 2  楼

为了方便大家阅读,我对文章中错误号来解释一下吧!

Error Id: TNS-12606

Title: TNS: Application timeout occurred

Description:

TNS: Application timeout occurred

Action:

This is an error which does not normally appear at the high level. The action to take is application specific, and is detailed in the higher level error description.

Cause:

A network session did not reach an application-defined stage within the allowed time interval.


Error Id: TNS-12502

Title: TNS:listener received no CONNECT_DATA from client

Description:

TNS:listener received no CONNECT_DATA from client

Action:

Check that the service name resolved from TNSNAMES.ORA has the CONNECT_DATA component of the connect descriptor.

Cause:

No CONNECT_DATA was passed to the listener.


Error Id: TNS-12525

Title: TNS:listener has not received client’s request in time allowed

Description:

TNS:listener has not received client’s request in time allowed

Action:

If the error occurred because of a slow network or system, reconfigure INBOUND_CONNECT_TIMEOUT to a larger value. If a malicious client is suspected, use the address in listener.log to identify the source and restrict access. Turn on tracing for more information.

Cause:

The listener disconnected the client because the client failed to provide the necessary connect information within the allowed time interval. This may be a result of network or system delays; or this may indicate that a malicious client is trying to cause a Denial of Service attack on the listener.


Error Id: TNS-12535

Title: TNS:operation timed out

Description:

TNS:operation timed out

Action:

Look at the documentation on the secondary errors for possible remedy. See SQLNET.LOG to find secondary error if not provided explicitly. Turn on tracing to gather more information.

Cause:

The requested operation could not be completed within the time out period.


Error Id: TNS-12204

Title: TNS:received data refused from an application

Description:

TNS:received data refused from an application

Action:

Make sure that the application listener at the destination is functioning correctly. If it is and the problem persists, contact Worldwide Customer Support.

Cause:

The application using Connection Manager refused the connection at the listener.


Error Id: 40:3

Title: 选择段

Description:

选择段


Error Id: 40:33

Title: 1234:状态更改不允许

Description:

1234:状态更改不允许


Error Id: 40:37

Title: 1234:控制配方目的地不在这个订单中

Description:

1234:控制配方目的地不在这个订单中


也许你已明白,但对一个人有用也是我存在的理由!^_^ By:持之以恒的大白

-- 来自: 北京联动北方科技有限公司



赞(0)    操作        顶端 
总帖数
2
每页帖数
101/1页1
返回列表
发新帖子
请输入验证码: 点击刷新验证码
您需要登录后才可以回帖 登录 | 注册
技术讨论