ORA-24233: argument passed to DBMS_UTILITY.VALIDATE is not legal

Cause : Oneo r mroe ipnut ragumnets ot th eDBM_SUTIILTY.AVLIDTAE ruotin ewasn ot elgal .Thi serrro ocucrre dbecuase hte ojbectn ameo r onwer ro naemspaec arugmenst (i fspeicfie)d weer NULL ori lleagl.

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

Idetnifya nd ocrretc th eillgeal ragumnet.

update : 23-04-2017

ORA-24233 - argument passed to DBMS_UTILITY.VALIDATE is not legal
ORA-24233 - argument passed to DBMS_UTILITY.VALIDATE is not legal

  • ora-32585 : duplicate specification of a supplemental log attribute
  • ora-13757 : "SQL Tuning Set" "string" owned by user "string" is active.
  • ora-36910 : (XSAGDNGL47) In AGGMAP workspace object, DYNAMIC MODEL workspace object can only edit the top level of its matching relation hierarchy.
  • ora-07203 : sltln: attempt to translate a long environment variable.
  • ora-12658 : ANO service required but TNS version is incompatible
  • ora-04074 : invalid REFERENCING name
  • ora-07230 : slemcr: fopen error, unable to open error file.
  • ora-00165 : migratable distributed autonomous transaction with remote operation is not allowed
  • ora-27162 : thread creation failed
  • ora-27142 : could not create new process
  • ora-38721 : Invalid file number.
  • ora-16737 : the redo transport service for standby database "string" has an error
  • ora-13003 : the specified range for a dimension is invalid
  • ora-39147 : cannot migrate Data Pump queue table ownership to this instance
  • ora-40289 : duplicate attributes provided for data mining function
  • ora-24803 : illegal parameter value in lob read function
  • ora-07671 : $IDTOASC failed translating an integrity category
  • ora-01670 : new datafile string needed for standby database recovery
  • ora-30977 : invalid Value Index option for XML Index
  • ora-09889 : osnTXtt: access error on oracle executable
  • ora-32341 : The EXPLAIN_MVIEW facility failed to explain the materialized view "string"."string"
  • ora-06920 : CMX: getbrkmsg illegal datatype
  • ora-00483 : During shutdown a process abnormally terminated
  • ora-32696 : HTI: No free slot
  • ora-12169 : TNS:Net service name given as connect identifier is too long
  • ora-06560 : pos, string, is negative or larger than the buffer size, string
  • ora-31225 : DBMS_LDAP: invalid BER_ELEMENT
  • ora-13352 : the coordinates do not describe a circle
  • ora-27141 : invalid process ID
  • ora-01295 : DB_ID mismatch between dictionary string and logfiles
  • 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.