Home » Server Options » Streams & AQ » Unable to stop propagation (
Unable to stop propagation [message #429046] Sun, 01 November 2009 13:28
Messages: 49
Registered: October 2007

We are unable to stop propagation process on our source database. the SID, Serial# mentioned in dba_scheduled_queues does not exist in gv$session.
All attempts to stop propagation using
1. dbms_aqadm.disable_propagation_schedule
2. dbms_aqadm.stop_propagation
3. alter system kill session (sid,serial#)

fail with the error : ORA-23421: job number 1380452 is not a job in the job queue

what else can we do. we recently recovered the node from a fatal error and we are not willing to reboot the node.

Please help.
Previous Topic: 10g R2 Streams and RAC
Next Topic: Error mail received from production server
Goto Forum:

Current Time: Sat Jul 31 11:15:18 CDT 2021