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

From: Cheong <ccheong_at_my.lhsgroup.com>
Date: Thu, 2 Dec 1999 12:00:22 +0800
Message-ID: <3845ecfe@news.lhsgroup.com>

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.
Received on Wed Dec 01 1999 - 22:00:22 CST