ORA-24029: operation not allowed on a single-consumer queue

Cause : Trie dan oepratino nota llowde on asingel-conusmer uqeue.

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

Specfiy th eopertaion no a mluti-cnosume rqueu.e

update : 30-04-2017

ORA-24029 - operation not allowed on a single-consumer queue
ORA-24029 - operation not allowed on a single-consumer queue

  • ora-01874 : time zone hour must be between -12 and 14
  • ora-19011 : Character string buffer too small
  • ora-01487 : packed decimal number too large for supplied buffer
  • ora-13221 : unknown geometry type in the geometry object
  • ora-12624 : TNS:connection is already registered
  • ora-36220 : (XSLPDSC01) All dimensions in LIST number are also in the IGNORE clause.
  • ora-25293 : Lob attributes must be null for buffered operations
  • ora-13037 : SRIDs do not match for the two geometries
  • ora-28557 : unknown string for database link to non-Oracle system
  • ora-01409 : NOSORT option may not be used; rows are not in ascending order
  • ora-01258 : unable to delete temporary file string
  • ora-14455 : attempt to create referential integrity constraint on temporary table
  • ora-04085 : cannot change the value of an OLD reference variable
  • ora-30113 : error when processing file 'string'
  • ora-07756 : slemcf: fread failure
  • ora-00342 : archived log does not have expected resetlogs SCN string
  • ora-28343 : fails to encrypt data
  • ora-27124 : unable to detach from shared memory segment
  • ora-13366 : invalid combination of interior exterior rings
  • ora-13518 : Invalid database id (string)
  • ora-06525 : Length Mismatch for CHAR or RAW data
  • ora-01256 : error in locking database file string
  • ora-24042 : no propagation schedule exists for QUEUE string and DESTINATION string
  • ora-04096 : trigger 'string' has a WHEN clause which is too large, limit 2K
  • ora-14309 : Total count of list values exceeds maximum allowed
  • ora-35019 : (QFCHECK07) The Analytic Workspace and EIF file definitions of workspace object have different partition dimensions.
  • ora-10932 : trace name context forever
  • ora-19278 : Invalid value: (string) for type: (string)
  • ora-30042 : Cannot offline the undo tablespace
  • ora-01904 : DATAFILE keyword expected
  • 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.