Re: Troubleshooting Replication

On May 5, 12:59 am, Valentin Minzatu <valentinminz..._at_yahoo.com> wrote:
> On May 4, 11:48 am, siva.thirumai..._at_gmail.com wrote:
>
>
>
>
>
> > Hi,
>
> > I am facing issues with the MultiMaster Replication implemented on the
> > Oracle 8i Databases. I am getting the following error while
> > reexecuting the errors generated by the deferred transactions through
> > OEM. Please let me know if there is any alternate way to handle the
> > errors occured during the execution of the deferred transactions which
> > are executed automatically.
>
> > Statement:-------------------------------
> > Begin
> > DBMS_DEFER_SYS.EXECUTE_ERROR(...
> > ...);
> > End
>
> > Stack Trace:-----------------------------
>
> > ORA-01403: no data found
> > ORA-01403: no data found
> > ORA-06512: at"SYS.DBMS_DEFER_SYS_PART1", line 430
> > ORA-06512: at"SYS.DBMS_DEFER_SYS", line 1632
> > ORA-06512: at"SYS.DBMS_DEFER_SYS", line 1678
> > ORA-06512: at line 2
>
> > Please let me know if there is any other method to resolve this issue
> > in lesser time.
>
> > Thanks in advance!!!
>
> Take a look at the DBMS_RECTIFIER_DIFF package (Replication Management
> API Reference doc). It has two procedures which would help you solve
> the issue.
> Valentin- Hide quoted text -
>
> - Show quoted text -

Hi Valentin,

Thanks a lot for your guidance!!!

However, I would like to confirm one thing with you. Since the replication is MULTIMASTER and the replicated schema is updated in each and every site independently. Hence, will this solution be applicable for the MULTIMASTER Replication as I have to update the latest data.

Thanks in advance Received on Mon May 07 2007 - 10:46:34 CDT