Sometimes You can get ” ORA-03135: connection lost contact ” error.
Details of error are as follows.
ORA-03136: inbound connection 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)
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
$ lsnrctl stop listener $ lsnrctl start listener
Do you want to learn Oracle Database for Beginners, then read the following articles.
1,791 views last month, 5 views today