My Oracle Support Banner

Unable to Unschedule Propagation. Streams Queue is Invalid (Doc ID 368237.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 to 10.2.0.1 [Release 9.2 to 10.2]
Information in this document applies to any platform.

Symptoms

Attempting to unschedule Streams propagation fails with the following error:

Exec dbms_aqadm.unschedule_propagation('STRMADMIN.Q_PLN40_DTD_TRADE','PSGDTD40.WORLD')

ERROR at line 1:
ORA-24080 : unschedule_propagation pending for QUEUE STRMADMIN.Q_PLN40_DTD_TRADE
and DESTINATION PSGDTD40.WORLD
ORA-06512 : at "SYS.DBMS_PRVTAQIP", line 1472
ORA-06512 : at "SYS.DBMS_PRVTAQIP", line 1517
ORA-06512 : at "SYS.DBMS_AQADM", line 806
ORA-06512 : at line 1



Tried the solution in Note:118884.1 but it did not help.
The propagation schedule keeps getting into "Pending" state every time we try to remove it.

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.