Re: Connections which go bad
From: joel garry <joel-garry_at_home.com>
Date: Tue, 12 Jan 2010 10:07:30 -0800 (PST)
Message-ID: <0af07f89-90a0-4575-a6ef-eca4343576db_at_g25g2000yqd.googlegroups.com>
On Jan 12, 12: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
Date: Tue, 12 Jan 2010 10:07:30 -0800 (PST)
Message-ID: <0af07f89-90a0-4575-a6ef-eca4343576db_at_g25g2000yqd.googlegroups.com>
On Jan 12, 12: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
Don't know anything about jdbc, but I do see some timeout references in the FAQ http://www.oracle.com/technology/tech/java/sqlj_jdbc/htdocs/jdbc_faq.html and MOS 559564.1 looks interesting.
Also be sure nothing on the OS side is happening to kill the processes.
jg
-- _at_home.com is bogus. http://ghosteleven-ghost.blogspot.com/Received on Tue Jan 12 2010 - 12:07:30 CST