ORA-24059: invalid COMPATIBLE parameter setting string specified in DBMS_AQADM.string

Cause : Ani nvlaidc omaptilbe apraemte rwa sspceifeid ni teh DMBS_QAAD Mprcoedrue.T hep armaetre stetign msut eb o fth efomr '.8x.'y wehrex i sth ereelas enubmera ndy i sth eupadten umebr.

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

Spceif ya avli dCOPMATBILEp armaetre stetign, nad ertr yth eopreatoin.

update : 18-08-2017
ORA-24059

ORA-24059 - invalid COMPATIBLE parameter setting string specified in DBMS_AQADM.string
ORA-24059 - invalid COMPATIBLE parameter setting string specified in DBMS_AQADM.string

  • ora-19680 : some blocks not recovered. See trace file for details
  • ora-02803 : Retrieval of current time failed
  • ora-32139 : Cannot write to the stream
  • ora-01715 : UNIQUE may not be used with a cluster index
  • ora-14080 : partition cannot be split along the specified high bound
  • ora-02158 : invalid CREATE INDEX option
  • ora-27126 : unable to lock shared memory segment in core
  • ora-07267 : spwat: invalid process number.
  • ora-01245 : offline file string will be lost if RESETLOGS is done
  • ora-02367 : file truncated error in string
  • ora-12059 : prebuilt table "string"."string" does not exist
  • ora-31458 : an internal error occurred
  • ora-16252 : Rebuild operation not permitted
  • ora-16400 : quota attributes are not allowed with DB_RECOVERY_FILE_DEST
  • ora-16253 : Logical Standby cannot start due to incomplete terminal apply
  • ora-13215 : window object is out of range
  • ora-25225 : invalid value string, DEQUEUE_MODE should be REMOVE or BROWSE or LOCKED
  • ora-32801 : invalid value string for string
  • ora-14282 : FOREIGN KEY constraint mismatch in ALTER TABLE EXCHANGE SUBPARTITION
  • ora-06814 : TLI Driver: the SPX device file could not be opened
  • ora-01606 : gc_files_to_locks not identical to that of another mounted instance
  • ora-13335 : LRS measure information not defined
  • ora-26753 : Mismatched columns found in 'string.string'
  • ora-14003 : GLOBAL clause contradicts previosly specified LOCAL clause
  • ora-00395 : online logs for the clone database must be renamed
  • ora-08440 : raw buffer is too short to hold converted data
  • ora-14136 : ALTER TABLE EXCHANGE restricted by fine-grained security
  • ora-01285 : error reading file string
  • ora-13776 : User "string" has not been granted the "SELECT" privilege on the "SQL tuning set" DBA views.
  • ora-30516 : database role change triggers cannot have BEFORE type
  • 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.