WARNING: inbound connection timed out ORA-3136錯誤的示例分析

這篇文章將為大家詳細講解有關WARNING: inbound connection timed out ORA-3136錯誤的示例分析，文章內容質量較高，因此小編分享給大家做個參考，希望大家閱讀完這篇文章后對相關知識有一定的了解。

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)連接超時的現象了。

關于WARNING: inbound connection timed out ORA-3136錯誤的示例分析就分享到這里了，希望以上內容可以對大家有一定的幫助，可以學到更多知識。如果覺得文章不錯，可以把它分享出去讓更多的人看到。