Shulou(Shulou.com)06/01 Report--

This article will explain in detail the example analysis of WARNING: inbound connection timed out ORA-3136 errors. The content of the article is of high quality, so the editor will share it with you for reference. I hope you will have some understanding of the relevant knowledge after reading this article.

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

1. Check the inbound_connect_timeout parameter values in listener.ora in the database

1. Enter lsnrctl

LHXXDBS01:oraoms > lsnrctl

2. Check the inbound_connect_timeout parameters:

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

If the inbound_connect_timeout parameter value is not 0, it can be changed to 0

Modify:

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

II. Modify / oracle/oms/102_64/network/admin/sqlnet.ora

Vi sqlnet.ora

SQLNET.INBOUND_CONNECT_TIMEOUT = 0

Keep exiting wq!

3. Reload listener

LSNRCTL > reload

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

The command completed successfully

No WARNING: inbound connection timed out (ORA-3136) connection timeout was observed the next day.

This is the end of the sample analysis of WARNING: inbound connection timed out ORA-3136 errors. I hope the above can be helpful to you and learn more. If you think the article is good, you can share it for more people to see.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.