Re: Oracle 8i IO errors

Try (as dba)
select file_id,file_name from dba_data_files where file_id=4

this will give you the path of the failing file

check to see if disk is full ! (autoextend a full platter ? )

otherwise tail the alert log

usually
in

XXX/admin/SID/bdump where XXX is oracle h dir for the DB and SID is the instance id.

or easier just search for *ALRT*.log and check the last few lines -= your problem should be there in living colour.

Hope this helps .

Chris ,.
"Chloe Crowder" <chloe.crowder_at_bl.uk> wrote in message news:aatjig$5fq$1_at_south.jnrs.ja.net...
> A problem has reared its head on one of our servers and I need some help.
>
> While loading records at the point when the process tried to create the
> index required before processing starts the following error message was
> received:
>
> SQL EXCEPTION: ORA-00603: ORACLE server session terminated by fatal error
> ORA-01114: IO error writing block to file 4 (block # 524232)
> ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
> OSD-04026: Invalid parameter passed. (OS 524232)
> ORA-01115: IO error reading block from file 4 (block # 366740)
> ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
> OSD-04026: Invalid parameter passed. (OS 366740)
> ORA-01115: IO error reading block from file 4 (block # 366740)
> ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
> OSD-04026: Invalid parameter passed. (OS 366740)
>
> I tried to create the index manually but got the same error minus the
first
> line.
>
> The database is running on an NT4 server, with all disks mounted locally,
> i.e. no remote mounts, optical drives etc. Since an index was being
created
> I think its probably a temporary area involved, but I can't be certain of
> this.
>
> Any help would be much appreciated, since my knowledge of Oracle could be
> fitted in a small matchbox without taking the matches out first. Ingres,
I'm
> your girl, but Oracle I'm still at the floundering stage!
>
> Chloe Crowder
> The British Library
>
>
Received on Fri May 03 2002 - 09:51:29 CDT