ORA-27046: file size is not a multiple of logical block size

Cause : file size as indicated by stat is not correct, additional information indicates which function encountered the error

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

verify that the file has not been overwritten or truncated

update : 24-04-2017
ORA-27046

ORA-27046 - file size is not a multiple of logical block size
ORA-27046 - file size is not a multiple of logical block size

  • ora-01244 : unnamed datafile(s) added to control file by media recovery
  • ora-28141 : error in creating audit index file
  • ora-10854 : Sets poll count used for AQ listen code under RAC
  • ora-02315 : incorrect number of arguments for default constructor
  • ora-25252 : listen failed, the address string is a non-persistent queue
  • ora-13617 : The specified task string already executing
  • ora-19006 : XMLType TYPE storage option not appropriate for storage type
  • ora-19240 : XP0020 - context item must be node in an axis expression
  • ora-13788 : invalid recommendation type
  • ora-24235 : bad value for object type: string
  • ora-02059 : ORA-2PC-CRASH-TEST-string in commit comment
  • ora-00828 : specified value of shared_pool_reserved_size inconsistent with internal settings
  • ora-31005 : Path name length string exceeds maximum length string
  • ora-24072 : cannot execute MIGRATE_QUEUE_TABLE procedure; must own queue table
  • ora-23471 : template not authorized for user
  • ora-36273 : (XSCGMDLAGG12) Dimension workspace object appears more than once in the QDR.
  • ora-40106 : positive target value not specified for computing Lift
  • ora-06264 : NETNTT: data protocol error
  • ora-10657 : Lob column to be shrunk does not exist
  • ora-25285 : Invalid value string for array_mode
  • ora-39301 : schema "string" does not exist or is in use
  • ora-06921 : CMX: getdatmsg illegal datatype
  • ora-19911 : datafile string contains future changes at the incarnation boundary
  • ora-12658 : ANO service required but TNS version is incompatible
  • ora-16535 : CRS is preventing execution of a broker operation
  • ora-09824 : Unable to enable allowmacaccess privilege.
  • ora-00290 : operating system archival error occurred. See error below
  • ora-22897 : no scope clause specified for user-defined REF column "string"
  • ora-02172 : The PUBLIC keyword is not appropriate for a disable thread
  • ora-33274 : (DBERR07) Timed out while trying to lock analytic workspace string for 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.