Re: ora-03113 & ora-03114

From: A. Bardeen <abardeen1_at_yahoo.com>
Date: Mon, 19 Nov 2001 02:34:25 -0800
Message-ID: <F001.003C84A2.20011119021042@fatcity.com>

Donnie,

Core dumps on NT don't record any errors in the alert.log the way they do on Unix platforms. They will typically create a <sid>CORE.LOG file in either bdump, udump or the default
%ORACLE_HOME%\RDBMS73\TRACE directory. If you're lucky it will contain a stack trace that might be useful to help narrow down the common denominator.

Have you checked the event viewer for any errors? When was the last time the server was rebooted?

Given that this is a 7.3.3 db, however, there's not much advice I can give.

HTH,

• Anita
  • "Shaw, Donnie" <dshaw_at_acsalaska.com> wrote:
    > I recently rebuild several tables/indexes on a
    > v7.3.3 database on nt 4.0
    > sp4. Most to all of the table rebuilds included
    > changing the initial extent.
    >
    > A fews days later we started experiencing
    > ora-03113/03114 errors on the
    > client side. This is a small database/applications
    > which serves a small user
    > base, 10 - 15 users.
    > There is no relevant information in the alter log,
    > nor am I generating any
    > trace files. This listener is up and from a network
    > stand point we are not
    > receiving any packet errors or collisions.
    > The database starts up fine and everyone can connect
    > with no problems. After
    > being logged in and working for a certain amount
    > time the users loose their
    > connection. This problem isn't isolated to certain
    > users or machines. For
    > that matter nor the views or tables they are
    > accessing either.
    > Has anyone ran into this situation and if so how did
    > you identify and
    > resolve the issue.
    > thanks,
    >
    > Donnie Shaw
    

    ---

Do You Yahoo!?
Find the one for you at Yahoo! Personals http://personals.yahoo.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: A. Bardeen
  INET: abardeen1_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 may
also send the HELP command for other information (like subscribing).

Received on Mon Nov 19 2001 - 04:34:25 CST