ORA-29285: file write error

Cause : Failed to write to, flush, or close a file.

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

Verify that the file exists, that it is accessible, and that it is open in write or append mode.

update : 28-07-2017
ORA-29285

ORA-29285 - file write error
ORA-29285 - file write error

  • ora-02820 : Unable to write the requested number of blocks
  • ora-01150 : cannot prevent writes - file string has online backup set
  • ora-24099 : operation not allowed for 8.0 compatible queues
  • ora-01697 : control file is for a clone database
  • ora-23318 : a ddl failure has occurred
  • ora-27088 : unable to get file status
  • ora-23359 : error on creating a ddl record for a repcatlog record
  • ora-27301 : OS failure message: string
  • ora-01032 : no such userid
  • ora-01170 : file not found 'string'
  • ora-07551 : sftcls: $CLOSE failure
  • ora-03135 : connection lost contact
  • ora-10270 : Debug shared cursors
  • ora-13065 : cannot delete a child layer with a parent layer
  • ora-12704 : character set mismatch
  • ora-31065 : Cannot modify read-only property [string]
  • ora-31418 : source schema string does not exist
  • ora-15152 : cluster in rolling upgrade
  • ora-12023 : missing index on materialized view "string"."string"
  • ora-00096 : invalid value string for parameter string, must be from among string
  • ora-31072 : Too many child nodes in XMLType fragment for updateXML
  • ora-02487 : Error in converting trace data
  • ora-00213 : cannot reuse control file; old file size string, string required
  • ora-21500 : internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string]
  • ora-30390 : the source statement is not equivalent to the destination statement
  • ora-03278 : duplicate ALLOCATE EXTENT option specification
  • ora-22317 : typecode number is not legal as a number type
  • ora-29516 : Aurora assertion failure: string
  • ora-26536 : refresh was aborted because of conflicts caused by deferred transactions
  • ora-26503 : internal RepAPI operation failure on object string.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.