[转帖]TNS-12204错误信息16375-9-2--搜狗_MySQL, Oracle及数据库讨论区_Weblogic技术|Tuxedo技术|中间件技术|Oracle论坛|JAVA论坛|Linux/Unix技术|hadoop论坛_联动北方技术论坛  
网站首页 | 关于我们 | 服务中心 | 经验交流 | 公司荣誉 | 成功案例 | 合作伙伴 | 联系我们 |
联动北方-国内领先的云技术服务提供商
»  游客             当前位置:  论坛首页 »  自由讨论区 »  MySQL, Oracle及数据库讨论区 »
总帖数
2
每页帖数
101/1页1
返回列表
0
发起投票  发起投票 发新帖子
查看: 13806 | 回复: 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
    返回列表
    发新帖子
    请输入验证码: 点击刷新验证码
    您需要登录后才可以回帖 登录 | 注册
    技术讨论