WARNING: example Analysis of inbound connection timed out ORA-3136 error

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.