Re: Basic Replication Problem

Ah, the good old 3113 error, don't you just love it?!

Rick's comments in his reply will head you down the right track. I just wanted to add the snapshot trace files will have 'SNP' in their name somewhere, so do a find on Unix (can't remember if they're upper or lower case, so do both), or Find Files on NT to find them.

HTH. Pete

Curt Ingram wrote:

> The following is the text showing the command and the error returned :
>
> CREATE SNAPSHOT book.accounts AS SELECT * FROM
> book.accounts_at_bki.world
> *
> ERROR at line 1:
> ORA-02068: following severe error from BKI
> ORA-03113: end-of-file on communication channel
>
> There isn't any information regarding the failure in the alert files and I
> can't find the "snapshot trace files".
>
> Pete Sharman <psharman_at_us.oracle.com> wrote in message
> news:386A8BD8.B5005479_at_us.oracle.com...
> > Curt
> >
> > What's the following error? There should be another one that tells you
> what the
> > real problem is. At a guess, if this is the largest snapshot do you have
> > problems with a rollback segment filling up or something similar?
> >
> > The files that you'd need to look at are the alert log and snapshot trace
> files,
> > but I don't know if they'd have the problem recorded in them. The
> snapshot
> > trace files will be under the BACKGROUND_DUMP_DEST directory.
> >
> > HTH.
> >
> > Pete
> >
> > Curt Ingram wrote:
> >
> > > Here are the facts:
> > >
> > > One main database is being replicated to two separate sites using basic
> > > replication. At the main site, I created snapshot logs for all the
> tables
> > > to be replicated. At the first replicated site I created all the
> snapshots
> > > and the snapshot refresh group and replication is running seamlessly
> there.
> > > At the second site however, most of the snapshots create just fine but
> any
> > > attempt to create one particular one ( happens to be the largest)
> returns
> > > with the following error :
> > >
> > > ORA-02068: following severe error from name Cause: A severe error, a
> > > disconnect or fatal Oracle error, was received from the
> > > given database link.
> > >
> > > I suspect that something is filling up at the main site but I can't find
> any
> > > logfiles which tell me what is going on. Can anyone point me in the
> > > direction of logfiles or anything else which might give me a clue as to
> what
> > > is going on ?
> > >
> > > Thanks,
> > > Curt Ingram
> > > Las Vegas, NV
> >

Received on Thu Dec 30 1999 - 11:13:23 CST