Wednesday, August 8, 2012

How to resolve ORA-03135: connection lost contact?


When Oracle database clients, for example, PL/SQL developer, stay in idle state, after some time they'll be disconnected from Oracle database server. In such case oracle db server timed out the connection. While trying to re-run PL/SQL you'll get ORA-03135 error.
Workaround:
On the Oracle database server machine open file $ORACLE_HOME/network/admin/sqlnet.ora

Set parameter 
SQLNET.EXPIRE_TIME=XX

where XX specifies a time interval, in minutes, to send a check to verify that client/server connections are active.

No comments: