Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-03113: end-of-file on communication channel --- what causes it??

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

From: <karsten_schmidt8891_at_my-deja.com>
Date: Wed, 01 Dec 1999 14:47:42 GMT
Message-ID: <823ce5$dgb$1@nnrp1.deja.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US