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

From: <karsten_schmidt8891_at_my-deja.com>
Date: Thu, 02 Dec 1999 16:09:22 GMT
Message-ID: <8265iq$eeg$1@nnrp1.deja.com>

Hi,

Yes, looks like you need to contact Oracle support.

You might want to look at your core file, sometimes there is useful information in there. (like open cursors for your session)

vi /tmp/ora_17205.trc should do it.

Karsten

In article <3845ecfe_at_news.lhsgroup.com>,   "Cheong" <ccheong_at_my.lhsgroup.com> wrote:
>
> karsten_schmidt8891_at_my-deja.com wrote in message
> <823ce5$dgb$1_at_nnrp1.deja.com>...
> >Hi,
> >
> > you often get this error when connection is lost to your serverside
> > background process.
>
> All necessary background processes are running no problem.
>
> >
> > 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.
> >
>
> On following the server alert log when the select statement is issued,
I
> get:
> Thu Dec 2 11:41:02 1999
> Errors in file /tmp/ora_17205.trc:
> ORA-07445: exception encountered: core dump [11] [0] [0] [0] [] []
>
> SQL> ! oerr ora 7445
> 07445, 00000, "exception encountered: core dump [%s] [%s] [%s] [%s]
[%s]
> [%s]"
> // *Cause: An OS exception occurred which should result in the
creation of a
> // core file. This is an internal error.
> // *Action: Contact your customer support representative.
>
> SQL>
>
> Core file is generated by Oracle indeed, but it is of not much use to
me ---
> looks like contacting Oracle Support is inevitable... Or, perhaps,
Oracle
> 7.3.2.2.0 has got a bug that causes this errror...
>
> > Do you use MTS or single threaded Server ?
>
> Single threaded:
> SVRMGR> show parameter mts
> NAME TYPE VALUE
> ----------------------------------- -------

---

> mts_dispatchers string
> mts_listener_address string
(address=(protocol=ipc)(key=%s
> mts_max_dispatchers integer 0
> mts_max_servers integer 0
> mts_multiple_listeners boolean FALSE
> mts_servers integer 0
> mts_service string ijk
> SVRMGR>
>
> >
> >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.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Dec 02 1999 - 10:09:22 CST