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: Simo Vilmunen <svilmune_at_ratol.fi>
Date: Mon, 19 May 2003 02:51:40 -0800
Message-ID: <F001.0059C4AB.20030519025140@fatcity.com>


Hi,

I experienced the same error when creating db with 9.2.0.3 / 9.2.0.1 and most likely it's the glibc version(atleast on my case), kernel parameters are sized correctly and directories with correct permissions etc are there. I managed to install it ok earlier when i had older glibc version, but now only error I get in alert log is:

ORA-07445: exception encountered: core dump [skgmidrealm()+702] [SIGSEGV] [Address not mapped to object] [0x80AFBFFC] [] []

Have to see what comes up when I downgrade glibc, hopefully its the new version it. Also found info on some forums that people have had problems with it.

My playground box is debian so always little bit fun to solve these problems which come up. :)

Cheers,
Simo

On Sun, 18 May 2003, Ramon E. Estevez wrote:

> Tks Kirti,
>
> I had read it before. As the matter of fact, the dbs directory wasn’t
> created when I read the note, I created it and the same error.
>
> Some papers talk about a patch of the glibc, I downloaded and trying to
> figure out how to set ftp in the suse box to transfer the patch and
> apply it .
>
> New in linux - unix world.
>
> Thanks
>
> Ramon E. Estevez
> restevez_at_blh.com.do
> 809-535-8994
>
>
>
> -----Original Message-----
> Kirti
> Sent: Sunday, May 18, 2003 12:37 PM
> To: Multiple recipients of list ORACLE-L
>
>
> I found a note #122388.1 when I searched Metalink for 'ORA-3113 when
> creating database'.
> There are several other forum discussions on the same topic that may be
> of help :)
>
> - Kirti
>
> -----Original Message-----
> Sent: Saturday, May 17, 2003 9:27 AM
> To: Multiple recipients of list ORACLE-L
>
>
> 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: Ramon E. Estevez
> > INET: restevez_at_blh.com.do
> >
> > 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).
> >
>
> --
> Mladen Gogala
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Mladen Gogala
> INET: mgogala_at_adelphia.net
>
> 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.net
> --
> Author: Ramon E. Estevez
> INET: restevez_at_blh.com.do
>
> 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.net
> --
> Author: Deshpande, Kirti
> INET: kirti.deshpande_at_verizon.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.net
> --
> Author: Ramon E. Estevez
> INET: restevez_at_blh.com.do
>
> 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.net
-- 
Author: Simo Vilmunen
  INET: svilmune_at_ratol.fi

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 May 19 2003 - 05:51:40 CDT

Original text of this message

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