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

Re: ORA-03113

From: Stephane Faroult <sfaroult_at_oriole.com>
Date: Sat, 17 May 2003 09:01:39 -0800
Message-ID: <F001.0059BD67.20030517090139@fatcity.com>


Ramon,

   I cannot tell you anything more than what Mladen did : check trace files (possibly sqlnet.log as well) and look for more details. A process crashed, and you should find something under bdump or udump. There is probably an indication

    "OS Error :" followed by a number.

Grep /usr/include/errno.h (or perhaps /usr/include/sys/errno.h) for this number, it should helpyou find out which resource you cannot get.

HTH SF

"Ramon E. Estevez" wrote:
>
> Mladen and Barbara,
>
> There is not DB created in the server, this error is when I try to
> create the DB in the server either using the dbassist or svrmgrl. I am
> working in the server, not thru the client.
>
> TIA
>
> Ramon E. Estevez
> restevez_at_blh.com.do
> 809-535-8994
>
> -----Original Message-----
> Gogala
> Sent: Saturday, May 17, 2003 12:52 AM
> To: Multiple recipients of list ORACLE-L
>
> Ramon, ORA-03113 is a "catch all" client error which tells you that
> communication with the database server was either broken or could not be
> established at all. The oerr utiity is, as expected, extremely helpful
> Here is it what it says:
>
> $ oerr ora 3113
> 03113, 00000, "end-of-file on communication channel"
> // *Cause:
> // *Action:
> $
>
> That, essentially means something like "the database side is not talking
> to me". The error is usually on the database side. There should be files
> with extenstions
> like ".trc" and names like alert_<Oracle Sid>.log to help you out with
> the
> database side. Situation that Barbara has mentioned happened because the
> second thread could not acquire it's rollback segments, so thread failed
> to start.
> Client process that was trying to contact the thread would, naturally,
> receive
> ORA-03113. Another situation is when you actually install OPS (RAC)
> software without having the DLM (cluster manager) installed. If you
> don't have OPS hardware, don't install the software because it's only
> going to mess things up. This is as much guesswork as I'm willing to do
> at 1 A.M.
> Please, find the trace files and the alert log and come back with more
> info.
>
> On 2003.05.16 22:51 Ramon E. Estevez wrote:
> > Hi list,
> >
> > Missing something need your help.
> >
> > I'm trying to create a 8.1.7 DB in Suse 7.2 and I'm getting an
> > ORA-03114 error with de Dbassist and the ORA-03113 when trying
> > manually using svrmgrl.
> >
> > I adjusted the semaphores, relinked the kernel. Checked a lot of
> > documents in Metalink but nothing.
> >
> >
> > TIA
> >
> > Ramon E. Estevez
> > restevez_at_blh.com.do
> > 809-535-8994
> >

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: sfaroult_at_oriole.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 Sat May 17 2003 - 12:01:39 CDT

Original text of this message

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