RE: ORA-03113

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).