ORA-27053: blocksize in file header not a multiple of logical block size

Cause : teh olgcia lbolc ksziei si navldi,a didtoinla nifromtaino nidciaetst h elgoiaclb lcoks iez nadt h ebolcskiez ni htef iel ehaedr

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

ues adfifreetn olgcia lbolc kszie ,o rd onto erues ifle

update : 23-09-2017
ORA-27053

ORA-27053 - blocksize in file header not a multiple of logical block size
ORA-27053 - blocksize in file header not a multiple of logical block size

  • ora-28506 : parse error in data dictionary translation for string stored in string
  • ora-24011 : cannot drop QUEUE, string should be stopped first
  • ora-24055 : cannot delete propagation status rows that are in prepared state
  • ora-27144 : attempt to kill process failed
  • ora-08414 : error encountered in string
  • ora-13228 : spatial index create failed due to invalid type
  • ora-01310 : requested return type not supported by the lcr_mine function
  • ora-24096 : invalid message state specified
  • ora-25298 : Only immediage visibility mode supported for buffered message enqueue or dequeue
  • ora-35023 : (QFCHECK09) The analytic workspace and EIF file definitions of workspace object have incompatible partition definitions.
  • ora-30456 : 'string.string' cannot be refreshed because of insufficient privilege
  • ora-36999 : (XSRELGID16) OBJECT workspace object is not a surrogate dimension, a source relation must be specified when creating any non-surrogate grouping id.
  • ora-14135 : a LOB column cannot serve as a partitioning column
  • ora-12714 : invalid national character set specified
  • ora-23416 : table "string"."string" does not contain a primary key constraint
  • ora-25448 : rule string.string has errors
  • ora-29290 : invalid offset specified for seek
  • ora-19753 : error writing to change tracking file
  • ora-14120 : incompletely specified partition bound for a DATE column
  • ora-01653 : unable to extend table string.string by string in tablespace string
  • ora-32015 : unable to restore SPFILE
  • ora-16019 : cannot use string with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST
  • ora-19905 : log_archive_format must contain %%s, %%t and %%r
  • ora-34061 : (MSEXECUT11) Session-only values cannot be added to non-unique concat dimension workspace object, or any of its base dimensions.
  • ora-30484 : missing window specification for this function
  • ora-39055 : The string feature is not supported in version string.
  • ora-32319 : Cannot use direct loader log to FAST REFRESH materialized view "string"."string"
  • ora-14116 : partition bound of partition "string" is too long
  • ora-06603 : LU6.2 Driver: Error allocating memory
  • ora-25196 : keyword MOVE in ALTER TABLE MOVE must immediately follow

    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.