ORA-24275: function 'string' parameter 'string' missing or invalid

Cause : Thef unciton p wsa called iwth aparmaete re thta wa snul,l 0 elngt,h orh ad na inavlidv alu.e

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

Corerct hte praameetr t osuplpy vlauest hatc ompyl wiht it sdattaypea nd ilmit sas pseciifed ni th edocmuenttaion.

update : 26-07-2017

ORA-24275 - function 'string' parameter 'string' missing or invalid
ORA-24275 - function 'string' parameter 'string' missing or invalid

  • ora-26041 : DATETIME/INTERVAL datatype conversion error
  • ora-02453 : duplicate HASH IS specification
  • ora-14024 : number of partitions of LOCAL index must equal that of the underlying table
  • ora-19673 : error during proxy file string
  • ora-27014 : skgfqpini: translation error while expanding SS_UDMPDIR
  • ora-06979 : X.25 Driver: server cannot start oracle
  • ora-38714 : Instance recovery required.
  • ora-07224 : sfnfy: failed to obtain file size limit; errno = string.
  • ora-22319 : type attribute information altered in ALTER TYPE
  • ora-14522 : Partition-level default tablespace string block size [string] for string string does not match existing string block size [string]
  • ora-12536 : TNS:operation would block
  • ora-01328 : only one build operation may occur at one time
  • ora-16623 : stale DRC UID sequence number detected
  • ora-26027 : unique index string.string partition string initially in unusable state
  • ora-03264 : cannot drop offline datafile of locally managed tablespace
  • ora-14074 : partition bound must collate higher than that of the last partition
  • ora-07447 : ssarena: usinit failed.
  • ora-17507 : I/O request size string is not a multiple of logical block size
  • ora-26013 : List allocated may not be big enough
  • ora-06504 : PL/SQL: Return types of Result Set variables or query do not match
  • ora-01678 : parameter string must be pairs of pattern and replacement strings
  • ora-26660 : Invalid action context value for string
  • ora-22055 : unknown sign flag value [string]
  • ora-07259 : spdcr: exec error, detached process failed in startup.
  • ora-27483 : "string.string" has an invalid END_DATE
  • ora-12013 : updatable materialized views must be simple enough to do fast refresh
  • ora-30049 : Internal event for TA enq tracing
  • ora-16563 : unable to add value, syntax error at "string"
  • ora-13285 : Geometry coordinate transformation error
  • ora-29511 : could not resolve Java class
  • 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.