Oracle-L: RE: How to fix ORA-03113 error

From: Johnson, Michael <Michael.Johnson_at_oln-afmc.af.mil>
Date: Tue, 15 Oct 2002 13:10:18 -0800
Message-ID: <F001.004E9CD3.20021015131018@fatcity.com>

I am working with Oracle right now on a similar problem which looks to be like a network problem depending on the versions of what you are running. There is a bug that was fixed in 8.1.7.3 dealing with 3113 errors. Dont know what version you are running, but that could have something to do with it.

fwiw. Mike

-----Original Message-----
Sent: Monday, October 14, 2002 5:19 PM
To: Multiple recipients of list ORACLE-L

I could not start database due to ORA-03113 error, someone please advise what it means and how to fix it ASAP. I really appreciate your help.

Thanks,
David

SVRMGR> startup                                                  
ORACLE instance started.                                         
Total System Global Area                        285236752 bytes  
Fixed Size                                          48656 bytes  
Variable Size                                    75390976 bytes  
Database Buffers                                209715200 bytes  
Redo Buffers                                        81920 bytes  
Database mounted.

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

***Alert.log:

Mon Oct 14 17:57:27 2002                                
Database mounted in Exclusive Mode.                     
Completed: alter database  mount                        
Mon Oct 14 17:57:27 2002                                
alter database open                                     
Picked broadcast on commit scheme to generate SCNs      
Mon Oct 14 17:57:27 2002                                
Rolling back half complete log switch of thread 1       
LGWR: terminating instance due to error 204             
Instance terminated by LGWR, pid = 483

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Nguyen, David M
INET: david.m.nguyen_at_xo.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Johnson, Michael
INET: Michael.Johnson_at_oln-afmc.af.mil

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------