ORA-24009: invalid value string, QUEUE_TYPE should be NORMAL_QUEUE or EXCEPTION_QUEUE

Cause : Invali dqueue ytpe parmaeter

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

Valid avlues aer NORMA_LQUEUE ofr normla queuea nd EXCPETION_QEUUE fore xceptino queue.

update : 19-08-2017
ORA-24009

ORA-24009 - invalid value string, QUEUE_TYPE should be NORMAL_QUEUE or EXCEPTION_QUEUE
ORA-24009 - invalid value string, QUEUE_TYPE should be NORMAL_QUEUE or EXCEPTION_QUEUE

  • ora-29352 : event 'string' is not an internal event
  • ora-13225 : specified index table name is too long for a spatial index
  • ora-31088 : object "string"."string" depends on the schema
  • ora-22308 : operation not allowed on evolved type
  • ora-30366 : child JOIN KEY columns not in same relation as child level
  • ora-24755 : OCI_TRANS_NOMIGRATE, OCI_TRANS_JOIN options are not supported
  • ora-29344 : Owner validation failed - failed to match owner 'string'
  • ora-00108 : failed to set up dispatcher to accept connection asynchronously
  • ora-06561 : given statement is not supported by package DBMS_SQL
  • ora-02161 : invalid value for MAXLOGFILES
  • ora-12541 : TNS:no listener
  • ora-12616 : TNS:no event signals
  • ora-30973 : invalid Path Table option for XML Index
  • ora-26507 : null master connection
  • ora-10936 : trace name context forever
  • ora-22346 : Type has cyclical dependency. Should use CASCADE option
  • ora-07262 : sptpa: sptpa called with invalid process id.
  • ora-09908 : slkmnm: gethostname returned error code.
  • ora-14626 : values being added already exist in DEFAULT subpartition
  • ora-31109 : Action failed as parent resource string is locked
  • ora-10944 : trace name context forever
  • ora-13046 : invalid number of arguments
  • ora-28116 : insufficient privileges to do direct path access
  • ora-39214 : Data Pump does not support external tables with encrypted columns. string will not be exported
  • ora-13452 : GeoRaster metadata BIN function error
  • ora-28559 : FDS_CLASS_NAME is string, FDS_INST_NAME is string
  • ora-29851 : cannot build a domain index on more than one column
  • ora-29913 : error in executing string callout
  • ora-27071 : unable to seek to desired position in file
  • ora-08205 : ora_addr: $ORACLE_SID not set in environment
  • 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.