WARNING: inbound connection timed out (ORA-3136)错误分析
1.set INBOUND_CONNECT_TIMEOUT_=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博客 ” ，链接：https://blog.itpub.net/28608743/viewspace-753605/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
Oracle日志查看
请登录后发表评论
登录
全部评论
