ORA-01114: IO error writing block to file...

Howdy,

Receiving this error among others on an 8.1.7 db whose temporary tablespace file has just exceeded 4GB in size. OS=Windows Server 2003 Enterprise.

orclAlert.log:

Sat Jan 21 20:22:13 2006
KCF: write/open error block=0xfac90 online=1
file=4 E:\ORANT\ORADATA\ORCL\TEMP01.DBF
error=27069 txt: 'OSD-04026: Invalid parameter passed. (OS 1027216)'
Sat Jan 21 20:22:13 2006
Errors in file E:\orant\admin\orcl\bdump\orclDBW0.TRC:
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode
ORA-01114: IO error writing block to file 4 (block # 1027216)
ORA-01110: data file 4: 'E:\ORANT\ORADATA\ORCL\TEMP01.DBF'
ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
OSD-04026: Invalid parameter passed. (OS 1027216)


Extracted from referencing file E:\orant\admin\orcl\bdump\orclDBW0.TRC:

Dump file E:\orant\admin\orcl\bdump\orclDBW0.TRC
Sat Jan 21 20:22:13 2006
ORACLE V8.1.7.2.1 - Production vsnsta=0
vsnsql=f vsnxtr=3
Windows 2000 Version 5.2 , CPU type 586
Oracle8i Release 8.1.7.2.1 - Production
JServer Release 8.1.7.2.1 - Production
Windows 2000 Version 5.2 , CPU type 586
Instance name: orcl

Redo thread mounted by this instance: 1

Oracle process number: 3

Windows thread id: 6140, image: ORACLE.EXE


*** 2006-01-21 20:22:13.228
*** SESSION ID:(2.1) 2006-01-21 20:22:13.228
KCF: write/open error block=0xfac90 online=1
file=4 E:\ORANT\ORADATA\ORCL\TEMP01.DBF
error=27069 txt: 'OSD-04026: Invalid parameter passed. (OS 1027216)'
error 1242 detected in background process
ORA-01242: data file suffered media failure: database in NOARCHIVELOG mode
ORA-01114: IO error writing block to file 4 (block # 1027216)
ORA-01110: data file 4: 'E:\ORANT\ORADATA\ORCL\TEMP01.DBF'
ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
OSD-04026: Invalid parameter passed. (OS 1027216)

Thanks in advance!

time to raise an SR I thknk, and lookup OS error error 1027216

dear all ,, i m happy to join this forum ... i m doing OCP 9i certification ,, being a student please help me ...

Q. i was trying to creat queries to select all tables in TAB using HR schema
using ,, select 'Select * from ' || tname from tab
now please tell me the way to make the same to any table's columns????

dont post in any old thread, try some common sense

Why don't you restrict the data file size to 2GB?

Tamil

You usually get this error when Oracle thinks the data file is larger than the O/S thinks it is. Fortunately this is an easy fix. As it's a temp tablespace, you can just drop the tablespace & create new. As it's operating under Windoz, you should probably make sure that each file is no larger than 4 Gbytes. I know that Windoz can address large files, but Windoz 2000 always seems to cause problems for me. I would also suggest you upgrade to XP.

But if your really gonna upgrade, why not upgrade to a real operating system. :D