ORA-01114: IO error writing block to file...
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

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

Hybrid View

  1. #1
    Join Date
    Jan 2006
    Posts
    1

    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!

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    time to raise an SR I thknk, and lookup OS error error 1027216

  3. #3
    Join Date
    Jan 2006
    Location
    pakistan
    Posts
    2
    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????

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    dont post in any old thread, try some common sense

  5. #5
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    Why don't you restrict the data file size to 2GB?

    Tamil

  6. #6
    Join Date
    Apr 2001
    Posts
    108
    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
  •  



Click Here to Expand Forum to Full Width