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 : 23-04-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-02477 : can not perform parallel direct load on object string
  • ora-13839 : V$SQL row doesn't exist with given HASH_VALUE and ADDRESS.
  • ora-14602 : SUBPARTITION TEMPLATE is legal only for a composite partitioned table
  • ora-27474 : cannot give both an argument name and an argument position
  • ora-13828 : generated SQL profile name string already exists
  • ora-30440 : can't fast refresh;refresh complete or set event 30441 for partial refresh
  • ora-13502 : Cannot rename SYSAUX tablespace
  • ora-28153 : Invalid client initial role specified: 'string'
  • ora-12492 : DBLOW cannot be changed
  • ora-01907 : TABLESPACE keyword expected
  • ora-25206 : enqueue failed, enqueue to exception queue string.string not permitted
  • ora-02761 : File number to be canceled is negative.
  • ora-38903 : DML error logging is not supported for abstract column "string"
  • ora-09765 : osnmop: fork failed
  • ora-02798 : Invalid number of requests
  • ora-29823 : object being analyzed is not a table
  • ora-02280 : duplicate or conflicting CYCLE/NOCYCLE specifications
  • ora-29800 : invalid name for operator
  • ora-22054 : underflow error
  • ora-10944 : trace name context forever
  • ora-25401 : can not continue fetches
  • ora-39203 : Partition selection is not supported over a network link.
  • ora-09366 : Windows 3.1 Two-Task driver unable to allocate shared memory
  • ora-14124 : duplicate REVERSE clause
  • ora-09859 : sfngat: the input file name is not in the autobackup OMF format
  • ora-25232 : duplicate recipients specified for message
  • ora-01563 : rollback segment is PUBLIC, need to use the keyword PUBLIC
  • ora-01168 : physical block size string does not match size string of other members
  • ora-06537 : OUT bind variable bound to an IN position
  • ora-16004 : backup database requires recovery
  • 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.