Sunday, September 23, 2012

ORA-03135: connection lost contact

SQL*Plus: Release 10.2.0.1.0 - Production on Sun Sep 23 16:21:46 2012

Copyright (c) 1982, 2005, Oracle. All rights reserved.

ERROR:
ORA-03135: connection lost contact


workaround:
On the Oracle database server machine open file $ORACLE_HOME/network/admin/sqlnet.ora
Set parameter
SQLNET.EXPIRE_TIME=XX

xx: number



enjoy
Osama Mustafa

1 comment:

  1. Hi we have set the SQLNET.EXPIRE_TIME=unlimited

    but still we are getting error , archives are not copied to DR

    ReplyDelete