SQLNET.INBOUND_CONNECT_TIMEOUT

最新推荐文章于 2023-04-23 20:39:37 发布

EVISWANG

最新推荐文章于 2023-04-23 20:39:37 发布

阅读量2.1k

点赞数

分类专栏： Listener

本文链接：https://blog.csdn.net/EVISWANG/article/details/49923005

版权

Listener 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

关于这个报错是因为上次监听报错TNS-12637

因为在client和server涉及到这个参数，这里重点说明下

SQLNET.INBOUND_CONNECT_TIMEOUT

表示等待用户认证超时的时间，单位是秒，默认值是60秒

以下是官档参考：

Purpose

To specify the time, in seconds, for a client to connect with the database server and provide the necessary authentication information.

If the client fails to establish a connection and complete authentication in the time specified, then the database server terminates the connection. In addition, the database server logs the IP address of the client and an

ORA-12170:

TNS:Connect timeout occurred

error message to the sqlnet.log file.

The client receives either an

ORA-12547: TNS:lost contact or an

ORA-12637: Packet receive failed error message.

The default value of this parameter is appropriate for typical usage scenarios. However, if you need to explicitly set a different value, then Oracle recommends setting this parameter in combination with the INBOUND_CONNECT_TIMEOUT_listener_name parameter in the listener.ora file.

When specifying the values for these parameters, note the following recommendations:

Set both parameters to an initial low value.
Set the value of the INBOUND_CONNECT_TIMEOUT_listener_name parameter to a lower value than the SQLNET.INBOUND_CONNECT_TIMEOUT parameter.

For example,

you can set INBOUND_CONNECT_TIMEOUT_listener_name to 2 seconds and SQLNET.INBOUND_CONNECT_TIMEOUT parameter to 3 seconds.

If clients are unable to complete connections within the specified time due to system or network delays that are normal for the particular environment, then increment the time as needed.

Default

60 seconds

Example