INBOUND CONNECT TIMEOUT Parameter in SQLNET file of Oracle

INBOUND_CONNECT_TIMEOUT Parameter in SQLNET file of Oracle

Time need for a client to make connection with the Database Server and authenticate it.
If client failed to establish and authenticate the connection in given time then database terminate the connection.
Value sepecified in this parameter is ms, sec or min. Default value is 60 seconds.

Get the following errors:
ORA-12170: TNS:Connect timeout occurred
ORA-12547: TNS:lost contact
ORA-12637: Packet receive failed

Oracle recommends to set parameter of listener and sqlnet.ora file both
INBOUND_CONNECT_TIMEOUT_listener_name parameter
SQLNET.INBOUND_CONNECT_TIMEOUT parameter

Note: Value for INBOUND_CONNECT_TIMEOUT_listener_name parameter is set lower than SQLNET.INBOUND_CONNECT_TIMEOUT parameter.

Example

SQLNET.INBOUND_CONNECT_TIMEOUT=60

Note: if you do not specified the ms, sec or min then it will pick default as seconds.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.