ORA-27061: waiting for async I/Os failed

Cause : aiowait function returned error

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

check errno

update : 28-06-2017
ORA-27061

ORA-27061 - waiting for async I/Os failed
ORA-27061 - waiting for async I/Os failed

  • ora-24143 : invalid evaluation context name
  • ora-30444 : rewrite terminated by the sql analyzer
  • ora-30202 : NULL pointer to OCIMsgh was passed to OCIMsg function
  • ora-19616 : output filename must be specified if database not mounted
  • ora-27043 : unable to seek to beginning of file
  • ora-38480 : creation of system trigger EXPFIL_ALTEREXPTAB_MAINT failed.
  • ora-31667 : parameter name can not be defaulted
  • ora-04005 : INCREMENT must be less than MAXVALUE minus MINVALUE
  • ora-15182 : ASMLIB [string] version mismatch, ORACLE version [string]
  • ora-29386 : plan or consumer group string is mandatory and cannot be deleted or modified
  • ora-13360 : invalid subtype in a compound type
  • ora-09748 : pws_look_up: fork failed
  • ora-19831 : incompatible string.string.string.string DBMS_BACKUP_RESTORE package: string.string.string.string required
  • ora-28344 : fails to decrypt data
  • ora-16030 : session specific change requires a LOG_ARCHIVE_DEST_n destination
  • ora-02476 : can not create index due to parallel direct load on table
  • ora-19567 : cannot shrink file string because it is being backed up or copied
  • ora-14044 : only one partition may be moved
  • ora-25222 : enqueue failed, complete sender info. not provided for a queue supporting non-repudiation
  • ora-08191 : Flashback Table operation is not supported on remote tables
  • ora-08311 : sllfop: bad value for maxrecsize
  • ora-14515 : only one aubpartition name can be specified
  • ora-08177 : can't serialize access for this transaction
  • ora-36182 : (XSAGGR09) Could not locate a value for variable number in measure dimension workspace object.
  • ora-02453 : duplicate HASH IS specification
  • ora-14072 : fixed table may not be truncated
  • ora-08104 : this index object string is being online built or rebuilt
  • ora-28236 : invalid Triple DES mode
  • ora-22980 : must specify a set of attributes for the WITH OBJECT OID clause
  • ora-10656 : Table is in unusable state due to incomplete operation
  • 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.