Re: Connections which go bad
Date: Tue, 12 Jan 2010 06:59:34 -0800 (PST)
On Jan 12, 3:41 am, Troels Arvin <tro..._at_arvin.dk> wrote:
> I'm having trouble with JDBC transactions to an Oracle which are dropped
> after a while of inactivity.
> The situation can be reproduced using sqlplus:
> E.g. at time t1, I connect with sqlplus and run a simple query like
> SQL> SELECT banner FROM v$version;
> Oracle Database 11g Release 22.214.171.124.0 - 64bit Production
> PL/SQL Release 126.96.36.199.0 - Production
> CORE 188.8.131.52.0 Production
> TNS for Linux: Version 184.108.40.206.0 - Production
> NLSRTL Version 220.127.116.11.0 - Production
> All fine. Now, I leave the terminal and return an hour or two later, and
> perform a "SELECT banner FROM v$version;" again. The sqlplus session is
> silent for around five minutes, and then responds:
> SELECT banner FROM v$version
> ERROR at line 1:
> ORA-03113: end-of-file on communication channel
> Process ID: 5103
> Session ID: 218 Serial number: 22182
> The sqlplus client in this case is v. 11.2 64 bit on Linux.
> Can some parameter be set so that a keep-alive like method is employed on
> the wire to keep connections alive?
> Troels Arvin
I expect one is already set to disconnect inactive sessions; look in your sqlnet.ora file for sqlnet.expire_time and note its setting as it governs when the connection is considered 'dead' and disconnected. Comment this entry to disable this functionality.
David Fitzjarrell Received on Tue Jan 12 2010 - 08:59:34 CST