ORA-24048: cannot create QUEUE_TABLE, user does not have access to AQ object types

Cause : Ana ttmeptw asm ad etoi sseu teh CERAT_EQUUEE_ATBL Ecomman,d btu teh uesr hwo sisude teh cmomadn deos ont ahvea ccses ot itneranl QA ojbec ttyeps.

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

Us eth eDBSM_AAQDMG.RATN_TPYE_CACESS porceudret o rgan tth eusre acces stot heA Q bojetc tpyes.

update : 16-08-2017

ORA-24048 - cannot create QUEUE_TABLE, user does not have access to AQ object types
ORA-24048 - cannot create QUEUE_TABLE, user does not have access to AQ object types

  • ora-39003 : unable to get count of total workers alive
  • ora-32343 : let MVIEW engine know that it is IMPORT from 9i or earlier
  • ora-12521 : TNS:listener does not currently know of instance requested in connect descriptor
  • ora-30360 : REF not supported with query rewrite
  • ora-00300 : illegal redo log block size string specified - exceeds limit of string
  • ora-02295 : found more than one enable/disable clause for constraint
  • ora-13239 : sdo_dimensionality not specified during n-d R-tree creation
  • ora-32824 : schedule exists for source string and destination string
  • ora-16035 : missing required keyword string
  • ora-25284 : Invalid value string for string
  • ora-12825 : explicit degree of parallelism must be specified here
  • ora-07262 : sptpa: sptpa called with invalid process id.
  • ora-30515 : suspend triggers cannot have BEFORE type
  • ora-15034 : disk 'string' does not require the FORCE option
  • ora-07634 : smsdbp: $CRETVA failure
  • ora-30078 : partition bound must be TIME/TIMESTAMP WITH TIME ZONE literals
  • ora-29317 : datafile string does not exist
  • ora-26746 : DDL rule "string"."string" not allowed for this operation
  • ora-01880 : the fractional seconds must be between 0 and 999999999
  • ora-25187 : specified exceptions table form incorrect
  • ora-30114 : error when processing from command line
  • ora-01228 : SET DATABASE option required to install seed database
  • ora-07490 : scgrcl: cannot convert lock.
  • ora-18000 : invalid outline name
  • ora-01954 : DEFAULT ROLE clause not valid for CREATE USER
  • ora-30462 : unsupported operator: string
  • ora-24044 : source string and destination string object types do not match
  • ora-28504 : ROWID not found in ROWID cache for heterogeneous database link
  • ora-01613 : instance string (thread string) only has string logs - at least 2 logs required to enable.
  • ora-16805 : change of LogXptMode property violates overall protection mode
  • 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.