ORA-01114: IO error writing block to file 125

From: Bryan Wells <bunjibry_at_gmail.com>
Date: Fri, 10 Dec 2004 11:12:26 -0700
Message-ID: <b78d5a200412101012327b40f1@mail.gmail.com>

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_at_gmail.com
--
http://www.freelists.org/webpage/oracle-l

Received on Fri Dec 10 2004 - 12:13:46 CST