Re: URGENT Oracle ERROR!!!

From: djordjej <djordjej_at_home.com>
Date: Mon, 19 Mar 2001 05:31:22 -0800
Message-ID: <F001.002D06DD.20010319052635@fatcity.com>

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:

returned an error or
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:

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.
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.
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 <ORACLE-L_at_fatcity.com> 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: Saroj.Dash_at_gecapital.com
>
> 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: ListGuru_at_fatcity.com (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: djordjej_at_home.com

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: ListGuru_at_fatcity.com (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).

Received on Mon Mar 19 2001 - 07:31:22 CST