As Anton noted, the answer is in the trace file. 3113 in your case was
a manifest of a critical error on server side - server thread died abnormally
taking the connection down with it. Take a look at the trace file
and alert log - they will have all details on the actual problem Oracle
could gather at the time of the crash. Then open an iTAR and have
Oracle support to analyze them and (hopefully) provide you with a
remedy or recommendations.
--
Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com
Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications.
All opinions are mine and do not necessarily go in line with those of my employer.
"Arash" <arashamiri_at_hotmail.com> wrote in message
news:fa5fb486.0205110411.52bef8f1_at_posting.google.com...
> Daniel Morgan <dmorgan_at_exesolutions.com> wrote in message
news:<3CDC37BB.EE09A190_at_exesolutions.com>...
> > Arash wrote:
> >
> > > Hi!
> > > For a while our DB is running quite well for the company. Now, today
> > > some weird things happened. On trying to enter a new Datarow into a
> > > table, I got an ORA-03113. Inserting into all the other tables worked,
> > > just this one didnt.
> > >
> > > A trace-file was created.
> > >
> > > What I did now, was to dublicate the table and to copy the data from
> > > the old table into the new one and deleted the old one.
> > >
> > > Now everything works well, but why did that happen and might this
> > > happen again??
> > >
> > > thanks in advance, arash.
> >
> > Questions:
> > -------------------------------------------
> > 1. What platform?
> > 2. What operating system?
> > 3. What version of Oracle?
> > 4. What is "for a while"? One hour? One week? One month? One year?
> >
> > Crystal balls cost extra.
> >
> > Daniel Morgan
>
> Ok, here is some more detailed information:
>
> - Windows 2000 Server
> - ORACLE version 8.1.7
> - The server was now running for about 4 months.
>
> An Insert-Statement though SQL*Plus already caused the ORA-03113 (as
> mentioned before).
>
> Any known bugs there?
>
> thanks, arash.
Received on Mon May 13 2002 - 03:37:47 CDT
