Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-03113: end-of-file on communication channel --- what causes it??
Hi,
you often get this error when connection is lost to your serverside background process.
This might happen if your server dies altogether, or if your own shadow process dies (among other things). Listener problems are unlikely - listener is not involved after you have a connection.
check the servers alertlog-file, you should find an entry corresponding to your crash there.
Do you use MTS or single threaded Server ?
Karsten
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 - 08:47:42 CST
![]() |
![]() |