| 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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
