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 specified 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
In listener file: INBOUND_CONNECT_TIMEOUT_listener_name parameter

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



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

Leave a Reply

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

You are commenting using your 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 )

Connecting to %s

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