Here is the document from Metalink regading this error:
HTH.
Djordje
*********
Doc ID:
Note:49946.1
Subject:
OERR: ORA 27072 skgfdisp:
I/O error
Type:
REFERENCE
Status:
PUBLISHED
Content Type:
TEXT/PLAIN
Creation Date:
21-NOV-1997
Last Revision Date:
08-JUN-1999
Language:
USAENG
Error: ORA-27072
Text: skgfdisp: I/O error
---------------------------------------------------------------------------
Cause: read/write/readv/writev system call returned error, additional
information indicates starting block number of I/O
Action: check errno
*** Important: The notes below are for experienced users - See
[NOTE:22080.1]
Explanation:
This error was introduced in Oracle8.
The error is raised in port specific code so the exact system calls
preceeding the error can vary between platforms. The error indicates
that a read or write call either:
a) returned an error
or
b) returned a value indicating that the number of bytes
read/written
does not match the number of bytes we asked to read/write
Hence the error number reported may or may not be meaningful.
If the read/write returned an error then the ERRNO reported corresponds
to the actual read/write call used. If the read/write returned a
different
number of bytes to that expected then ERRNO is just the left over error
from some previous system call and should be ignored.
Additional information is the first BLOCK NUMBER being read/written
in the named file.
Diagnosis:
1. 2Gb limits (or other limits) can cause this sort of error so check if
the filename reported in the corresponding error is a large file.
The block number in the additional information can help show if you
are close to this limit.
2. It is helpful to know the system call which caused the error so
exact version information is important. If the error is repeatable at
will then TRUSS or similar may help identify the call raising the
error.
3. Determine if the file/s are on raw devices / logical raw volumes or
file system files.
References / Known Bugs etc..
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
There are several known issues that can cause this error, plus it can be
a non-Oracle problem so it is important to collect all the information:
2Gb or not 2Gb - file limits in Oracle [NOTE:62427.1]
See the above article as an anchor point for 2Gb issues on various
platforms.
Eg: Solaris 2Gb issue [BUG:774252]
Backup of RAW controlfile [NOTE:60953.1]
Sequent AIO issue [NOTE:64632.1]
----- Original Message -----
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Monday, March 19, 2001 3:05 AM
> Hello All,
>
> J ust now i got a error select count(*) from s_org_ext.
>
> SQLWKS> select count(*) from s_org_ext; where S_org_ext is Name of the
> Table.
> COUNT(*)
> ----------
> ORA-01115:
> ORA-01110: 4: /db/oracle/oradata/tlisuser/data03.dbf
> ORA-27072: skgfdisp:
> SVR4 Error: 25: Inappropriate ioctl for device
> Additional information: 262132
>
> But When I do select x,y,z,t,..... from s_org_ext then No error occured.
>
> The size of that Table is 2.4GB. Its Initial extent is 1Gb and Next is
1mb.
>
> Vesion of Orcale 8.0.5 and OS is Sun solaris 5.6
>
> Developped got this error while executing a procedure. I think that
> procedurte will be insert into data into s_org_ext.
>
> PLease tell me what i will do. I think datafile will be damagaed. can not
> coiped on OS prompt when last time I took backup.
>
> Please help me.,
>
> Regards,
> Saroj.
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Dash, Saroj (CAP,CEF)
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: djordjej
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
