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 : 23-04-2017
ORA-29285

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

  • ora-02184 : resource quotas are not allowed in REVOKE
  • ora-02377 : invalid resource limit
  • ora-02280 : duplicate or conflicting CYCLE/NOCYCLE specifications
  • ora-13014 : a topology identifier outside the range of 1 to 8 was specified
  • ora-30202 : NULL pointer to OCIMsgh was passed to OCIMsg function
  • ora-40291 : model cost not available
  • ora-29550 : Java session state cleared
  • ora-02242 : no options specified for ALTER INDEX
  • ora-07503 : scgcmn: $setimr unexpected return
  • ora-03296 : cannot resize datafile - file string not found
  • ora-33315 : (XSDELDENTANON) You cannot delete workspace object while looping over unnamed composite workspace object.
  • ora-28292 : No Domain Policy registered for Kerberos based authentication
  • ora-16001 : database already open for read-only access by another instance
  • ora-13021 : element not continuous
  • ora-01231 : cannot make read write - file string is offline
  • ora-00231 : snapshot control file has not been named
  • ora-09711 : orasrv: archmon already connected.
  • ora-16757 : resource guard could not get property
  • ora-23488 : propagation mode "string" for "string" is not allowed for this operation
  • ora-19605 : input filename must be specified
  • ora-12051 : ON COMMIT attribute is incompatible with other options
  • ora-12065 : unknown refresh group identifier string
  • ora-15111 : conflicting or duplicate STRIPE options
  • ora-06979 : X.25 Driver: server cannot start oracle
  • ora-02238 : filename lists have different numbers of files
  • ora-30378 : MV_CAPABILITIES_TABLE is not compatible with Oracle version
  • ora-14056 : partition number string: sum of PCTUSED and PCTFREE may not exceed 100
  • ora-16185 : REMOTE_ARCHIVE_ENABLE and LOG_ARCHIVE_CONFIG mutually exclusive
  • ora-13203 : failed to read USER_SDO_GEOM_METADATA view
  • ora-13835 : invalid attribute name specified
  • 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.