Re: Replication

Rick Wessman wrote:

> rchamart_at_thunder.temple.edu (Ramanarao Chamarty) writes:
>
> > 1: Looks like your DB Links are not working ( end -of- communication error).
> The links may be failing because the server is dying due to a bug. Check the
> log directory to make sure that there are no logs with stack traces. If there
> are, Oracle Support should be contacted to see if there is a fix.

DB Links is working. But this error (end-of-communication) occurs sometimes. If I execute
replication once more it proceeds correctly. But error (ORA-02051: another session in same transaction failed; is first time) appeared for the first time.
And other same snapshot sites refreshing correctly without error ORA-02051, but with error (end-of-communication).
I think that it is a bug of PO 8.0.3

> > 2: Also What type of replication are you implementing. (Basic - Read only
> > Snapshot or Basic-Update Snapshot).

I am using Basic-Update Snapshot

> > 3: Are you using any other tools ( rep.mgr).

Yes. I am using Replication Manager

> > 4: While configuring ( based on error - look like you are trying to
> > implement update snapshots - would require a rollback segment)
> > Look into the manual for setting up basic replication. It can help you
> > get started.
 

> > HTH.
> >
> > Ramana
> > rchamart_at_temple.edu
> > Tue, 04 Jan 2000 13:15:51 +0300 Anton Shumilov (anton_at_tatalc.ru) wrote:
> > : ERROR at line 1:
> > : ORA-02051: another session in same transaction failed
> > : ORA-02063: preceding line from DB
> > : ORA-02055: distributed update operation failed; rollback required
> > : ORA-02068: following severe error from DB
> > : ORA-03113: end-of-file on communication channel
> > : ORA-06512: at "SYS.DBMS_SNAPSHOT", line 380
> > : ORA-06512: at "SYS.DBMS_IREFRESH", line 450
> > : ORA-06512: at "SYS.DBMS_REFRESH", line 182
> > : ORA-06512: at line 1
> > :
> > : What does it mean?
> > : How solve this problem?
> > : Help me plz.
> > : I have Oracle 8.0.4 server on NT4 and Personal Oracle 8.0.3 on snapshot
> > : site on NT4.
> > :
>
> --
> 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.
Received on Wed Jan 05 2000 - 00:00:00 CET