ORA-03113 on connection to one out of 4 databases on the same machine

This is a very weird issue.. I have tried different clients (9.2.0.6,10.1, 10.2) and getting similar 'results'.

The weird part is that the machine that this connects 2 has 4 databases running, and this is the only database that has these issues. The machine has 2x9.2.0.7 databases running, 1x10g (10.2.0.1) enterprise and this is a 10g database standard (10.2.0.2).. it's patched vs the enterprise version b/c I was hoping this issue would go away. The config's between the databases are almost identical (except for some memory parameters, but all generally have a ~400M overall SGA).. each has it's own listener.

The issue is not easily reproduceable, but one can be almost certain that he'll receive an ORA-0313 at some poing during the session, weather it's on a log out or while trying to execute a query. None of the 3 other databases experience this issue. The install is from the same installation files as the 10g enterprise install.. I tried relinking oracle (std) as well. there is absolutely nothing in any of the dump directories or alert.log

$sqlplus system_at_dev4

SQL*Plus: Release 10.1.0.2.0 - Production on Thu Apr 27 16:13:41 2006

Copyright (c) 1982, 2004, Oracle. All rights reserved.

Connected to:
Oracle Database 10g Release 10.2.0.2.0 - 64bit Production

system_at_DEV4> select 1 from dual;

         1

         1

Elapsed: 00:00:00.01
system_at_DEV4> select 1 from dual;

         1

         1

Elapsed: 00:00:00.00
system_at_DEV4> select 1 from dual;

         1

         1

Elapsed: 00:00:00.01
system_at_DEV4> select 2 from dual;

         2

         2

Elapsed: 00:00:00.00
system_at_DEV4> select 3 from dual;

         3

         3

Elapsed: 00:00:00.00
system_at_DEV4> select 4 from dual;

         4

         4

Elapsed: 00:00:00.01
system_at_DEV4> select 5 from dual;

         5

         5

system_at_DEV4>
system_at_DEV4> ERROR:
ORA-03113: end-of-file on communication channel

• that was on logout (control-d)

here's another one

system_at_DEV4> select 1 from dual;
select 1 from dual
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel

ERROR:
ORA-03114: not connected to ORACLE
.......
We run Oracle 9.2.0.6 on RH4 AMD
we are currently looking for a DBA
remove NSPAM to email Received on Thu Apr 27 2006 - 16:10:36 CDT