Re: Basic Replication Problem

From: Curt Ingram <cingramb_at_bigfoot.com>
Date: Wed, 29 Dec 1999 23:22:27 -0800
Message-ID: <84f17l$kmm$1@ash.prod.itd.earthlink.net>

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 - 01:22:27 CST