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)連線超時的現象了。
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/31520497/viewspace-2156846/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- [debug] vagrant報錯mount.nfs: Connection timed outNFS
- java.sql.SQLException:IO 錯誤:Socket read timed out !JavaSQLException
- 執行systemctl status ssh返回“Failed to get properties: Connection timed out”AI
- oozie.action.hadoop.LauncherException: IO error Connection timed out: no further informationHadoopExceptionErrorORM
- 報錯（已解決）Command timed out after no timeout
- CM agent 傳送heartbeat給CM server 不斷髮生 connection refused：timed outServer
- Mysql 錯誤日誌出現大量[Warning] Aborted connection to db user host的解決思路MySql
- 關於遠端連線虛擬機器Network error: Connection timed out的問題虛擬機Error
- dedecms 搬家 / dedecms error warning!錯誤Error
- [Clickhouse] Clickhouse 報SQLException : Read timed outSQLException
- Python怎樣忽略warning警告錯誤？Python
- SSH出現Connection refused錯誤
- SAP Connection inbound郵件接收處理機制
- flutter升級後 執行專案報錯 Warning: Podfile is out of dateFlutter
- Kubelet 錯誤日誌 broken pipe 和 connection reset by peer 的原因分析
- Putty或MobaXTerm無法連線VMware虛擬機器 報Network error: Connection timed out的解決方案虛擬機Error
- lightdb WARNING: could not establish connection after 30000 ms
- Failed to connect to ESP8266: Timed out waiting for packet headerAIHeader
- 【解決】io.lettuce.core.RedisCommandTimeoutException: Command timed outRedisException
- jdbc訪問KingbaseES資料庫SocketTimeoutException Read timed outJDBC資料庫Exception
- 雲伺服器使用fastDFS錯誤,readtime out伺服器AST
- 記錄redis佇列read error on connection to錯誤Redis佇列Error
- 織夢提示dedecms error warning錯誤的解決方法Error
- java.net.SocketTimeoutException: Read timed out異常解決方法JavaException
- Feign，HTTP連線超時問題SocketTimeoutException: Read timed outHTTPException
- 部分OPPO機型 AssetManager.finalize() timed out的修復
- io.lettuce.core.RedisCommandTimeoutException: Command timed out 解決辦法RedisException
- RetryableException: Read timed out executing導致服務假死無響應Exception
- java.sql.SQLRecoverableException: IO Error: Socket read timed out 排查歷程JavaSQLExceptionError
- pip 下載報"connection to pypi.org time out"
- 安裝kernel...src.rpm錯誤：warning: user mockbuild does not exist - using rootMockUI
- ORA-04030: out of process memory ...(initSubHeap:qk...)的錯誤解決
- net 日誌分析錯誤
- web拼圖錯誤分析Web
- 【python】pip安裝庫時出現Read timed out.解決辦法Python
- 解決telnet: connect to address 127.0.0.1: Connection refused的錯誤資訊問題127.0.0.1
- ORA-03113錯誤分析(轉)
- OGG Director報錯 Connection FAILEDAI