ITPub博客

首页 > Linux操作系统 > Linux操作系统 > WARNING : inbound connection timed out ( ORA - 3136 )

WARNING : inbound connection timed out ( ORA - 3136 )

原创 Linux操作系统 作者:zhanglei_itput 时间:2009-04-02 15:23:49 0 删除 编辑

今天在检查alert.log日志时,发现了一个错误号:ORA-3136 WARNING: inbound connection timed out

查了一下metalink,原因如下:(参考DOC_ID:793259.1, 465043.1)
    The "WARNING: inbound connection timed out (ORA-3136)" in the alert log indicates that the client was not able to complete  it's authentication within the period of time specified by parameter SQLNET.INBOUND_CONNECT_TIMEOUT. 
    The most common reason for warning message in alert log is when an user gets error at connect time, ORA-01017 invalid username /password , and on the same prompt, if no update is made for 1 minute(default) then the alert loggets WARNING: inbound connection timed out (ORA-3136)
    重现异常:
    1. SQLNET.INBOUND_CONNECT_TIMEOUT=60(default value) 
    将SQLNET.INBOUND_CONNECT_TIMEOUT=5 添加到$ORACLE_HOME/network/admin/sqlnet.ora中,表示以5秒钟为检测单位
  2.tnsname.ora中添加服务名进去
    nfdb=
       (DESCRIPTION=
              (ADDRESS=(HOST=172.16.203.198)(PORT=1521)(PROTOCOL=TCP))
              (CONNECT_DATA=
              (SERVER=DEDICATED)
              (SERVICE_NAME=nfdb)
               )
       )
  3.sqlplus session and enter wrong username or password
    $ sqlplus system/jkkdsf@nfdb
    SQL*Plus: Release 10.2.0.3.0 - Production on Thu Mar 19 17:51:35 2009
    Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
    
ERROR:
    ORA-01017: invalid username/password; logon denied
  4.Keep the sqlplus session open for 5 seconds and in the alert log after 5th second , you will notice ORA-3136
    $tail -f alert_nfdb.log
     Thu Mar 19 17:52:36 2009
     WARNING: inbound connection timed out (ORA-3136)
     note:如果没有满足参数SQLNET.INBOUND_CONNECT_TIMEOUT退出了sql>连接,那么此时就不会遇到这个错误。

Subject: Most Common Reason for ORA - 3136 WARNING : inbound connection timed out
  Doc ID: 793259.1 Type: HOWTO
  Modified Date : 20-MAR-2009 Status: PUBLISHED

Subject: Troubleshooting ORA - 3136 WARNING Inbound Connection Timed Out
  Doc ID: 465043.1 Type: TROUBLESHOOTING
  Modified Date : 14-DEC-2008 Status: PUBLISHED

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9252210/viewspace-584397/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-02-10

  • 博文量
    400
  • 访问量
    1114813