Oracle Net (SQL*Net) Timeout Parameters

(Doc ID 1560775.1)

Last updated on SEPTEMBER 06, 2017

Applies to:

Oracle Net Services - Version 11.2.0.1 to 12.1.0.2 [Release 11.2 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 1-MAY-2017***

Goal

This document describes the following sqlnet.ora file parameters:

SQLNET.INBOUND_CONNECT_TIMEOUT=n
SQLNET.OUTBOUND_CONNECT_TIMEOUT=n
SQLNET.RECV_TIMEOUT=n
SQLNET.SEND_TIMEOUT=n
TCP.CONNECT_TIMEOUT=n
 

Note that each parameter is set in <n> seconds.

The default for SQLNET.INBOUND_CONNECT_TIMEOUT is 60 seconds.

The default for TCP.CONNECT_TIMEOUT is also 60 seconds. 

There is no default for the remaining parameters.  

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms