Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!border1.nntp.dca.giganews.com!nntp.giganews.com!nx01.iad01.newshosting.com!newshosting.com!post01.iad01!not-for-mail
From: netcomradeNSPAM@bookexchange.net (NetComrade)
Newsgroups: comp.databases.oracle.server
Subject: Re: asynchronous i/o problem Oracle / Solaris (EXPERTS APPLY WITHIN)
Date: Wed, 14 Sep 2005 18:28:54 GMT
Message-ID: <43286ba4.425243796@localhost>
References: <1126649881.513997.271120@g44g2000cwa.googlegroups.com>
X-Newsreader: Forte Free Agent 1.11/32.235
Organization: Acecape, Inc.
Cache-Post-Path: nntp.acecape.com!unknown@p78-65.acedsl.com
X-Cache: nntpcache 3.0.1 (see http://www.nntpcache.org/)
Lines: 40
X-Complaints-To: abuse@newshosting.com
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:251516

DO you use Veritas?

I had a similar problem with 8 few months back:

http://groups.google.com/group/comp.databases.oracle.server/browse_thread/thread/89d15f9f342f3303/3f6850266d2314eb?lnk=st&q=lgwr+author:netcomrade&rnum=1&hl=en#3f6850266d2314eb

On 13 Sep 2005 15:18:01 -0700, "Johne_uk" <edgarj@tiscali.co.uk>
wrote:

>Hi,
>
>I've had a problem with a hanging database for some months and it is
>becoming more frequent (dbase hangs, cannot connect other than sys and
>generates no log / trace files etc.).
>
>The database is an 8.1.7.4 instance running on Solaris 9.0.4 (problem
>also occurred on Solaris 7).
>
>A consulant recently took me he thinks the issue may be linked to log
>file sync's and Solaris asynchronous i/o. We turned off Oracle
>asynchronous i/o (in init ora) and the problem still occurred.
>
>When the dbase was in a hung state, I captured the output from the
>Oracle LGWR process  with Solaris truss. It seemed to show that the
>process was writing in a continuous loop and thus not to disk resulting
>in the instance totally locking up.
>
>I've been suggested to look at the asynchronous i/o setup on the
>Solaris sparc box.
>
>Just wondering if anybody has any suggestions as to how I should
>approach this.
>
>regards
>John
>

.......
We use Oracle 8.1.7.4 and 9.2.0.6/7 on Solaris 2.7 and RH4
remove NSPAM to email