> Can anyone shed some light on this error. My UNIX admin people tell me its
> not an O/S error  !
> 
> KCF: write/open error block=0x1cff6 online=1
>      file=7 /a010/oradata/AIMEXA/AIMEXAINDX01.dbf
>      error=27063 txt: 'IBM AIX RISC System/6000 Error: 11: Resource
> temporarily unavailable
> Additional information: -1
> Additional information: 8192'
> DBW0: terminating instance due to error 1242
> Instance terminated by DBW0, pid = 38704

It's both an OS and Oracle error. It's an Oracle error because it's Oracle that detects it:

ORA-27063 skgfospo: number of bytes read/written is incorrect
Cause:    The number of bytes read/written as returned by AIOWAIT does not match
 the original number, additional information indicates both these numbers.
Action:    Check errno.

and

ORA-01242 data file suffered media failure: database in NOARCHIVELOG mode
Cause:    The database is in NOARCHIVELOG mode and a database file was detected
as inaccessible due to media failure.
Action:    Restore accessibility to the file mentioned in the error stack and re
start the instance.

It's also an OS error. All Oracle skg... functions are OS-related (the first s
probably means OS, then kg is Oracle kernel genereic layer). In this case, Oracle shows the actual OS error for number 11. You can also find it:

$ grep 11 /usr/include/sys/errno.h
#define EAGAIN  11      /* Resource temporarily unavailable     */
	or look at Perl $^E
$ perl -e '$^E=11; print $^E'
Resource temporarily unavailable$

(Note: the above is from Solaris 8 because I don't have an AIX account)

Generally, the ORA-1242 is caused by either a hardware problem or an Oracle bug. I remember AIX has a bug associated with AIO causing your problem. I had this error before on Solaris 7 and it was due to an incorrect installation of the hard drive.

Yong Huang
yong321 AT yahoo.com