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

I had the same experience when we were HP-UX 10.20, Oracle 7.3.4.4 and MTS was on. We switched MTS off to get around this problem.

In article <3844cd93_at_news.lhsgroup.com>,   "Cheong" <ccheong_at_my.lhsgroup.com> wrote:
> 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
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Dec 01 1999 - 13:39:55 CST