Re: HELP - Async I/O Error?

Jason Moras wrote:

> Help!
>
> I am working in unfamilarity territory right now. I have a Windows 2000
> server with several disks on a SAN ( from an IBM ESS 2105 unit ) that I am
> getting errors like this.
>
>
> Thu Feb 21 11:07:49 2002
> Errors in file d:\oracle\admin\px6s\bdump\px6sCKPT.TRC:
> ORA-00221: error on write to controlfile
> ORA-00206: error in writing (block 3, # blocks 1) of controlfile
> ORA-00202: controlfile: 'F:\ORADATA\PX6S\CTL2PX6S.CTL'
> ORA-27070: skgfdisp: async read/write failed
> OSD-04016: Error queuing an asynchronous I/O request.
> O/S-Error: (OS 87) The parameter is incorrect.
>
> Oracle told my DBA that this is probably an Operating System issue. I cannot
> find any OS tuning I can do on Async I/O, and only "Write Cache" to disable
> in the driver settings for the hard drive and SCSI properties for "Disable
> syncronous transfer" - but I have left both these as defaults up to this
> point.
>
> Are there any Oracle issues here I should be aware of? This is on Win2k and
> Oracle 8i ( not sure version beyond that - but will check when i get ahold
> of DBA ).
>
> Does anyone know of issues with SAN connected storage?
>
> How about windows and tuning for async io?
>
> Anything can help - i appreciate it!
>
>
>
>

The default for NT/Win2K is disk_asynch_io=true, but if the driver software and/or the hardware doen't support async, set the parameter disk_async_io = false. Check by select * from v_$parameter where name like '%async%';

/Svend Jensen Received on Mon Feb 25 2002 - 12:24:08 CST