My Oracle Support Banner

ORA-1110, ORA-1115, File#n, ORA-27063 Bytes Read/Written Incorrect (Doc ID 472653.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 9.2 to 11.2]
Oracle Solaris on SPARC (64-bit)


On database startup, the following error is reported;

SQL> startup
ORACLE instance started.
Total System Global Area  514328528 bytes
Fixed Size                   731088 bytes
Variable Size             218103808 bytes
Database Buffers          285212672 bytes
Redo Buffers               10280960 bytes
Database mounted.
ORA-01110: data file n: 'datafile.DBF'
ORA-01115: IO error reading block from file n (block # 1)
ORA-27063: skgfospo: number of bytes read/written is incorrect
Additional information: 8192
Additional information: 16384

DBVerify reports the following;

DBV-00102: File I/O error on FILE (datafile.DBF) during verification read operation (-2)

plus, at the same time the DBVerify was run, the /var/adm/messages file contains warnings, similar to;

Dec 27 14:28:19 node scsi: [ID 107833 kern.warning] WARNING: /pci@1c,600000/scsi@2/sd@1,0 (sd1):
Dec 27 14:28:19 node Error for Command: read(10)                Error Level: Retryable
Dec 27 14:28:19 node scsi: [ID 107833 kern.notice] Requested Block: 2910944                   Error Block: 2911043
Dec 27 14:28:19 node scsi: [ID 107833 kern.notice] Vendor: FUJITSU                            Serial Number: nnnn
Dec 27 14:28:19 node scsi: [ID 107833 kern.notice] Sense Key: Media Error
Dec 27 14:28:19 node scsi: [ID 107833 kern.notice] ASC: 0x11 (<vendor unique code 0x11>), ASCQ: 0x1, FRU: 0x0


What do these findings mean, and how do I overcome them?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.