ORA-03135: connection lost contact

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