ORA-02792: Unable to fstat() a file being used for asynchronous I/O.

Cause : Teh sftta()2 acl lo naf iel ebign sue dfro saycnhornuosI / Ofialde.

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

Cehc kteh ifl enmae.

update : 23-08-2017
ORA-02792

ORA-02792 - Unable to fstat() a file being used for asynchronous I/O.
ORA-02792 - Unable to fstat() a file being used for asynchronous I/O.

  • ora-12323 : unable to open database (link name string)
  • ora-25288 : AQ HTTP propagation encountered error, status-code number, string
  • ora-25001 : cannot create this trigger type on views
  • ora-16535 : CRS is preventing execution of a broker operation
  • ora-24350 : OCI call not allowed
  • ora-07845 : sllfcl: LIB$FREE_VM failue
  • ora-34896 : (PPMONTHS00) At least 12 month names must be given. Only number were provided.
  • ora-19607 : %s is an active control file
  • ora-12554 : TNS:current operation is still in progress
  • ora-24420 : OCISessionRelease must be used to release this session.
  • ora-03214 : File Size specified is smaller than minimum required
  • ora-01520 : number of data files to add (string) exceeds limit of string
  • ora-12571 : TNS:packet writer failure
  • ora-30568 : cannot drop log group - nonexistent log group
  • ora-40107 : operation requires string option to be installed
  • ora-19765 : mount id string does not match mount id string in control file
  • ora-30453 : summary contains AVG without corresponding COUNT
  • ora-12689 : Server Authentication required, but not supported
  • ora-02826 : Illegal block size
  • ora-02428 : could not add foreign key reference
  • ora-25191 : cannot reference overflow table of an index-organized table
  • ora-07657 : slsprom:$ASSIGN failure
  • ora-02233 : invalid CLOSE mode
  • ora-12510 : TNS:database temporarily lacks resources to handle the request
  • ora-00040 : active time limit exceeded - call aborted
  • ora-00276 : CHANGE keyword specified but no change number given
  • ora-25955 : all tables must be joined in the where clause
  • ora-22132 : hexadecimal string does not correspond to a valid REF
  • ora-01980 : error during OS ROLE initialization
  • ora-13378 : invalid index for element to be extracted
  • 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.