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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-03113: end-of-file on communication channel

RE: ORA-03113: end-of-file on communication channel

From: MacGregor, Ian A. <ian_at_SLAC.Stanford.EDU>
Date: Thu, 07 Dec 2000 09:08:30 -0800
Message-Id: <10703.123949@fatcity.com>


ORA-03113 is not perilous. It simply means that communications between the client and the server were lost. Check the alert_<SID>.log file for any amplifying information. There may also be a trace file in the udump directory. If there are
no errors you need to turn on sql*net tracing.

I'd like to have a more concise pointer to the metalink article which states that ORA-03113 errors are dangerous on NT or any other operating system. (There is of course the possibility that transactions were not committed because a program aborted.)  

Ian MacGregor
Stanford Linear Accelerator Center
ian_at_slac.stanford.edu   

-----Original Message-----
From: dthamara_at_amre.com [mailto:dthamara_at_amre.com] Sent: Thursday, December 07, 2000 5:02 AM To: RanganathK_at_lgcommerznow.com
Cc: ORACLE-L_at_fatcity.com; oracledba_at_quickdoc.co.uk Subject: Re: ORA-03113: end-of-file on communication channel

ORA-03113 IS A DANGEROUS ERROR. THERE IS TWO SOLUTION.
1 RELINK ALL THE EXE. (LIKE USING MAKE). SEE METALINK TO NT. 2.REMOVE THE PREVIOUS CLIENT OR SERVER SOFTWARE AND REINSTALL.TAKE YOUR BAKUP OF
THE DATABASE. DINESH. RanganathK_at_lgcommerznow.com on 12/07/2000 02:25:16 AM

To: ORACLE-L_at_fatcity.com, oracledba_at_quickdoc.co.uk cc: (bcc: Dinesh Thamara/AmericanRe)
Fax to:
Subject: ORA-03113: end-of-file on communication channel

Dear all,

     I am running Oracle 8.1.5 on Windows NT 4.0. I am getting the above error whenever I am changing any user's password or trying to drop the user when connected as sys or system user. Can anybody let me know the problem behind it? Any help in this regard will be very much appreciated.

TIA and regards,

Ranganath



Think you know someone who can answer the above question? Forward it to them!
to unsubscribe, send a blank email to oracledba-unsubscribe_at_LAZYDBA.com to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl

Think you know someone who can answer the above question? Forward it to them!
to unsubscribe, send a blank email to oracledba-unsubscribe_at_LAZYDBA.com to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com Received on Thu Dec 07 2000 - 11:08:30 CST

Original text of this message

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