Connections which go bad

From: Troels Arvin <troels_at_arvin.dk>
Date: Tue, 12 Jan 2010 08:41:37 +0000 (UTC)
Message-ID: <hihck1$mge$1_at_news.net.uni-c.dk>

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

Received on Tue Jan 12 2010 - 02:41:37 CST