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:
Post a Comment