ORA-03113: end-of-file on communication channel --- what causes it??

Hi:

Surely someone has come across or known about this oracle error.

I telnet into an HP-UX 10.20 running oracle 7.3.2.2.0, invoke sqlplus, connect to the database, and execute a "big" select statement.

After some 15 minutes, I get:

SQL> SELECT TM1.TMCODE, 1, to_date('13-NOV-1999','DD-MON-YYYY'), 'P', TM1.SPCODE, TM1.SNCODE,
  2 TM1.SRVIND, TM1.ECHIND, TM1.AMTIND, TM1.FRQIND, TM1.SUBSCRIPT, TM1.ACCESSFEE, TM1.EVENT,
  3 TM1.PROIND, TM1.ADVIND, TM1.SUSIND, TM1.SUBGLCODE, TM1.ACCGLCODE, TM1.USGGLCODE, TM1.SUBJCID,
  4 TM1.ACCJCID, TM1.USGJCID, TM1.SUBSERV_CATCODE, TM1.SUBSERV_CODE, TM1.SUBSERV_TYPE, TM1.ACCSERV_CATCODE,
  5 TM1.ACCSERV_CODE, TM1.ACCSERV_TYPE, TM1.USGSERV_CATCODE, TM1.USGSERV_CODE, TM1.USGSERV_TYPE, TM1.CSIND,   6 TM1.CLCODE, TM2.EGCODE, TM1.DEPOSIT, 1 FROM MPULKTM1 TM1, MPULKTM2 TM2   7 WHERE TM1.TMCODE = 123 AND TM1.TMCODE = TM2.TMCODE(+) AND TM1.SPCODE = TM2.SPCODE(+) AND TM1.SNCODE = TM2.SNCODE(+)   8 AND 'U' = TM2.USGIND(+); ERROR:
ORA-03113: end-of-file on communication channel

SQL>
SQL> select *
  2 from v$database;
from v$database

              *
ERROR at line 2:
ORA-03114: not connected to ORACLE

What might be the cause? And what is the best approach to handle this problem?

Any suggestion is very much appreciated.

Thank you and have a good day.

Regards,
Cheong Received on Wed Dec 01 1999 - 01:34:04 CST