Re: Basic Replication Problem

"Curt Ingram" <cingramb_at_bigfoot.com> writes:

> 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
The ORA-3113 indicates that the remote Oracle server has died or there is a networking problem, probably the former.

Check in the log directory. There will probably be one or more trace files
with the prefix ora or ORA. If there are, examine them to see if any of the
files contain stack traces.

If the files contain stack traces, contact Oracle Support to see if there is a fix.

If there are no stack traces, enable Net8 or SQL*Net tracing on the local side and try the operation again. The network trace files may help to pinpoint the problem.

                                              Rick

>
>
> 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
> >
>
>
>

--

                                        Rick Wessman
                                        Security and Directory Technologies
                                        Server Technologies
                                        Oracle Corporation
                                        rwessman_at_us.oracle.com

       The statements and opinions expressed here are my own and do not
             necessarily represent those of  Oracle Corporation.