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-04-2017
ORA-24080

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

  • ora-27194 : skgfdvcmd: sbtcommand returned error
  • ora-07564 : sldext: wildcard in filename or extension
  • ora-14458 : attempt was made to create a temporary table with INDEX organization
  • ora-12005 : may not schedule automatic refresh for times in the past
  • ora-02816 : Unable to kill a process
  • ora-28553 : pass-through SQL: invalid bind-variable position
  • ora-00832 : no streams pool created and cannot automatically create one
  • ora-08462 : raw buffer contains invalid decimal data
  • ora-02716 : osnpgetdatmsg: message from host had incorrect message type
  • ora-13870 : Database-wide SQL tracing is not enabled
  • ora-00453 : backgroud process 'string' is dead
  • ora-23403 : refresh group "string"."string" already exists
  • ora-00280 : change string for thread string is in sequence #string
  • ora-13026 : unknown element type for element string.string.string
  • ora-23356 : masterdef recognizes a master which does not recognize the masterdef
  • ora-27048 : skgfifi: file header information is invalid
  • ora-39020 : invalid mode type string
  • ora-19567 : cannot shrink file string because it is being backed up or copied
  • ora-25134 : keyword TABLE expected
  • ora-22341 : cannot assign supertype instance to subtype
  • ora-27062 : could not find pending async I/Os
  • ora-13124 : unable to determine column id for column string
  • ora-32116 : Buffer size is less than amount specified
  • ora-02703 : osnpopipe: pipe creation failed
  • ora-15076 : Emulating I/O errors on the OSM disk
  • ora-18003 : an outline already exists with this signature
  • ora-12564 : TNS:connection refused
  • ora-12602 : TNS: Connection Pooling limit reached
  • ora-30194 : reserved for future use
  • ora-01583 : unable to get block size of control file to be backed up
  • 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.