ORA-01114: IO error writing block to file 125
- From: Bryan Wells <bunjibry@xxxxxxxxx>
- To: Oracle-L <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 10 Dec 2004 11:12:26 -0700
All
Im running 9.2.0.0 on MS 2000 Advanced Server when I get the
previously mentioned error, allong with the following when attempting
to create a materialized view. Here are the tablespace specs as well.
up to last evening, this view was being created just fine.
I have been looking at metalink et. al. site that stating datafile
size greater than 4G, but am concerned about the validity since this
has not happened prior to this. Im hoping someone can tell if Im just
too green. At any rate, if anyone has had this issue and has a
solution, hopfully not that the DB is completely HOSED. please
respond. Il buy the virtual beers
============================================================
CREATE TABLESPACE "STAR_DATA_MV"
NOLOGGING
DATAFILE 'E:\ORACLE\ORADATA\GDWP\STAR_DATA_MV_01.DBF' SIZE
4096M REUSE AUTOEXTEND
ON NEXT 5120K MAXSIZE 4096M,
'E:\ORACLE\ORADATA\GDWP\STAR_DATA_MV_02.DBF' SIZE 4096M REUSE
AUTOEXTEND
ON NEXT 100M MAXSIZE 4096M,
UNIFORM SIZE 1024K SEGMENT SPACE MANAGEMENT MANUAL
============================================================
Dump file d:\oracle\admin\gdwp0\bdump\gdwp_dbw0_1884.trc
Fri Dec 10 03:29:03 2004
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Windows 2000 Version 5.0 Service Pack 4, CPU type 586
Instance name: gdwp
Redo thread mounted by this instance: 1
Oracle process number: 3
Windows thread id: 1884, image: ORACLE.EXE
*** 2004-12-10 03:29:03.000
*** SESSION ID:(2.1) 2004-12-10 03:29:03.000
KCF: write/open error block=0x1f245 online=1
file=121 E:\ORACLE\ORADATA\GDWP\STAR_DATA_MV_02.DBF
error=27069 txt: 'OSD-04026: Invalid parameter passed. (OS 127557)'
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 121 (block # 127557)
ORA-01110: data file 121: 'E:\ORACLE\ORADATA\GDWP\STAR_DATA_MV_02.DBF'
ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
OSD-04026: Invalid parameter passed. (OS 127557)
============================================================
--
Bryan S Wells - DBA Newbie
bunjibry@xxxxxxxxx
--
//www.freelists.org/webpage/oracle-l
Other related posts:
- » ORA-01114: IO error writing block to file 125
