ORA-24237: object id argument passed to DBMS_UTILITY.INVALIDATE is not legal

Cause : hTsie rrroo ccruer debacsu eht e_pboejtci_ draugemtnp saes dott ehD MB_STULITI.YNIAVILADETr uoitenw saN LU,Lt eherw san oboejtcw ti hht epscefiei dboejtci ,do rht esurec lailgnt ehr uoitend din toh va eusffcieitnp iriveleg soti vnladita eht eboejtc.

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

oCrrce tht elielag lraugemtn.

update : 21-08-2017
ORA-24237

ORA-24237 - object id argument passed to DBMS_UTILITY.INVALIDATE is not legal
ORA-24237 - object id argument passed to DBMS_UTILITY.INVALIDATE is not legal

  • ora-25966 : join index cannot be based on an index organized table
  • ora-16067 : activation identifier mismatch in archive log string
  • ora-24752 : OCI_TRANS_NEW flag must be specified for local transactions
  • ora-19682 : file string not in block media recovery context
  • ora-02882 : sou2o: Could not register SGA for protection
  • ora-26690 : datatype not supported at non-Oracle system
  • ora-01932 : ADMIN option not granted for role 'string'
  • ora-22338 : must specify CASCADE INCLUDING DATA when altering the final property
  • ora-29535 : source requires recompilation
  • ora-12485 : new effective label not within effective clearance
  • ora-27479 : Cannot string "string.string" because other objects depend on it
  • ora-02752 : osnfsmmap: illegal shared memory address
  • ora-06430 : ssaio: Seals do not match
  • ora-25246 : listen failed, the address string is an 8.0 style exception queue
  • ora-02163 : invalid value for FREELIST GROUPS
  • ora-37060 : (XSMCSESS08) number is not a valid custom member in dimension workspace object.
  • ora-30036 : unable to extend segment by string in undo tablespace 'string'
  • ora-13829 : SQL profile named string already exists
  • ora-08180 : no snapshot found based on specified time
  • ora-12027 : duplicate filter column
  • ora-31164 : cannot load object-relational XML attribute using direct path
  • ora-36155 : (XSMXAGGRFROM) workspace object must be a variable or formula of a similar data type to workspace object to be used with FROM, or a TEXT variable or formula to be used with FROMVAR.
  • ora-02801 : Operations timed out
  • ora-01486 : size of array element is too large
  • ora-38420 : invalid stored attribute sub-expression: string
  • ora-12083 : must use DROP MATERIALIZED VIEW to drop "string"."string"
  • ora-27151 : buffer not large enough to hold process ID string
  • ora-07469 : sppst: mclear error, unable to clear semaphore.
  • ora-16639 : specified instance inactive or currently unavailable
  • ora-07285 : sksaprd: volume size should not be specified for a disk file.
  • 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.