ORA-29320: datafile header error

Cause : An reroro ccuerd druingr eadnig dtaafiel hedaer.

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

Cop ythec orrcet dtaafiel frmo th ecloen daatbas eto hte porduciton adtabsae, hten ertryt he poeraiton.

update : 28-04-2017

ORA-29320 - datafile header error
ORA-29320 - datafile header error

  • ora-16235 : DDL skipped because import has occurred
  • ora-28335 : referenced or referencing FK constraint column cannot be encrypted
  • ora-07235 : slemcw: fwrite error.
  • ora-14293 : Number of partitioning columns does not match number of subpartitioning columns
  • ora-39108 : Worker process string violated startup protocol. Worker error:
  • ora-22633 : Error freeing AnyDataSet
  • ora-32627 : illegal pattern in MODEL FOR LIKE loop
  • ora-24388 : Unsupported functionality in fast path mode
  • ora-09937 : Chmod of ORACLE password file failed.
  • ora-00237 : snapshot operation disallowed: control file newly created
  • ora-02192 : PCTINCREASE not allowed for rollback segment storage clauses
  • ora-15038 : disk 'string' size mismatch with diskgroup [string] [string] [string]
  • ora-06781 : TLI Driver: error reading negotation string
  • ora-09790 : sllfcf: unable to close file.
  • ora-23491 : no valid extension request at "string"
  • ora-16074 : ARCH processes must be active
  • ora-12201 : TNS:encountered too small a connection buffer
  • ora-12632 : Role fetch failed
  • ora-04097 : DDL conflict while trying to drop or alter a trigger
  • ora-24146 : rule string.string already exists
  • ora-13015 : the window definition is not valid
  • ora-25278 : grantee name cannot be NULL
  • ora-31439 : subscription is already active
  • ora-14630 : subpartition resides in offlined tablespace
  • ora-22604 : TDS handle already generated
  • ora-12336 : cannot login to database (link name string)
  • ora-07234 : slemcw: fseek error.
  • ora-19569 : no device is allocated to this session
  • ora-32743 : command cannot be executed on remote instance
  • ora-26726 : logical standby and DOWNSTREAM_REAL_TIME_MINE are incompatible
  • 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.