ORA-03135: connection lost contact

Published by Ahmad on

The ORA-03135 error is common when

1) Server unexpectedly terminated or was forced to terminate.

or

2) Server timed out the connection.

Solution–:

1) Check if the server session was terminated.

2) Check if the timeout parameters are set properly in
sqlnet.ora file.

In my Case i set these 2 parameters in the SQLNET.ora file ($ORACLE_HOME/network/admin/sqlnet.ora) & issue was resolved.

SQLNET.EXPIRE_TIME=0

SQLNET.INBOUND_CONNECT_TIMEOUT=0

Please do the Like, Comments & Share in your circle.

Thanks

With Best Wishes!!!!

Ahmad

ACE Associate
Cloud Architect
Oracle Database Consultant

Certified in-: | 1XAzure | 6XOCI | 1XOCS (GG) | 1XOCE (RAC) | 3XOCP (11g,10g,9i) | 1XOCA (9i) |

My YouTube Channel (OracleRide)
http://www.youtube.com/c/OracleRide

Reference–: (Doc ID 787354.1)ORA-3135 Connection Lost Contact 


1 Comment

Mustapha Abubakar · May 15, 2021 at 2:31 pm

Hello,
For me i set the inbound parameter to 180 and that resolved my issue.

Leave a Reply

Your email address will not be published. Required fields are marked *