How do I fix Ora-03135 connection lost contact?
To resolve ORA-03135 error, you should increase the value of the expire_time parameter in the SQLNET. ORA file ( under $ORACLE_HOME/network/admin/ ) . Set the parameters sqlnet. inbound_connect_timeout and inbound_connect_timeout_listenername to 0 to solve the ORA-03135.
How to resolve ORA-03135?
The ORA-03135 error is common when connecting remotely when a firewall terminates the connection. One solution for the ORA-03135 error is to increase the value of the sqlnet. ora expire_time parameter in the sqlnet. ora file or to check for a expire parameter in a SQL*Plus profile.
What is ORA-03135?
An ORA-03135 error reads as the “connection lost contact”. This means that the server connection was unexpectedly terminated or forced to terminate. This can also mean that the server simply timed out the connection.
Where can I find Sqlnet Ora?
ORACLE_HOME/network/admin directory
By default, the sqlnet. ora file is located in the ORACLE_HOME/network/admin directory. The sqlnet. ora file can also be stored in the directory specified by the TNS_ADMIN environment variable.
What is Sqlnet expire_time?
The SQLNET. EXPIRE_TIME specifies a time interval (in minutes) to send a check, which verifies that the client/server connections are active. Setting a value greater than 0 ensures that connections are not left open indefinitely, due to an abnormal client termination.
Where is ORACLE_HOME network admin?
ora is located in the ORACLE_HOME\network\admin directory on Windows. Oracle home path is usually C:\app\oracle_account\product\12.1. 0\dbhome_1 in windows.
What is the cause of the ora-03135 connection lost contact error?
Question: Users are connected to the database via TNS and abruptly get disconnected. What is the cause of the ORA-03135 error? How can this be resolved? Answer: According to oerr the description of the ORA-03135 error is below. 1) Server unexpectedly terminated or was forced to terminate. 2) Server timed out the connection.
What to do if you get oracleexception ora-03135?
First be optimistic and use whateven connection is returned from the connection pool. If you get a ORA – 3135 then request a new connection and execute your query again like a while loop. In best case, you can get your 1st connection as valid and your query will execute.
When to close client connection in sqlnet.ora?
In cases when the packet is not acknowledged, the client connection is closed. Below the value is set to 15 minutes in the sqlnet.ora file. There are two cases to consider with this setting.
Why does Oracle DataAccess return a stale connection?
The load on this service is, well, very low. It happens because your code requests a connection from the Oracle Connection Pool and the connection pool returns a disconnected / stale connection to the Oracle DB. ODP.NET does not itself test the connection status of the connection sent to client.
https://www.youtube.com/watch?v=PlSY9BaoAB0