SQLNET.EXPIRE_TIME specifies a time interval (in minutes) to send a probe to verify that client/server connections are active. If you set a value greater than 0 ensures that connections are not left open indefinitely due to an abornal client termination. If the probe finds a terminated connection, or a connection that is no longer in use, it returns an error, causing the server process to exit.
Default = 0
Minimum = 0
Recomended value = 10
Other parameters that can affect timeouts are (for example the value is 120 seconds):
SQLNET.INBOUND_CONNECT_TIMEOUT=120 (server's SQLNET.ORA)
INBOUND_CONNECT_TIMEOUT_<listener_name> =120 (server's LISTENER.ORA)
SQLNET.SEND_TIMEOUT = 300
SQLNET.RECV_TIMEOUT = 300
Restart LISTENER, LISTENER_SCAN1, LISTENER_SCAN2, LISTENER_SCAN3
If ORA-03135 occurs when trying to connect from ODP.NET, a workaround is to set Validate Connection = True. If Oracle version is 11.2.0.2 and you use SCAN, perhaps you should try to use vips instead and see if the error is resolved.
No comments:
Post a Comment