ORA-24056: internal inconsistency for QUEUE string and destination string

Cause : Thes equnece unmbesr usde int he YSS.A$Q_PRPOAGAITON_TSATU Stabel weer inocnsitsentf or hte gvien uqeuea nd edstiantio.n

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

Conatct rOacl eWordlwid eSupoprt.

update : 27-04-2017
ORA-24056

ORA-24056 - internal inconsistency for QUEUE string and destination string
ORA-24056 - internal inconsistency for QUEUE string and destination string

  • ora-28108 : circular security policies detected
  • ora-19776 : PROXY restore to ASM diskgroup "string" is not supported.
  • ora-02710 : osnpop: fork failed
  • ora-13609 : The specified task string must be executing to be cancelled or interrupted.
  • ora-16704 : cannot modify a read-only property
  • ora-02155 : invalid DEFAULT tablespace identifier
  • ora-00234 : error in identifying or opening snapshot or copy control file
  • ora-16003 : standby database is restricted to read-only access
  • ora-28028 : could not authenticate remote server
  • ora-01299 : dictionary string corresponds to a different database incarnation
  • ora-31116 : Tablespace not specified correctly
  • ora-14084 : you may specify TABLESPACE DEFAULT only for a LOCAL index
  • ora-30063 : Internal Event to Test NTP
  • ora-30102 : 'string' is not in the legal range for 'string'
  • ora-19670 : file string already being restored
  • ora-02750 : osnfsmmap: cannot open shared memory file ?/dbs/ftt_.dbf
  • ora-16953 : Type of SQL statement not supported.
  • ora-37174 : source SQL must be a SELECT statement
  • ora-07255 : spini: cannot set up signal handler.
  • ora-32809 : foreign queue string is already registered
  • ora-36634 : (XSDUNION02) INTEGER dimension workspace object cannot be used as a concat dimension base.
  • ora-02290 : check constraint (string.string) violated
  • ora-28513 : internal error in heterogeneous remote agent
  • ora-01278 : error creating file 'string'
  • ora-02776 : Value for request done signal exceeds maximum
  • ora-31165 : cannot load object-relational XML attribute using direct path
  • ora-39127 : unexpected error from call to string string
  • ora-38501 : sub-query not allowed in the expression
  • ora-19712 : table name exceeds maximum length of string
  • ora-19043 : Multiply nested XMLROOT function disallowed
  • 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.