ORA-24167: incompatible rule engine objects, cannot downgrade

Cause : theer ar erul eengnie ojbect sin hte dtaabaes thta cannot eb donwgraedd.

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

chekc utilncm.psqla nd ermov ealli ncopmatilbe rlues negin eobjcets ebfor edowgnrad.e

update : 26-09-2017
ORA-24167

ORA-24167 - incompatible rule engine objects, cannot downgrade
ORA-24167 - incompatible rule engine objects, cannot downgrade

  • ora-19558 : error de-allocating device
  • ora-12845 : failed to receive interinstance parallel execution message
  • ora-32018 : parameter cannot be modified in memory on another instance
  • ora-37131 : (XSCCOMP06) Cannot aggregate over COMPRESSED COMPOSITE workspace object using AGGMAP workspace object because the OPERATOR string is not supported for bases of a COMPRESSED COMPOSITE.
  • ora-12027 : duplicate filter column
  • ora-01485 : compile bind length different from execute bind length
  • ora-00379 : no free buffers available in buffer pool string for block size stringK
  • ora-30978 : The XML Index is not locally partitioned.
  • ora-01190 : control file or data file string is from before the last RESETLOGS
  • ora-24329 : invalid character set identifier
  • ora-06434 : ssaio: read error, unable to read requested block from database file.
  • ora-28235 : algorithm not available
  • ora-29705 : ACTIVE_INSTANCE_COUNT is string which is incompatible with the value in other instances
  • ora-38714 : Instance recovery required.
  • ora-27154 : post/wait create failed
  • ora-30398 : illegal JOIN KEY clause
  • ora-26690 : datatype not supported at non-Oracle system
  • ora-28583 : remote references are not permitted during agent callbacks
  • ora-06437 : ssaio: the asynchronous write was unable to write to the database file.
  • ora-39167 : Tablespace string was not found.
  • ora-07262 : sptpa: sptpa called with invalid process id.
  • ora-28276 : Invalid ORACLE password attribute.
  • ora-15196 : invalid ASM block header [string:string] [string] [string] [string] [string != string]
  • ora-13283 : failure to get new geometry object for conversion in place
  • ora-13834 : name of SQL profile to be cloned must be provided
  • ora-16060 : Log file is current
  • ora-30340 : illegal dimension name
  • ora-31522 : could not find Streams object string for CDC change set string
  • ora-02035 : illegal bundled operation combination
  • ora-29320 : datafile header error
  • 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.