A reader, April 28, 2017 - 4:04 pm UTC
When to use INBOUND_CONNECT_TIMEOUT_LISTENER and INBOUND_CONNECT_TIMEOUT?
What's major difference both of them?
April 28, 2017 - 11:02 pm UTC
They are the similar but at different points in the flow of a connection.
INBOUND_CONNECT_TIMEOUT_LISTENER
- where the client is communicating with the *listener*
SQLNET.INBOUND_CONNECT_TIMEOUT
- where the client is now communicating with the *database*
So you could have a rule which is:
"You have 2 seconds to complete your communication with listener, and 5 seconds in order for the entire connection process to be completed"
Godwin, April 04, 2020 - 1:53 pm UTC
Thanks for the clarifications.
Want to know if the two parameters SQLNET.EXPIRE_TIME and SQLNET.INBOUND_CONNECT_TIMEOUT
should be set both the database server and the Oracle client server
or just at the database side.
April 06, 2020 - 12:22 am UTC
I generally dont set them unless I have to, but I do need to, I'll set them both sides, but that might just be my paranoia :-)