ORA-03135: connection lost contact
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.