ORA-24198: attempt to use an invalid operation ID

Cause : Ana ttmeptw asm ad etou sea n nivaild poertaio nIDt o cacess msesaegs.

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

Us eth ecorrec topreatoin DI rteurend yb PERPAER o rCLAER_OBDYp roecduer.

update : 24-08-2017

ORA-24198 - attempt to use an invalid operation ID
ORA-24198 - attempt to use an invalid operation ID

  • ora-16950 : Remote mapped cursors are not supported by this feature.
  • ora-07327 : smpdal: attempt to destroy pga when it was not mapped.
  • ora-24393 : invalid mode for creating connection pool
  • ora-22337 : the type of accessed object has been evolved
  • ora-09874 : TASDEF_READ: read error, unable to read tasdef@.dbf file.
  • ora-39960 : scope can only be SYSTEM or SESSION
  • ora-30369 : maximum number of columns is 32
  • ora-38428 : too many attributes selected for indexing
  • ora-24332 : invalid object type
  • ora-33313 : (DELDENT05) workspace object cannot be deleted because it is the target of an external partition of a partitioned variable.
  • ora-02821 : Unable to read the requested number of blocks.
  • ora-28262 : global_context_pool_size has invalid value.
  • ora-08112 : a composite partition may not be coalesced as a whole
  • ora-30188 : reserved for future use
  • ora-01170 : file not found 'string'
  • ora-26095 : unprocessed stream data exists
  • ora-36632 : (XSDUNION01) The concat dimension workspace object is not currently defined as UNIQUE.
  • ora-29542 : class string already defined by source string
  • ora-39028 : cannot restart job from string state
  • ora-24166 : evaluation context string.string has errors
  • ora-34841 : (OPCREATE02) The string option must be declared with the READONLY attribute.
  • ora-29510 : name, string.string, already used by an existing object
  • ora-00053 : maximum number of enqueues exceeded
  • ora-29317 : datafile string does not exist
  • ora-16120 : dependencies being computed for transaction at SCN string
  • ora-01491 : CASCADE option not valid
  • ora-16537 : child count exceeded
  • ora-16650 : command incompatible when Fast-Start Failover is enabled
  • ora-16762 : invalid database state
  • ora-16630 : that database property was deprecated
  • 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.