WARNING: inbound connection timed out (ORA-3136)连接超时

最新推荐文章于 2024-11-26 09:15:00 发布

nihaozhuangyan

最新推荐文章于 2024-11-26 09:15:00 发布

阅读量615

点赞数

分类专栏： ORACLE 文章标签： oracle ORA

ORACLE 专栏收录该内容

0 篇文章

订阅专栏

本文详细介绍了如何解决Oracle数据库连接超时问题，包括查看并调整listener.ora中的inbound_connect_timeout参数、修改sqlnet.ora文件、重新加载监听器等步骤。重点关注Oracle数据库在10.2版本中引入的inbound_connect_timeout参数及其相关bug，提供了实用的解决方案。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

AIX5.3
Oracle10g

告警日志中
WARNING: inbound connection timed out (ORA-3136)

sqlnet.log日志

Fatal NI connect error 12170
  VERSION INFORMATION:
 TNS for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production
 TCP/IP NT Protocol Adapter for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production
 Oracle Bequeath NT Protocol Adapter for IBM/AIX RISC System/6000: Version 10.2.0.1.0 - Production
  Time: 09-MAR-2009 02:32:29
  Tracing not turned on.
  Tns error struct:
    ns main err code: 12535
    TNS-12535: TNS:operation timed out
    ns secondary err code: 12606
    nt main err code: 0
    nt secondary err code: 0
    nt OS err code: 0
  Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.171.4.201)(PORT=3663))

9i开始引入，指定了客户端连接服务器并且提供认证信息的超时时间，如果超过这个时间客户端没有提供正确的认证信息，服务器会自动中止该连接请求，防止网络攻击,同时会记录试图连接的IP地址和ORA-12170: TNS:Connect timeout occurred错误在10.2.0.1起，该参数默认设置为60秒但是，这个参数的引入也导致了一些相关的bug。比如：Bug 5594769 - REMOTE SESSION DROPPED WHEN LOCAL SESSION SHARED AND INBOUND_CONNECT_TIMEOUT SETBug 5249163 - CONNECTS REFUSED BY TNSLSNR EVERY 49 DAYS FOR INBOUND_CONNECT_TIMEOUT SECONDS该参数可以通过设置为0来禁用，然后reload或者重启监听

一、查看数据库中listener.ora中的inbound_connect_timeout参数值

1、进入lsnrctl，
LHXXDBS01:oraoms> lsnrctl
2、查看inbound_connect_timeout参数：
LSNRCTL> show inbound_connect_time
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=LHXXDBS)(PORT=1568)))
LISTENER parameter "inbound_connect_timeout" set to 0
The command completed successfully
如果inbound_connect_timeout参数值不为0，则可以修改为0
修改：
LSNRCTL> set inbound_connect_time 0
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=LHXXDBS)(PORT=1568)))
LISTENER parameter "inbound_connect_timeout" set to 0
The command completed successfully

二、修改/oracle/oms/102_64/network/admin/sqlnet.ora
Vi sqlnet.ora
SQLNET.INBOUND_CONNECT_TIMEOUT = 0

三、重新载入listener
LSNRCTL> reload
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=LHXXDBS)(PORT=1568)))
The command completed successfully