Contents
How to solve ORA-03135 connection lost contact?
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.
Where is Sqlnet Ora file located in 11g?
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 the difference between sqlnet Ora and Tnsnames Ora?
tnsnames. ora is needed on clients to find databases. It’s something like /etc/hosts on UNIX. It is needed also on the server if you want to connect from the server to the database via sqlnet.
Do changes in Sqlnet Ora require restart?
In general, no. A tnsnames. ora change shouldn’t require a reboot but some applications will read and parse the tnsnames. ora at startup to be able to present a drop-down list of servers to the user, for example, and will cache whatever was read when the application started up rather than re-reading the file.
What is the use of port 1521?
By default when you install Oracle the TNS Listener is on tcp port 1521. It handles network requests to be passed to a database instance. If it not appropriately secured commands can be sent to the listener, the listener can be shut down, or the databases can be queried.
What is TCP 66?
TCP is one of the main protocols in TCP/IP networks. Whereas the IP protocol deals only with packets, TCP enables two hosts to establish a connection and exchange streams of data. TCP guarantees delivery of data and also guarantees that packets will be delivered on port 66 in the same order in which they were sent.
What is the cause of the ora-03135 error?
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. 1) Check if the server session was terminated.
What is the cause of connection lost contact?
Details of error are as follows. ORA-03135: connection lost contact Cause: 1) Server unexpectedly terminated or was forced to terminate. 2) Server timed out the connection. Action: 1) Check if the server session was terminated. 2) Check if the timeout parameters are set properly in sqlnet.ora.
What to do if you get an ora-3135?
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. In worst case, all the connections in your pool are stale in which case the code will be executed N time (where N is the connection pool size).
Why does Oracle Service dispose all connection results?
I dispose all the connections, results and parameters. 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.