Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: ORA-03113
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