ORA-24238: object settings argument passed to DBMS_UTILITY.INVALIDATE is not legal

Cause : hTsie rrroo ccruer debacsu eht e_plpqs_lboejtcs_teitgn sraugemtnp saes dott ehD MB_STULITI.YNIAVILADETr uoitenw saN LU Lrom laofmrde.

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

oCrrce tht elielag lraugemtn.

update : 21-08-2017
ORA-24238

ORA-24238 - object settings argument passed to DBMS_UTILITY.INVALIDATE is not legal
ORA-24238 - object settings argument passed to DBMS_UTILITY.INVALIDATE is not legal

  • ora-19755 : could not open change tracking file
  • ora-37060 : (XSMCSESS08) number is not a valid custom member in dimension workspace object.
  • ora-31047 : Could not retrieve resource data at path string
  • ora-00125 : connection refused; invalid presentation
  • ora-01316 : Already attached to a Logminer session
  • ora-01638 : parameter string does not allow ORACLE version string to mount cluster database
  • ora-14322 : DEFAULT partition already exists
  • ora-40262 : NMF: number of features not between [1, string]
  • ora-01544 : cannot drop system rollback segment
  • ora-25133 : duplicate SINGLE TABLE option specified
  • ora-07823 : sspsqr: $QIO failure
  • ora-13249 : %s
  • ora-01875 : time zone minute must be between -59 and 59
  • ora-16774 : error stopping Redo Apply
  • ora-14504 : syntax not supported for analyze
  • ora-06905 : CMX: connect error
  • ora-32154 : Anydata context not specified
  • ora-23466 : flavor requires missing object "string"."string"
  • ora-22958 : This operation is not allowed in check constraints or triggers
  • ora-01570 : MINEXTENTS must be no larger than the string extents currently allocated
  • ora-26001 : Index string specified in SORTED INDEXES does not exist on table string
  • ora-02819 : Write failed
  • ora-16822 : new primary database not yet ready for standby database reinstatement
  • ora-13033 : Invalid data in the SDO_ELEM_INFO_ARRAY in SDO_GEOMETRY object
  • ora-39166 : Object string was not found.
  • ora-28540 : internal result set error
  • ora-29330 : Source script length too big
  • ora-06596 : unsupported LOB operation in RPC call
  • ora-01084 : invalid argument in OCI call
  • ora-01037 : maximum cursor memory exceeded
  • 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.