Oracle on Win2k and async I/O
Date: 17 Sep 2002 08:58:30 -0700
Message-ID: <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.
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;
Mon Sep 16 23:26:34 2002
;
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
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 Tue Sep 17 2002 - 17:58:30 CEST