RE: ORA-01114 and ORA-27063 ora error code

Admin — Sun, 18 Jan 2009 14:04:48 GMT

[b]Reference:[/b]

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.

RE: ORA-01114 and ORA-27063 ora error code

Admin — Sun, 18 Jan 2009 14:03:48 GMT

[b]Reference :[/b]

ORA-01114 IO error writing block to file string (block # string)

Cause: The device on which the file resides is probably offline. If the file is a temporary file, then it is also possible that the device has run out of space. This could happen because disk space of temporary files is not necessarily allocated at file creation time.

Action: Restore access to the device or remove unnecessary files to free up space.

ORA-01114 and ORA-27063 ora error code

Admin — Thu, 01 Jan 2009 07:09:23 GMT

You will see following ora error :

ORA-01114: IO error writing block to file 202 (block # 458633)
ORA-27063: skgfospo: number of bytes read/written is incorrect
SVR4 Error: 28: No space left on device
Additional information: -1
Additional information: 122880

or

ORA-01114: IO error writing block to file 202 (block # 458633)
ORA-27063: skgfospo: number of bytes read/written is incorrect
SVR4 Error: 28: No space left on device
Additional information: -1
Additional information: 122880

This means that a datafile cannot extend anymore because a disk (or mount point / raw device / or any storage device) is full.

Specifically, the high numbering of the file (in blue), refers to a temporary file.

If the number is in the range between 1 - DB_FILES, where DB_FILES is an initialization parameter whose value can be retrieved either with:

select * from v$parameter
where name = 'db_files';

or in SQL*Plus with

show parameter db_files

This means that we are talking of an ordinary datafile.

In this case DB_FILES was set to 200, which means that 202 refers to a temporary file and tempfiles are numbered starting from DB_FILES + 1.

If the temporary file is set to AUTOEXTEND ON, then the root cause of the problem can be a huge query on a view requiring a big sort operation or the insertion of lots of rows into a temporary table that made the temporary tablespace grow larger than usual until all the space on the device was used up.

One of things you want to do is check if temporary files are not sitting in the same filesystem as your datafiles. If you see this, then take the necessary steps to drop the tempfiles from the shared location and put them all in a single filesystem separate from the datafiles. Make sure that you have enough filesystem space on the new filesystem where the temp files will reside. Of course this is application dependant.

FranklinFaces.com - Oracle & SQL Server Database Forums for all IT Professionals / Oracle Forum / ORA - Oracle Database Error Codes - Search via specific error codes. / ORA-00000 Through ORA-09989 / ORA-01114 and ORA-27063 ora error code / Latest Posts

RE: ORA-01114 and ORA-27063 ora error code

RE: ORA-01114 and ORA-27063 ora error code

ORA-01114 and ORA-27063 ora error code