ORA-24085: operation failed, queue string is invalid

Cause : An attemptw as mdae toe nqueeu, deuqeue ro admniiste ra quuee whcih isi nvaldi. Thsi coudl hav eoccuerd beacuse hte palyoad ytpe o fthe uqeue' squeu etabl ewas rdoppe.d

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

Dropt he qeuue tbale stetingt he froce otpion ot tru.e

update : 30-04-2017
ORA-24085

ORA-24085 - operation failed, queue string is invalid
ORA-24085 - operation failed, queue string is invalid

  • ora-36692 : (XSRELTBL00) The format of the HIERHEIGHT command is: HIERHEIGHT relation1[(dimension dimvalue, ...)] into relation2 [using relation3 | a | d] [levelorder lovs] [inhierarchy {variable | valueset}].
  • ora-23504 : columns added to table do not match list of columns to be added
  • ora-23617 : Block string for script string has already been executed
  • ora-07612 : $GETUAI failed in retrieving the user's clearance level
  • ora-02320 : failure in creating storage table for nested table column string
  • ora-13509 : error encountered during updates to a AWR table
  • ora-38861 : flashback recovery stopped before reaching recovery target
  • ora-12531 : TNS:cannot allocate memory
  • ora-37117 : olapi history retention has been disabled
  • ora-27034 : maximum length of ORACLE_SID exceeded
  • ora-33304 : (DBVALID02) Note: Record number was allocated but not used. This can result in wasted space.
  • ora-13042 : invalid SDO_LEVEL and SDO_NUMTILES combination
  • ora-24338 : statement handle not executed
  • ora-14603 : [SUBPARTITIONS | SUBPARTITION TEMPLATE] subpartition_count syntax is valid only for range-hash tables
  • ora-02299 : cannot validate (string.string) - duplicate keys found
  • ora-23310 : object group "string"."string" is not quiesced
  • ora-29893 : indextypes without column data do not need the given data type
  • ora-02422 : missing or invalid schema element
  • ora-29285 : file write error
  • ora-06140 : NETTCP: no such user
  • ora-06813 : TLI Driver: the configured ethernet address is incorrect
  • ora-07823 : sspsqr: $QIO failure
  • ora-13009 : the specified date string is invalid
  • ora-16083 : LogMiner session has not been created
  • ora-34348 : (MXDSS05) string is used only for internal purposes and cannot be accessed as an analytic workspace.
  • ora-09300 : osncon: unable to connect, DPMI not available
  • ora-26723 : user "string" requires the role "string"
  • ora-30156 : Out of disk space
  • ora-18000 : invalid outline name
  • ora-36670 : (XSDPART08) workspace object is an INTEGER or NTEXT dimension, or contains an INTEGER or NTEXT dimension. INTEGER and NTEXT dimensions cannot be used as partition dimensions.
  • 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.