Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to set SQLNET.INBOUND_CONNECT_TIMEOUT?

Beauty_and_dBestJul 15 2016 — edited Jul 22 2016

Hi ALL,

11gR1

Our listener has lots of display > ORA-3136: WARNING Inbound Connection Timed Out

The recommendation is to  set SQLNET.INBOUND_CONNECT_TIMEOUT = 120

Do I need to add it both to SQLNET.ORA and LISTENER.ORA? or either only?

Step1

Edit the server side sqlnet.ora file and add this parameter:
SQLNET.INBOUND_CONNECT_TIMEOUT=<n>  Where <n> is the value in seconds.


Step2

Edit the listener.ora file and add this parameter:

INBOUND_CONNECT_TIMEOUT_<listenername> = <n>  Again, where <n> is the timeout value in seconds. 



Kind regards,

jc

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 19 2016
Added on Jul 15 2016
43 comments
13,141 views