SLES9 SP4 and Async IO

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.





----- Original Message ----- 
From: "Arun Singh" <[email protected]>
To: "suse-oracle" <[email protected]>
Sent: Monday, January 14, 2008 9:28 AM
Subject: Re: [suse-oracle] SLES 9 SP4 and OCFS2


Hi Werner,

This is not a normal behavior ;-)

Please have a look at 
http://oss.oracle.com/projects/ocfs2/dist/documentation/ocfs2_users_guide.pdf 
and post your question to Oracle ocfs2-users 
list(http://oss.oracle.com/pipermail/ocfs2-users/2008-January/002318.html  ). 
OCFS2 experts available on ocfs2-users list to take your questions.

PS: In case you all are wondering, which cool article is referred here: 
http://www.novell.com/coolsolutions/feature/18287.html

Regards,
Arun


>>> On 1/14/2008 at 8:55 AM, Werner Flamme <[email protected]> wrote:
> Hi everyone,
>
> I read Arun's cool guide "Creating shared storage on SLES 10 using Xen
> and OCFS2". This was a good inspiration for me ;-)
>
> I have 3 machines running SLES 9 SP 4. Two of them are connected to a FC
> RAID (Sun 3510), the 3rd will be connected soon. Since the machines are
> running SAP, I want to use OCFS2 for the common directory /usr/sap/trans.
>
> I used Arun's guide and proceeded like he wrote from point 6 on (I don't
> have Xen). Everything went well, the config was propagated, 2 machines
> can mount the same filesystem in rw mode without scrambling it.
>
> But: when I create a file, eg. /usr/sap/trans/mytest, this file is not
> shown on the other machine. Both nodes show active heartbeat. Is this
> expected behaviour? (not for me, though ;-))
>
> After unmount und remountig the fs again, the file is shown.
>
> Upgrading to SLES 10 SP 1 is not an option yet. What else do I have to
> do, that a file created on one node is accessible on another without
> having to unmount and mount again? BTW, mount -o remount does not work.
>
> Regards,
> Werner





-- 
To unsubscribe, email: [email protected]
For additional commands, email: [email protected]
Please see http://www.suse.com/oracle/ before posting



-- 
To unsubscribe, email: [email protected]
For additional commands, email: [email protected]
Please see http://www.suse.com/oracle/ before posting