Re: Oracle on Win2k and async I/O

Make sure all oracle datafile's "auto-extend" is turned off. Some version of oracle and hardware has limit of 2G per oracle datafile.

Your last block 261557 x db_block_size 8192 = 2G, so the error says it can not write beyond 2G.

You can fix this problem by

1. turn off "auto-extend" for all oracle datafiles.
2. If you need more disk space for say TW_DEBUGX, just add more datafile (less or equal to 2G).

HTH. Guang

martyegan_at_rocketmail.com (Marty Egan) wrote in message news:<74ca126c.0209170758.4e2db400_at_posting.google.com>...
> I'm experiencing Oracle crashes that appear to be a problem with the
> Oracle async I/O interaction with the OS / array controller driver /
> array controller hardware. It appears that when Oracle goes to
> auto-extend (e.g. the temp tablespace) that it is then trying to write
> to a block inside the extended disk space before it actually has been
> created / extended.
> ===========================================
> === Here's the SQL and the log. ===
> === ===
> === (My system config is after the log ===
> === ===
> === init.ora is after the system config ===
> ===========================================
>
>
>
>
>
> SQL> CREATE INDEX STATS_INX ON STATS_IN(TIMEB) TABLESPACE ST_X;
>
> Index created.
>
> SQL> CREATE INDEX STATS_READERSX ON STATS_READERS(TIMEB) TABLESPACE
> ST_X;
>
> Index created.
>
> SQL> CREATE INDEX STATS_DETAILEDX ON STATS_DETAILED(TIMEB) TABLESPACE
> ST_DETAILX
> ;
>
> Index created.
>
> SQL> CREATE INDEX TWISTER_DEBUGX ON TWISTER_DEBUG(TIMET) TABLESPACE
> TW_DEBUGX;
> CREATE INDEX TWISTER_DEBUGX ON TWISTER_DEBUG(TIMET) TABLESPACE
> TW_DEBUGX
>
> From alert*.log *
> ERROR at line 1:
> ORA-00603: ORACLE server session terminated by fatal error
>
> Mon Sep 16 23:26:34 2002
> Errors in file C:\oracle\admin\NEWSDB01\udump\ORA02264.TRC:
> ORA-01114: IO error writing block to file 201 (block # 261557)
> ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
> OSD-04026: Invalid parameter passed. (OS 261572)
> ORA-01114: IO error writing block to file 201 (block # 261557)
> ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
> OSD-04026: Invalid parameter passed. (OS 261572)
> ORA-01114: IO error writing block to file 201 (block # 261557)
> ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
> OSD-04026: Invalid parameter passed. (OS 261572)
> ORA-01114: IO error writing block to file 201 (block # 261557)
> ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
> OSD-04026: Invalid parameter passed. (OS 261572)
>
> Mon Sep 16 23:26:42 2002
> Errors in file C:\oracle\admin\NEWSDB01\udump\ORA02264.TRC:
> ORA-00603: ORACLE server session terminated by fatal error
> ORA-01114: IO error writing block to file 201 (block # 261557)
> ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
> OSD-04026: Invalid parameter passed. (OS 261572)
> ORA-01114: IO error writing block to file 201 (block # 261557)
> ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
> OSD-04026: Invalid parameter passed. (OS 261572)
> ORA-01114: IO error writing block to file 201 (block # 261557)
> ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
> OSD-04026: Invalid parameter passed. (OS 261572)
> ORA-01114: IO error writing block to file 201 (block # 261557)
> ORA-27069: skgfdisp: attempt to do I/O beyond the range of the file
> OSD-04026: Invalid parameter passed. (OS 261572)
>
>
>
> ===================
> === Sys Config ===
> ===================
> Oracle 9x
> Win2k SP2 plus "critical" hotfixes.
> Compaq Proliant ML570
> Dual P3 Xeon with 1M cache
> Smart Array 5302 controller with 128M RAM
> 12-72Gig disk drives
> =6 drives on bus 1
> =6 drives on bus 2
> Array 1
> 72Gig = RAID 1 across bus 1 / id 1 and bus 2 / id 1
> OS, pagefile, temp space
> Array 2
> 271Gig = RAID 5 across bus 1 / id 2-6
> tablespace, roughly 2/3 capacity of array is filled
> Array 3
> 271Gig = RAID 5 across bus 2 / id 2-6
> tablespace, roughly 1/2 capacity of array is filled
>
>
>
> ===================
> === init.ora ===
> ===================
> ##############################################################################
> # Copyright (c) 1991, 2001 by Oracle Corporation
> ##############################################################################
>
> ###########################################
> # Cache and I/O
> ###########################################
> db_block_size=8192
> db_cache_size=335544320
>
> ###########################################
> # Cursors and Library Cache
> ###########################################
> open_cursors=300
>
> ###########################################
> # Diagnostics and Statistics
> ###########################################
> background_dump_dest=C:\oracle\admin\NEWSDB02\bdump
> core_dump_dest=C:\oracle\admin\NEWSDB02\cdump
> timed_statistics=TRUE
> user_dump_dest=C:\oracle\admin\NEWSDB02\udump
>
> ###########################################
> # Distributed, Replication and Snapshot
> ###########################################
> db_domain=""
> remote_login_passwordfile=EXCLUSIVE
>
> ###########################################
> # File Configuration
> ###########################################
> control_files=("C:\oracle\oradata\NEWSDB02\CONTROL01.CTL",
> "C:\oracle\oradata\NEWSDB02\CONTROL02.CTL",
> "C:\oracle\oradata\NEWSDB02\CONTROL03.CTL")
>
> ###########################################
> # MTS
> ###########################################
> dispatchers="(PROTOCOL=TCP)(SER=MODOSE)",
> "(PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer)",
> "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)"
>
> ###########################################
> # Miscellaneous
> ###########################################
> compatible=9.0.0
> db_name=NEWSDB02
>
> ###########################################
> # Network Registration
> ###########################################
> instance_name=NEWSDB02
>
> ###########################################
> # Pools
> ###########################################
> java_pool_size=33554432
> shared_pool_size=335544320
>
> ###########################################
> # Processes and Sessions
> ###########################################
> processes=300
>
> ###########################################
> # Redo Log and Recovery
> ###########################################
> fast_start_mttr_target=300
>
> ###########################################
> # Sort, Hash Joins, Bitmap Indexes
> ###########################################
> hash_area_size=10485760
> sort_area_size=10485760
>
> ###########################################
> # System Managed Undo and Rollback Segments
> ###########################################
> undo_management=AUTO
> undo_retention=10
> undo_tablespace=UNDOTBS
Received on Wed Sep 18 2002 - 21:30:13 CEST