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

I had this problem before in our Unix box. I have to use "ipcrm -m id" to remove the oracle process. You must use ipcs to find out the process first.  

Brian Chen
 -----Original Message-----
Sent: Monday, May 06, 2002 4:18 PM
To: Multiple recipients of list ORACLE-L

All,  

I had an instance crash this morning and sence then have been getting an ORA-3113 whenever I try to open it. It will startup nomount and mount, the error occurs on the open. A search on metalink showed this was likely a shared memory error and recommended a reboot, which I have now done
(fortunately this is on a development server). I'm still getting the
ORA-3113.   Anybody seen anything like this and/or have any suggestions for getting the database to open?  

TIA,
John

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Chen, Brian
  INET: Brian.Chen_at_Bowne.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).