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

Home -> Community -> Mailing Lists -> Oracle-L -> How to fix ORA-03113 error

How to fix ORA-03113 error

From: Nguyen, David M <david.m.nguyen_at_xo.com>
Date: Mon, 14 Oct 2002 16:19:02 -0800
Message-ID: <F001.004E8BB8.20021014161902@fatcity.com>


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). Received on Mon Oct 14 2002 - 19:19:02 CDT

Original text of this message

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