Re: EMC Storage Array Issue

Are you running Veritas as well? There are (I belive still outstanding) bugs with VXFS/VXVM on Oracle which cause these errors. Also, are you seeing high latency right times or experiencing 'hangs' in IO to your symmetrix? I've also seen faulty fiber cabling cause this problem (basically all IO to the symmetrix blocked, and the asynch io's timed-out.

George

On Monday, April 15, 2002, at 01:19 PM, Scott Canaan wrote:

> Claudio,
> I didn't think to mention the process. It is always the ckpt
> (checkpoint)
> background process that reports the problem. The database goes down
> with an
> ORA-27062.
>
> claudio cutelli wrote:
>
>> Hi,
>> which background process had the problem?
>> because if lgwr, it already write in sync mode ...
>>
>> ----- Original Message -----
>> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
>> Sent: Monday, April 15, 2002 5:33 PM
>>
>>> We have implemented a Sun Solaris Cluster (4 machines), connected
>>> to
>>> an EMC storage array. The migration began last fall, and we now have
>>> 15
>>> Oracle instances, with a mixture of 8.1.6 and 8.1.7, located there.
>>> We
>>> recently have had 2 occurances of asynchronous I/O wait times
>>> exceeded.
>>> When this occurs, every database crashes at the same time. The
>>> solution
>>> from EMC is to turn asynchronous I/O off in all of the Oracle
>>> instances
>>> (disk_async_io = false) and to increase the database writer slaves
>>> (dbwr_io_slaves = <something not 0>) to emulate asynchronous I/O.
>>> Has anyone run into this problem before? If so, how did you
>>> "correct" it? My feeling is that EMC is trying to give us a bandage
>>> to
>>> cover up the real problem, by trying to get Oracle to ignore it.
>>>
>>> Thank you.
>>>
>>> --
>>> Scott Canaan (srcdco_at_rit.edu)
>>> (585) 475-7886
>>> "Life is like a sewer, what you get out of it depends on what you put
>>> into it" - Tom Lehrer
>>>
>>>
>>> --
>>> Please see the official ORACLE-L FAQ: http://www.orafaq.com
>>> --
>>> Author: Scott Canaan
>>> INET: srcdco_at_ritvax.rit.edu
>>>
>>> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>>> San Diego, California -- Public Internet access / Mailing Lists
>>> --------------------------------------------------------------------
>>> To REMOVE yourself from this mailing list, send an E-Mail message
>>> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>>> the message BODY, include a line containing: UNSUB ORACLE-L
>>> (or the name of mailing list you want to be removed from). You may
>>> also send the HELP command for other information (like subscribing).
>>>
>> --
>> Please see the official ORACLE-L FAQ: http://www.orafaq.com
>> --
>> Author: claudio cutelli
>> INET: c_cutelli_at_hotmail.com
>>
>> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>> San Diego, California -- Public Internet access / Mailing Lists
>> --------------------------------------------------------------------
>> To REMOVE yourself from this mailing list, send an E-Mail message
>> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>> the message BODY, include a line containing: UNSUB ORACLE-L
>> (or the name of mailing list you want to be removed from). You may
>> also send the HELP command for other information (like subscribing).
>
> --
> Scott Canaan (srcdco_at_rit.edu)
> (585) 475-7886
> "Life is like a sewer, what you get out of it depends on what you put
> into it"
> - Tom Lehrer
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Scott Canaan
> INET: srcdco_at_ritvax.rit.edu
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>

// George Schlossnagle
// Principal Consultant
// OmniTI, Inc 		http://www.omniti.com
// (c) 301.343.6422   (e) george_at_omniti.com
// 1024D/1100A5A0  1370 F70A 9365 96C9 2F5E 56C2 B2B9 262F 1100 A5A0

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: George Schlossnagle
  INET: george_at_omniti.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).