Re: SLES9 SP4 and Async IO

Not at all - kernel is just happy. I tried to run strace on
rman, but did 
not found anything interesting as well.


----- Original Message ----- 
From: "Arun Singh" <Arun.Singhnovell.com>
To: "suse-oracle" <suse-oraclesuse.com>
Sent: Saturday, January 19, 2008 10:57 AM
Subject: Re: [suse-oracle] SLES9 SP4 and Async IO


Thanks Alexei.

I have added this to infamous bug 165140 (is the main AIO
code change 
between .287 and .308).

By any chance, Is there any kernel message to report with
this error?

>>> On 1/18/2008 at 10:56 PM,
"Alexei_Roudnev" 
>>> <Alexei_Roudnevexigengroup.com>
wrote:
> AsyncIO problem have been retested in VMWare.
>
> Yes, it is 100% the bug.
>
> Here is instruiction, how to reproduce the problem:
> 1) Instal SLES9 SP4 on x86_64 (I did not tested on i386
but I am almost 
> sure
>
> that bug exists there, too).
> 2) Install Oracle 10.2.0.3 (10.2.0.1 + patchset; may
be, 10.2.0.1 is
> enough). Use file system for data files.
> 3) Create a database with Flash Recovery Area and
Archive Logs. You can 
> use
> ext3 or reiserfs (with notail option) file system.
>
> - Set up ASYNCIO + DIERCT IO:
>
>  alter system set FILESYSTEMIO_OPTIONS=setall
SCOPE=SPFILE
>
>  (and restart the database). You can configure it on
initial database 
> setup.
>
> instead.
>
> - Run few transactions to create archive logs (I did
not tested with the
> small logs; I tested after the full HAMMERORA/TPC-C
paths; I suspect that 
> it
> doesn't matter at all, but can't confirm it).
>
> - Now, run rman. As Oracle, do:
>
>    export ORACLE_SID=<db_sid>
>    rman (remove /usr/X11R6/bin/rman to prevent shell
confusion).
>    connect target
>    backup validate archivelog all;
>
> DONE. You have read error.
>
> Now change the kernel to the kernel 287 (rpm -U
-oldversion ...., or any
> other way).
> Try rman again. Now it works.
>
> Another experiments show, that not only rman is
affected, but log shipping
> (in oracle) is affected. The only difference is that
log shipping works 
> well
>
> if filesystemio_options=ASYNCH but doesn't work with
SETALL, while rman
> doesn't work with both SETALL and ASYNCH, modes.
>
>
>
>



-- 
To unsubscribe, email: suse-oracle-unsubscribesuse.com
For additional commands, email: suse-oracle-helpsuse.com
Please see http://www.suse.com/oracl
e/ before posting



-- 
To unsubscribe, email: suse-oracle-unsubscribesuse.com
For additional commands, email: suse-oracle-helpsuse.com
Please see http://www.suse.com/oracl
e/ before posting