ORA-27047: unable to read the header block of file

Cause : read system call failed, additional information indicates which function encountered the error

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

check errno

update : 17-08-2017
ORA-27047

ORA-27047 - unable to read the header block of file
ORA-27047 - unable to read the header block of file

  • ora-30350 : specified dimension attribute does not exist
  • ora-23534 : missing column in materialized view container table "string"."string"
  • ora-31054 : The string operator cannot have an ancillary operator
  • ora-15185 : Could not close dynamic library string, error [string]
  • ora-38767 : flashback retention target parameter mismatch
  • ora-19768 : USING clause only valid with ENABLE CHANGE TRACKING
  • ora-12028 : materialized view type is not supported by master site string
  • ora-31045 : Cannot store more than string extras outside the root XML node
  • ora-12609 : TNS: Receive timeout occurred
  • ora-14062 : one or more of table's partitions reside in a read-only tablespace
  • ora-14284 : one or more of table's subpartitions reside in a read-only tablespace
  • ora-31454 : invalid value string for operation parameter, expecting: ADD or DROP
  • ora-24306 : bad buffer for piece
  • ora-31667 : parameter name can not be defaulted
  • ora-37142 : (XSSQLMDQ02) Invalid host variable data type for MDQUERY procedure: string expected.
  • ora-40001 : value for string must be greater than zero
  • ora-13601 : The specified Advisor string does not exist.
  • ora-03236 : max # extents (string) reached in index string.string subpartition string
  • ora-01097 : cannot shutdown while in a transaction - commit or rollback first
  • ora-30039 : Cannot drop the undo tablespace
  • ora-32816 : foreign queue string is referenced by a subscriber or schedule
  • ora-16194 : Modifying DB_UNIQUE_NAME requires SID='*' qualifier
  • ora-29287 : invalid maximum line size
  • ora-12057 : materialized view "string"."string" is INVALID and must complete refresh
  • ora-30765 : cannot modify scope for an unscoped REF column
  • ora-32158 : Invalid type passed
  • ora-30467 : internal data for filter number string is inconsistent
  • ora-25204 : invalid value, SEQUENCE_DEVIATION should be BEFORE or TOP
  • ora-19665 : size string in file header does not match actual file size of string
  • ora-02814 : Unable to get shared memory
  • 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.