Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: ORA-03113
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).Received on Sat May 17 2003 - 00:51:43 CDT