ORA-27052: unable to flush file data

Cause : fsync system call returned error, additional information indicates which function encountered the error

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

check errno

update : 24-05-2017
ORA-27052

ORA-27052 - unable to flush file data
ORA-27052 - unable to flush file data

  • ora-08236 : smsget: cannot share subcube with listener
  • ora-12022 : materialized view log on "string"."string" already has rowid
  • ora-16034 : FROM parameter is incompatible with MANAGED recovery
  • ora-30430 : list does not contain any valid summaries
  • ora-01674 : data file string is an old incarnation rather than current file
  • ora-31536 : cannot support encrypted column string in the source table
  • ora-01072 : cannot stop ORACLE; ORACLE not running
  • ora-02821 : Unable to read the requested number of blocks.
  • ora-13629 : The task or object string is being used by another operation.
  • ora-31644 : unable to position to block number string in dump file "string"
  • ora-13034 : Invalid data in the SDO_ORDINATE_ARRAY in SDO_GEOMETRY object
  • ora-13031 : Invalid Gtype in the SDO_GEOMETRY object for point object
  • ora-12353 : secondary stored object cannot reference remote object
  • ora-02209 : invalid MAXTRANS option value
  • ora-29917 : cannot lock a table which gets its rows from a collection operand
  • ora-14402 : updating partition key column would cause a partition change
  • ora-02485 : Invalid _trace_options parameter specification (string)
  • ora-16235 : DDL skipped because import has occurred
  • ora-01142 : cannot end online backup - none of the files are in backup
  • ora-28523 : ORACLE and heterogeneous agent are incompatible versions
  • ora-16552 : an error occurred when generating the CLIENT OPERATION table
  • ora-31534 : Change Data Capture string publisher string is missing DBA role
  • ora-18000 : invalid outline name
  • ora-31523 : could not find change source string for CDC change set string
  • ora-39169 : Local version of string cannot work with remote version of string.
  • ora-07496 : sppst: lm_post failed.
  • ora-06132 : NETTCP: access denied, wrong password
  • ora-21522 : attempted to use an invalid connection in OCI (object mode only)
  • ora-13636 : The specified value provided for parameter string is not valid for this advisor.
  • ora-02087 : object locked by another process in same transaction
  • 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.