Hello everyone. I am having a problem with my apply process. I have 2 databases (10.2.0.4) which are both capturing changes, and propagating to one another. My problem is, one of the databases is not applying the changes that have propagated from the other. The changes are just sitting in the apply queue. If I go to the alert log, I see this error:
A005: warning -- apply server 1, sid 283 waiting on user sid 293 for event (since 601 seconds):
If I try and stop the apply process, I get a timeout error:
begin dbms_apply_adm.stop_apply ('APLY_FROM_CNTRL'); end;
ORA-26672: timeout occurred while stopping STREAMS process APLY_FROM_CNTRL
ORA-06512: at "SYS.DBMS_LOGREP_UTIL", line 628
ORA-06512: at "SYS.DBMS_APPLY_ADM", line 55
ORA-06512: at line 1
I was able to stop the apply process using the force option, but after I restart the apply process, I see the same errors in the alert log.
If I check v$streams_apply_reader, I see that my apply process is sitting in an IDLE state. Does anyone have any ideas? Thanks a lot.