IT Tutorial IT Tutorial | Oracle DBA | SQL Server, Goldengate, Exadata, Big Data, Data ScienceTutorial
Hi,
Sometimes You can get ” ORA-03135: connection lost contact ” error.
Details of error are as follows.
ORA-03136: inbound connection timed out
Cause: Inbound connection was timed out by the server because user authentication was not completed within the given time specified by SQLNET.INBOUND_CONNECT_TIMEOUT or its default value
Action: 1) Check SQL*NET and RDBMS log for trace of suspicious connections.
2) Configure SQL*NET with a proper inbound connect timeout value if necessary.
TNS-12535 TNS:operation timed out
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.63.34)(PORT=1453))
nt secondary err code: 0
Tracing not turned on.
WARNING: inbound connection timed out (ORA-3136)
Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.63.34)(PORT=1453))
nt secondary err code: 0
Tracing not turned on.
WARNING: inbound connection timed out (ORA-3136)
TNS-12535 and ORA-03135: connection lost contact error are related with the Network traffic and High loaded database operations.
To solve this error, add the following parameter to the SQLNET.ORA file ( under $ORACLE_HOME/network/admin/ ).
SQLNET.INBOUND_CONNECT_TIMEOUT = 180 INBOUND_CONNECT_TIMEOUT_LISTENER = 120
then restart the Listener as follows.
$ srvctl stop listener $ srvctl start listener
or
$ lsnrctl stop listener $ lsnrctl start listener
Do you want to learn Oracle Database for Beginners, then read the following articles.
https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/
