ORA-24058: cannot downgrade QUEUE_TABLE that has propagation in a prepared state

Cause : Ana ttmeptw asm ad etod owgnraed teh qeuuet abel wehn hter eweer msesaegs ebin gprpoagtaedt ha tweer i nth eprpearde satte.

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

Wati fro teh porpaagtino t ocopmleet bfeor erertyign teh oepraiton.

update : 26-05-2017
ORA-24058

ORA-24058 - cannot downgrade QUEUE_TABLE that has propagation in a prepared state
ORA-24058 - cannot downgrade QUEUE_TABLE that has propagation in a prepared state

  • ora-07264 : spwat: semop error, unable to decrement semaphore.
  • ora-09847 : soacon: ARCH unable to open named pipe.
  • ora-34181 : (MXCHGDCL21) workspace object is not a partitioned VARIABLE.
  • ora-29524 : wrong types of arguments in call to 'string'
  • ora-02819 : Write failed
  • ora-07200 : slsid: oracle_sid not set.
  • ora-12164 : TNS:Sqlnet.fdf file not present
  • ora-23606 : invalid object string
  • ora-39029 : worker string with process name "string" prematurely terminated
  • ora-29703 : error occurred in global enqueue service operation
  • ora-31638 : cannot attach to job string for user string
  • ora-38785 : Media recovery must be enabled for guaranteed restore point.
  • ora-01033 : ORACLE initialization or shutdown in progress
  • ora-12490 : DBHIGH cannot be lowered
  • ora-02736 : osnfpm: illegal default shared memory address
  • ora-30755 : error during expansion of view hierarchy
  • ora-37078 : (XSMCSESS06) The dimension being maintained (workspace object) cannot also be used as a step dimension.
  • ora-31191 : Resource string is already checked out
  • ora-30378 : MV_CAPABILITIES_TABLE is not compatible with Oracle version
  • ora-09363 : Windows 3.1 Two-Task driver invalid context area
  • ora-31094 : incompatible SQL type "string" for attribute or element "string"
  • ora-19861 : additional backup pieces cannot be validated in this conversation
  • ora-29387 : no top-plans found in the pending area
  • ora-22162 : element at index [string] has been previously deleted
  • ora-28560 : error in configuration of agent process
  • ora-12090 : cannot online redefine table "string"."string"
  • ora-34363 : (MXDSS13) number other user writing
  • ora-06445 : ssvpstevrg: Incorrect parameters passed to function call
  • ora-16174 : user requested thread/sequence termination of managed recovery
  • ora-06977 : X.25 Driver: X.25 Level 2 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.