Re: 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" <[email protected]>
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: [email protected]
For additional commands, email: [email protected]
Please see http://www.suse.com/oracle/ before posting