Re: Connections which go bad

From: ddf <oratune_at_msn.com>
Date: Tue, 12 Jan 2010 06:59:34 -0800 (PST)
Message-ID: <fe63cd93-8487-40fb-b210-25f232696106_at_d20g2000yqh.googlegroups.com>

On Jan 12, 3:41 am, Troels Arvin <tro..._at_arvin.dk> wrote:
> Hello,
>
> 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;
>
> BANNER
> ---------------------------------------------------
> Oracle Database 11g Release 11.1.0.7.0 - 64bit Production
> PL/SQL Release 11.1.0.7.0 - Production
> CORE    11.1.0.7.0      Production
> TNS for Linux: Version 11.1.0.7.0 - Production
> NLSRTL Version 11.1.0.7.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?
>
> --
> Regards,
> 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