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 : 23-05-2017
ORA-24048

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-02332 : cannot create index on attributes of this column
  • ora-30742 : cannot grant SELECT privilege WITH HIERARCHY OPTION on this object
  • ora-14175 : a subpartition maintenance operation may not be combined with other operations
  • ora-14009 : partition bound may not be specified for a LOCAL index partition
  • ora-33280 : (DBERR10) Analytic workspace string cannot be attached in MULTI mode until the changes made and updated in RW or EXCLUSIVE mode are committed or rolled back.
  • ora-09889 : osnTXtt: access error on oracle executable
  • ora-23347 : datatype string for column string table string not supported
  • ora-30942 : XML Schema Evolution error for schema 'string' table string column 'string'
  • ora-02297 : cannot disable constraint (string.string) - dependencies exist
  • ora-15038 : disk 'string' size mismatch with diskgroup [string] [string] [string]
  • ora-01776 : cannot modify more than one base table through a join view
  • ora-27500 : inter-instance IPC error
  • ora-16254 : change db_name to string in the client-side parameter file (pfile)
  • ora-25299 : Invalid message delivery_mode
  • ora-02880 : smpini: Could not register PGA for protection
  • ora-01551 : extended rollback segment, pinned blocks released
  • ora-38723 : Invalid SCN expression.
  • ora-12404 : invalid privilege string: string
  • ora-16029 : cannot change LOG_ARCHIVE_MIN_SUCCEED_DEST, no archive log destinations
  • ora-29379 : resource plan string is involved in a loop in top-plan string
  • ora-16633 : the only instance of the database cannot be removed
  • ora-36163 : (XSMXAGGR06) The AGGREGATE function cannot be run on more than one variable at a time.
  • ora-12660 : Encryption or crypto-checksumming parameters incompatible
  • ora-01268 : invalid TEMPFILE clause for alter of permanent TABLESPACE
  • ora-16773 : error starting Redo Apply
  • ora-06707 : TLI Driver: connection failed
  • ora-01581 : attempt to use rollback segment (string) new extent (string) which is being allocated
  • ora-19109 : RETURNING keyword expected
  • ora-34361 : (MXDSS12) number other user reading
  • ora-25508 : database is not mounted
  • 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.