ORA-27064: cannot perform async I/O to file

Cause : internal error, asked to perform async I/O when IOV indicates that it cannot be performed on the file

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

check for trace file and contact Oracle Support

update : 27-05-2017
ORA-27064

ORA-27064 - cannot perform async I/O to file
ORA-27064 - cannot perform async I/O to file

  • ora-19201 : Datatype not supported
  • ora-28552 : pass-through SQL: call flow error
  • ora-25526 : bad format of _DB_MTTR_SIM_TARGET: string
  • ora-14017 : partition bound list contains too many elements
  • ora-39305 : schema "string" does not exist
  • ora-36835 : (XSLMGEN05) Dimension string.string!string hierarchy string level string is missing a COLUMNNAME property value
  • ora-27367 : program "string.string" associated with this job is disabled
  • ora-00385 : cannot enable Very Large Memory with new buffer cache parameters
  • ora-00327 : log string of thread string, physical size string less than needed string
  • ora-26515 : no master log available for 'string.string'
  • ora-19225 : XP0005 - XQuery static type error: expected non empty type got empty sequence
  • ora-06524 : Unsupported option : string
  • ora-19123 : fn:zero-or-one() called with a sequence containing more than one item
  • ora-00386 : use_indirect_data_buffers not supported
  • ora-30157 : An invalid argument was given to operating system call
  • ora-13190 : recursive SQL fetch failed
  • ora-16171 : RECOVER...FINISH not allowed due to gap for thr string, seq string-string
  • ora-02020 : too many database links in use
  • ora-10940 : trace name context forever
  • ora-01061 : cannot start up a V8 server using a V7 client application
  • ora-15105 : missing or invalid FAILGROUP name
  • ora-32829 : Messaging Gateway agent cannot be shut down while it is starting
  • ora-02220 : invalid MINEXTENTS storage option value
  • ora-02058 : no prepared transaction found with ID string
  • ora-16175 : cannot shut down database when media recovery is active
  • ora-13775 : inconsistent datatype in input cursor
  • ora-30682 : improper value for argument OPTION_FLAGS
  • ora-39956 : duplicate setting for PL/SQL compiler parameter string
  • ora-40306 : wide data not supported for decision tree model create
  • ora-29865 : indextype is invalid
  • 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.