WARNING: inbound connection timed out (ORA-3136)錯誤分析

Davis_itpub發表於2018-06-27
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/31520497/viewspace-2156846/，如需轉載，請註明出處，否則將追究法律責任。

相關文章