APRIL 18
Newsgroups: comp.databases.oracle
Subject: Re: ORA-3113 errors, suddenly
Keywords: 3113
References:
tgp@iglou2.iglou.com (Terry G. Phelps) writes:
>After a year of relatively trouble-free Oracle running, first on 7.1.3
>and lately on 7.1.6, I started getting ORA-3113 errors today. I don't know
>if it's relevant, but I recently upgraded my RS/6000 AIX from 3.2.5 to
>4.1.4, and then, just a few days ago, moved all applications and data to a
>new physical server, still running 4.1.4.
>I'm getting the errors on both server "batch" processes, and also on client
>PC applications running SQLNET 1. What exactly does this 3113 error mean??
>The error text says "end of file on communications channel" or something.
>Is the Oracle connection being lost? What should I do to fix this, or at
>least to isolate the problem. This is becoming a serious issue quickly.
>HELP.
The "ORA-3113" error is defined as you said as "end of file on
communications channel", which means that the process has suddenly been
killed. For example, you type "Ctrl-C" during a query, or someone issues
a "kill session" command.
However, you should be aware that this error is known to be misleading,
and is frequently a "catch-all" error, similar to the "ORA-600" error.
Sometimes if Oracle has a problem, it reports a "ORA-3113" even if that
is not the true cause.
For example, I have received the ORA-3113 error when using the "analyze
table x estimate statistics;" command. This surely does not have to do
with SQL*Net or anything associated with Oracle communications protocols.
Since you get this error even when running server "batch" processes, it
may not be a SQL*Net problem. Check to see if you use SQL*Net even when
running server-only batch jobs.
Try to isolate the problem. Look for any other error messages on
the error message stack. Check your "alert_SID.log" file to determine
what was occuring during the problem(s). Also, look for any trace files
that may have been generated.
Good luck!
-Ari Kaplan
Independent Oracle DBA Consultant
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> Visit my Web Page: www.arikaplan.com <->
<-> email: akaplan@interaccess.com <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
Back to Ari Kaplan's Home Page