ORA-16530: invalid buffer or length

Cause : A NULL buffer or a length of zero is specified.

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

Correct command parameters and retry.

update : 23-09-2017
ORA-16530

ORA-16530 - invalid buffer or length
ORA-16530 - invalid buffer or length

  • ora-00409 : COMPATIBLE needs to be string or higher to use AUTO SEGMENT SPACE MANAGEMENT
  • ora-40001 : value for string must be greater than zero
  • ora-19903 : test recovery not allowed when recovering to new incarnation
  • ora-15057 : specified size of string MB is larger than actual size of string MB
  • ora-36680 : (XSDPART18) workspace object is not a dimension of the PARTITION TEMPLATE.
  • ora-08118 : Deferred FK constraints cannot be enforced, index too big (string)
  • ora-24084 : DBLINK name in address field of agent string is not unique within the first 24 bytes
  • ora-02082 : a loopback database link must have a connection qualifier
  • ora-25213 : message with specified RELATIVE_MSGID has been dequeued
  • ora-28004 : invalid argument for function specified in PASSWORD_VERIFY_FUNCTION string
  • ora-22281 : cannot perform operation with an updated locator
  • ora-36378 : (XSAGTHRWEIGHT) While running AGGREGATE with multiple threads, the weight variable workspace object specified by your ARGS variable workspace object must exist in the same analytic workspace as your AGGMAP workspace object.
  • ora-29272 : initialization failed
  • ora-02706 : osnshs: host name too long
  • ora-02820 : Unable to write the requested number of blocks
  • ora-01619 : thread string is mounted by another instance
  • ora-32404 : snapshot log uses Change Data Capture which is not enabled for this database
  • ora-04006 : START WITH cannot be less than MINVALUE
  • ora-16621 : database name for ADD DATABASE must be unique
  • ora-31003 : Parent string already contains child entry string
  • ora-01091 : failure during startup force
  • ora-39216 : object type "string"."string" hashcode mismatch
  • ora-01752 : cannot delete from view without exactly one key-preserved table
  • ora-15018 : diskgroup cannot be created
  • ora-39034 : Table string does not exist.
  • ora-26730 : %s 'string' already exists
  • ora-06764 : TLI Driver: error reading disconnect
  • ora-33215 : (CINSERT07) You cannot add session-only values to the workspace object dimension.
  • ora-33098 : (APABBR01) A value of 'string' is not valid for the workspace object option.
  • ora-31499 : null value specified for required parameter string
  • 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.