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

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: Mon Sep 26 04:20:03 CDT 2016

Total time taken to generate the page: 0.13327 seconds