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 : 28-05-2017

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

  • ora-24901 : handles belonging to different environments passed into an OCI call
  • ora-13446 : GeoRaster metadata TRS error
  • ora-19211 : column 'string', specified as key using DBMS_XMLSTORE.setKeyColumn() , must be of scalar type
  • ora-23334 : column string does not exist in table or column group
  • ora-27007 : failed to open file
  • ora-23617 : Block string for script string has already been executed
  • ora-07479 : scgcmn: cannot open or convert lock.
  • ora-23475 : key column string must be sent and compared
  • ora-25102 : PARALLEL option can only be used with ALTER INDEX REBUILD
  • ora-27163 : out of memory
  • ora-29869 : cannot issue ALTER without REBUILD on a domain index marked FAILED
  • ora-32500 : Dirname 'string' cannot exceed 'number' characters
  • ora-13523 : unable to allocate required space for return type
  • ora-30016 : undo tablespace 'string' is already in use by this instance
  • ora-23534 : missing column in materialized view container table "string"."string"
  • ora-06604 : LU6.2 Driver: Unable to allocate session with remote LU
  • ora-13911 : Threshold not found
  • ora-28026 : user with same external name already exists
  • ora-16172 : archive logs detected beyond Terminal End-Of-Redo
  • ora-00036 : maximum number of recursive SQL levels (string) exceeded
  • ora-02330 : datatype specification not allowed
  • ora-38423 : Attribute set created from an ADT may not be extended.
  • ora-08277 : Cannot set environment variable
  • ora-27151 : buffer not large enough to hold process ID string
  • ora-13050 : unable to construct spatial object
  • ora-13359 : extent does not have an area
  • ora-24752 : OCI_TRANS_NEW flag must be specified for local transactions
  • ora-33334 : (DSSEXIST04) Analytic workspace string is not attached.
  • ora-02852 : Invalid critical-section time out value
  • ora-25148 : ONLINE option not permitted
  • 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.