ITPub博客

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

WARNING: inbound connection timed out (ORA-3136)错误分析

Linux操作系统 作者:zr2095 时间:2016-03-11 11:43:29 0 删除 编辑
1.set INBOUND_CONNECT_TIMEOUT_<listenername>=0 in listener.ora 
2. set SQLNET.INBOUND_CONNECT_TIMEOUT = 0 in sqlnet.ora of server.
3. stop and start both listener and database.
4. Now try to connect to DB and observe the behaviour

一、查看数据库中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

保持退出 wq!

三、重新载入listener

LSNRCTL> reload

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=LHXXDBS)(PORT=1568)))

The command completed successfully

第二天观察没有出现WARNING: inbound connection timed out (ORA-3136)连接超时的现象了。


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

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

注册时间:2015-04-15

  • 博文量
    163
  • 访问量
    421369