Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-03113: end-of-file on communication channel
Agreed... OWS confessed to me that 3113's sometimes behave as catch-all
error message which in effect means "something's wrong." Generally it's a
network problem but not always. Check out chapter 12 of the Net8 admin
guide. You can do a level 16 trace and use trcasst to try to determine the
root cause. You may want to have your network dweebs review the output of
trcasst. They'll need to refer to the "Using the Trace Assistant to Examine
Your Trace Files" section to help them interpret the output of trcasst. I
once struggled with this for 2 weeks before the problem was solved.
Good luck,
Steve Orr
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of K
Gopalakrishnan
Sent: Thursday, December 07, 2000 1:01 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: ORA-03113: end-of-file on communication channel
Hi !
3113 is bit different from other oracle errors. Basically this message is generated from the client side (where as most of the other messages are from the rdbms kernel at the server side).
You can not set events or some other diagnostic tools to get the systemstate/processstate dumps during this errors.
This may be a network problem. Check with your Network guys and tell them there **IS** some issue in the network (to oracle) and ask thm to fix that.
By Anychance are you connecting across firewalls/ or WAN?
Best Regards,
K Gopalakrishnan,
Bangalore, INDIA
> Dear all,
>
> I am running Oracle 8.1.5 on Windows NT 4.0. I am getting the above
> error whenever I am changing any user's password or trying to drop the
user
> when connected as sys or system user. Can anybody let me know the problem
> behind it? Any help in this regard will be very much appreciated.
>
> TIA and regards,
>
> Ranganath
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: RanganathK_at_lgcommerznow.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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.com -- Author: K Gopalakrishnan INET: kaygopal_at_yahoo.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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 mayReceived on Fri Dec 08 2000 - 10:39:57 CST
![]() |
![]() |