libaio you have is the latest/greatest as we haven't updated this in a
while (since SP2, I guess).

Have a look at bug Kevin mentioned is the possible cause. Requesting a
kernel fix (from Novell Support) is the best approach.

>>> On 9/29/2006 at 3:30 PM, in message
<882FA424B6407A4083B05C90E38615CE480A38@(protected)>,
"McAllister, Andrew" <McAllisterA@(protected):
> I'm willing to downgrade to any known good version of the kernel,
libaio
> and Oracle if necessary. Do you know of any such combinations?
>
> I just installed "the latest" to be up to date on a brand new
machine.
> I'll be the only OS user, but the database is going to get pounded
with
> about 10 gig of sqlldr data every day so I need speed and stability.
I'd
> be happy to fool around with Simon Grabinar's suggestions at
> http://www.grabinar.com/simon/aio.html or Fabrizio's. Heck, I'd be
> willing to upgrade to 10g. Whatever works and works fast.
Suggestions
> welcome.
>
> Andy
>
>
>> -----Original Message-----
>> From: Kevin Lyond [mailto:kevin.x.lyons@(protected)]
>> Sent: Friday, September 29, 2006 4:51 PM
>> To: suse-oracle@(protected)
>> Subject: Re: [suse-oracle] Libaio kernel bug on SLES9 SP3 with
9.2.0.8
>>
>> Hi Andy,
>>
>> McAllister, Andrew wrote:
>> > I received a kernel bug in my /var/log/messages and 0
>> seconds later my
>> > oracle database hung, all I could do was "shutdown abort"
>> even then the
>> > database wouldn't restart. I'm rebooting right now.
>> >
>> > The bug info is below. I've got libaio-0.3.102-1.2 installed
which
>> > appears to be the latest available through yast updates. Does
anyone
>> > have a more stable libaio for use with Oracle 9.2.0.8
>> running on SLES 9
>> > with SP3?
>> >  
>> I am not sure that a more recent libaio package would help
>> you, as this
>> is probably a real kernel bug and not something that would be
>> addressed
>> by the aio libraries.
> snip
>>
>> The stack trace is very similar. There is a patch that might
>> fix this
>> problem, but it did not make it into the latest kernel
>> update. If you
>> can, I recommend opening a SR with Novell, and if possible look into

>> Novell bugzilla #165140 as a possible solution.
>>
>> Thanks,
>> Kevin
> snip
>
> --
> To unsubscribe, email: suse-oracle-unsubscribe@(protected)
> For additional commands, email: suse-oracle-help@(protected)
> Please see http://www.suse.com/oracle/ before postin



--
To unsubscribe, email: suse-oracle-unsubscribe@(protected)
For additional commands, email: suse-oracle-help@(protected)
Please see http://www.suse.com/oracle/ before posting