关闭

SQLNET.INBOUND_CONNECT_TIMEOUT

686人阅读 评论(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

SQLNET.INBOUND_CONNECT_TIMEOUT=3

See Also:



0
0

查看评论
* 以上用户言论只代表其个人观点,不代表CSDN网站的观点或立场
    个人资料
    • 访问:164300次
    • 积分:4479
    • 等级:
    • 排名:第7064名
    • 原创:298篇
    • 转载:0篇
    • 译文:1篇
    • 评论:2条
    文章分类
    最新评论