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 : 21-07-2017
ORA-24233

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

  • ora-25274 : AQ Buffered Queue event
  • ora-06443 : ssvpstev: Incorrect parameter passed to function call
  • ora-27065 : cannot perform async vector I/O to file
  • ora-07484 : snlkput: cannot convert(put) lock.
  • ora-24072 : cannot execute MIGRATE_QUEUE_TABLE procedure; must own queue table
  • ora-09822 : Translation of audit file name failed.
  • ora-06600 : LU6.2 Driver: SNA software is not loaded
  • ora-22897 : no scope clause specified for user-defined REF column "string"
  • ora-06975 : X.25 Driver: connect to host failed
  • ora-07260 : spdcr: wait error.
  • ora-23409 : could not find an unused refresh group number
  • ora-39120 : Table string can't be truncated, data will be skipped. Failing error is: string
  • ora-16061 : Log file status has changed
  • ora-31214 : DBMS_LDAP: PL/SQL - Invalid LDAP mod type.
  • ora-21707 : pin duration is longer than allocation duration
  • ora-24024 : Internal error in DBMS_AQ_IMP_INTERNAL.string [string] [string]
  • ora-27192 : skgfcls: sbtclose2 returned error - failed to close file
  • ora-00824 : cannot set sga_target due to existing internal settings, see alert log for more information
  • ora-32100 : operation invalid on transient object
  • ora-14282 : FOREIGN KEY constraint mismatch in ALTER TABLE EXCHANGE SUBPARTITION
  • ora-12486 : effective max labels and min labels cannot be changed
  • ora-13274 : operator invoked with non-compatible SRIDs
  • ora-02825 : Request on free list was not free
  • ora-39314 : call to DBMS_SCHEMA_COPY.SYNC_CODE is not legal
  • ora-30959 : The indexed column is not stored in CLOB.
  • ora-02353 : files not from the same unload operation
  • ora-08196 : Flashback Table operation is not allowed on AQ tables
  • ora-08434 : raw data has invalid trailing sign
  • ora-25955 : all tables must be joined in the where clause
  • ora-07502 : scgcmn: $enq unexpected return
  • 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.