ORA-24080: unschedule_propagation pending for QUEUE string and DESTINATION string

Cause : A propagation administration command was issued for a queue and destination pair whose propagation is being unscheduled.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Do not issue propagation administration commands for a propagation schedule on which there is a pending unschedule request.

update : 26-09-2017

ORA-24080 - unschedule_propagation pending for QUEUE string and DESTINATION string
ORA-24080 - unschedule_propagation pending for QUEUE string and DESTINATION string

  • ora-32028 : Syslog facility or level not recognized
  • ora-02213 : duplicate PCTUSED option specification
  • ora-39148 : unable to import data into pre-existing queue table string. Table_exists_action of string being ignored for this table
  • ora-25219 : enqueue failed, sequence deviation not allowed for queue string.string
  • ora-27060 : could not set close-on-exec bit on file
  • ora-22900 : the SELECT list item of THE subquery is not a collection type
  • ora-01115 : IO error reading block from file string (block # string)
  • ora-28001 : the password has expired
  • ora-23368 : name string cannot be null or the empty string
  • ora-39766 : invaid stream specified for column array conversion
  • ora-36673 : (XSDPART11) Use simple leaf values to identify concat dimension values in a VALUES LESS THAN clause, rather than the format.
  • ora-30068 : Internal Event to turn on nested
  • ora-28101 : policy already exists
  • ora-28660 : Partitioned Index-Organized table may not be MOVEd as a whole
  • ora-16750 : resource guard encountered errors while activating logical primary database
  • ora-31105 : User does not own lock "string"
  • ora-14189 : this physical attribute may not be specified for an index subpartition
  • ora-31530 : could not find published column string for CDC subscriber view string.string
  • ora-33070 : (XSAGDNGL34) In AGGMAP workspace object, all QDRs of dimension workspace object must map to the same dimension position.
  • ora-28523 : ORACLE and heterogeneous agent are incompatible versions
  • ora-23382 : materialized view repgroup "string"."string" is not registered at site string
  • ora-39777 : data saves are not allowed when loading lob columns
  • ora-32058 : operation restricted to SYSDBA users
  • ora-33086 : (XSAGINIT01) AGGMAP workspace object cannot be dimensioned by a conjoint dimension.
  • ora-10586 : Test recovery had to corrupt 1 data block in order to proceed
  • ora-24027 : AQ HTTP propagation encountered error, status-code string, string
  • ora-13643 : The task can not be interrupted or cancelled.
  • ora-02701 : osnoraenv: error translating oracle image name
  • ora-02055 : distributed update operation failed; rollback required
  • ora-06042 : NETDNT: message receive failure
  • Oracle Database Error Messages

    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.