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 : 29-05-2017

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

  • ora-16951 : Too many bind variables supplied for this SQL statement.
  • ora-31224 : DBMS_LDAP: invalid LDAP session
  • ora-28603 : statement not permitted on empty tables
  • ora-06762 : TLI Driver: error reading orderly release
  • ora-23328 : mview base table "string"."string" differs from master table "string"."string"
  • ora-07591 : spdde: $GETJPIW failure
  • ora-26672 : timeout occurred while stopping STREAMS process string
  • ora-26725 : cannot downgrade apply handlers
  • ora-13294 : cannot transform geometry containing circular arcs
  • ora-32343 : let MVIEW engine know that it is IMPORT from 9i or earlier
  • ora-19012 : Cannot convert XML fragment to the required datatype
  • ora-24369 : required callbacks not registered for one or more bind handles
  • ora-22877 : invalid option specified for a HASH partition or subpartition of a LOB column
  • ora-01910 : TABLES keyword expected
  • ora-31013 : Invalid XPATH expression
  • ora-19100 : PASSING or RETURNING keyword expected
  • ora-07468 : spwat: mset error, unable to set semaphore.
  • ora-35276 : (SNSYN163) The format of the ALLOCATE command is: ALLOCATE varname [SOURCE svarname] [BASIS bvarname [ACROSS dimname]] [TARGET tvarname [TARGETLOG logvarname]] [ USING aggmap ]
  • ora-13625 : %s is an invalid advisor object type.
  • ora-02324 : more than one column in the SELECT list of THE subquery
  • ora-07592 : sspgprv: Error obtaining required privileges
  • ora-12442 : policy column "string" already used by an existing policy
  • ora-25013 : OLD and PARENT values cannot be identical
  • ora-16402 : ONDEMAND archival requires FAL_CLIENT and FAL_SERVER support
  • ora-16714 : the value of property string is inconsistent with the database setting
  • ora-32585 : duplicate specification of a supplemental log attribute
  • ora-23327 : imported deferred rpc data does not match string of importing db
  • ora-01334 : invalid or missing logminer dictionary processes context
  • ora-39601 : Hash key is required.
  • ora-25248 : duplicate agent specified in the agent list
  • 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.