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

Comments

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

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

    ReplyDelete

Post a Comment

Popular posts from this blog

Connection refused; No available router to destination On Weblogic Node Manager Log

How to change SGA in Oracle Rac

SGA_MAX_SIZE & SGA_TARGET / MEMORY_TARGET & MEMORY_MAX_TARGET