Re: ORA-27072: skgfdisp: I/O error

From: Jesper <gollum_at_image.dk>
Date: Tue, 18 Jan 2000 17:51:28 GMT
Message-ID: <3884a74f.9784950@news.image.dk>

What platform? What Oracle version?

Can you actually read the entire file temp01.dbf?

Try to:

$ cat /usr/oracle/oradata/Oradata/temp01.dbf > /dev/null

Does that produce any errors?

/Jesper

On Tue, 18 Jan 2000 16:07:58 GMT, Parvinder Singh <parora_at_questone.com> wrote:

>
>--------------6BA663B725266F2CE9025D2C
>Content-Type: text/plain; charset=us-ascii
>Content-Transfer-Encoding: 7bit
>
>Hi all
>
> I have a table msr1_tab which contains 1 million recs after executing
>the
> following query it gave me the following error message after 1 hour
>...how
> do i handle the error ??
> i have also created one more file and associated with the TEMP
>tablespace
> but still it gave the same error
>
> i also rebooted my machine and again executed the same query this
>time it gave me the same error with some other block number (337624)
>the size of /usr/oracle/oradata/Oradata/temp01.dbf is 691716096 bytes
> the thing which i noticed is that my data is mounted on /usr partition
>and the available space on that partition is just around 6MB ..will that
>make a difference ?? i guess it should not because i have one more
>temp02.dbf file whose size is 400MB on the other partition which is
>associated with the TEMP tablespace so it can use that file for storing
>the temporary data while executing the query what do you say am i right
>??
>
> any idea?
> Thanks & Regards
> ~Parvinder
>
>also reply to parora_at_questone.com
>
> 11:40:46 SQL > select msr1_tab.pg_id, msr1_tab.ls_id, msr1_tab.res_id,
>msr1_tab.mth_id, msr1_tab.qtyno
> 11:40:47 2 from msr1_tab, program,
> 11:40:47 3 logistic_system,res,month
> 11:40:47 4 where msr1_tab.pg_id in(
> 11:40:47 5 select pg_id from program where pg_hierarchy= 'STANDARD')
>
> 11:40:47 6 and msr1_tab.ls_id in(
> 11:40:47 7 select ls_id from logistic_system where ls_hierarchy =
> 'STANDARD')
> 11:40:47 8 and msr1_tab.res_id in
> 11:40:47 9 (select res_id from res where res_hierarchy = 'STANDARD')
>
> 11:40:47 10 and msr1_tab.mth_id in
> 11:40:47 11 (select mth_id from month)
> 11:40:47 12 and program.pg_id = msr1_tab.pg_id
> 11:40:47 13 and logistic_system.ls_id = msr1_tab.ls_id
> 11:40:47 14 and res.res_id = msr1_tab.res_id
> 11:40:47 15 and month.mth_id = msr1_tab.mth_id;
> from msr1_tab, program,
> *
> ERROR at line 2:
> ORA-19502: write error on file
>"/usr/oracle/oradata/Oradata/temp01.dbf",
> blockno 337616
> (blocksize=2048)
> ORA-27072: skgfdisp: I/O error
> SVR4 Error: 25: Inappropriate ioctl for device
> Additional information: 337616
>
>
> real: 4096680
> 12:49:05 SQL
>
>
>--------------6BA663B725266F2CE9025D2C
>Content-Type: text/html; charset=us-ascii
>Content-Transfer-Encoding: 7bit
>
><!doctype html public "-//w3c//dtd html 4.0 transitional//en">
><html>
>Hi all
> I have a table msr1_tab which contains 1 million recs after executing
>the
>  following query it gave me the following error message after
>1 hour ...how
>  do i handle the error ??
>  i have also created one more file and associated with the TEMP
>tablespace
>  but still it gave the same error
>  i also  rebooted my machine and again executed the same
>query this time it gave me the same error with some other block number
>(337624)
> the size of /usr/oracle/oradata/Oradata/temp01.dbf is 691716096 bytes
>  the thing which i noticed is that my data is mounted on /usr
>partition and the available space on that partition is just around 6MB
>..will that make a difference ?? i guess it should not because i have one
>more temp02.dbf file whose size is 400MB on the other partition which is
>associated with the TEMP tablespace so it can use that file for storing
>the temporary data while executing the query what do you say am i right
>??
> any idea?
>  Thanks & Regards
>  ~Parvinder
>also reply to parora_at_questone.com
> 11:40:46 SQL > select msr1_tab.pg_id, msr1_tab.ls_id, msr1_tab.res_id,
>msr1_tab.mth_id, msr1_tab.qtyno
>  11:40:47   2  from msr1_tab, program,
>  11:40:47   3  logistic_system,res,month
>  11:40:47   4  where msr1_tab.pg_id in(
>  11:40:47   5  select pg_id from program where
>pg_hierarchy= 'STANDARD')
>  11:40:47   6  and msr1_tab.ls_id in(
>  11:40:47   7  select ls_id from logistic_system
>where ls_hierarchy =
>  'STANDARD')
>  11:40:47   8  and msr1_tab.res_id in
>  11:40:47   9  (select res_id from res where res_hierarchy
>= 'STANDARD')
>  11:40:47  10  and msr1_tab.mth_id in
>  11:40:47  11  (select mth_id from month)
>  11:40:47  12  and program.pg_id = msr1_tab.pg_id
>  11:40:47  13  and logistic_system.ls_id = msr1_tab.ls_id
>  11:40:47  14  and res.res_id = msr1_tab.res_id
>  11:40:47  15  and month.mth_id = msr1_tab.mth_id;
>  from msr1_tab, program,
>       *
>  ERROR at line 2:
>  ORA-19502: write error on file "/usr/oracle/oradata/Oradata/temp01.dbf",
>  blockno 337616
>  (blocksize=2048)
>  ORA-27072: skgfdisp: I/O error
>  SVR4 Error: 25: Inappropriate ioctl for device
>  Additional information: 337616
>  
>  real: 4096680
>  12:49:05 SQL
>  </html>
>
>--------------6BA663B725266F2CE9025D2C--
>
Received on Tue Jan 18 2000 - 11:51:28 CST