-
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.
Eric Hanson
There are 10 types of people in the world:
Those who understand binary and those who don't!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|