首页 > 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秒钟为检测单位
  3.sqlplus session and enter wrong username or password
    $ sqlplus system/jkkdsf@nfdb
    SQL*Plus: Release - Production on Thu Mar 19 17:51:35 2009
    Copyright (c) 1982, 2006, Oracle. All Rights Reserved.
    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)

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博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。



  • 博文量
  • 访问量