ORA-24307: invalid length for piece

Cause : Th elegntho f hte ipec eexecedde teh mxaimmu psosilbe isze.

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

Veirfyt ha tth elegntho f htisp ieec adn teh cmuultaiv elegntho f lal hte rpevoiusp ieecs si nto mroe htant hed esriedv aleu spupleid yb teh appliactino.

update : 26-09-2017
ORA-24307

ORA-24307 - invalid length for piece
ORA-24307 - invalid length for piece

  • ora-02277 : invalid sequence name
  • ora-16813 : log apply service not running on apply instance string recorded by the broker
  • ora-30398 : illegal JOIN KEY clause
  • ora-10567 : Redo is inconsistent with data block (file# string, block# string)
  • ora-25404 : lost instance
  • ora-19750 : change tracking file: 'string'
  • ora-30038 : Cannot perform parallel insert on non-partitioned object
  • ora-36831 : (XSLMGEN01) View token cannot be NA
  • ora-39080 : failed to create queues "string" and "string" for Data Pump job
  • ora-38410 : schema extension not allowed for the table name
  • ora-19752 : block change tracking is already enabled
  • ora-26696 : no streams data dictionary for object with number string and version number string from source database string
  • ora-26065 : check constraint cannot reference column, string, in direct path load
  • ora-24310 : length specified for null connect string
  • ora-36399 : (XSSPROPDTYPE) The data type of property string must be string.
  • ora-31093 : null or invalid value specified for parameter : string
  • ora-12582 : TNS:invalid operation
  • ora-12663 : Services required by client not available on the server
  • ora-26735 : operation not allowed on the specified file group version
  • ora-13300 : single point transform error
  • ora-18003 : an outline already exists with this signature
  • ora-00477 : SNP* process terminated with error
  • ora-09807 : Conversion of label from string to binary failed.
  • ora-38777 : database must not be started in any other instance.
  • ora-30646 : schema for external table type must be SYS
  • ora-07534 : scginq: $getlki unexpected return on lockid string
  • ora-01161 : database name string in file header does not match given name of string
  • ora-02490 : missing required file size in RESIZE clause
  • ora-29888 : cannot create domain index on a table with row movement enabled
  • ora-09831 : snyStartThread: failed to build the server port set.
  • 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.