3 Replies Latest reply: Feb 2, 2013 4:46 AM by user5213229 RSS

    Enabled Propagation does not work

    473102
      Hi Experts,

      I set up Stream replication successfully on 11.2.0.2.0 (one way, some tables, dml and ddl, no custom rules). Everything worked fine until target database gets restarted.
      Now replication does not work but Capture, Propagation and Apply are enabled.

      Propagation shows errors in dba_propagation:

      ORA-01089: immediate shutdown in progress - no operations are permitted
      ORA-01089: immediate shutdown in progress - no operations are permitted
      ORA-02063: preceding line from TARGET_DB

      I tried restart of propagation by dbms_propagation.start/stop_propagation, dbms_aqadm.enable/disable_propagation_schedule and dbms_aqadm.unschedule/schedule_propagation. No effect.
      Any hints by the community?

      BTW what is expected behavior of Propagation if target DB bounces?

      Thanks
      Michael