<div>Ulf,</div> <div> </div> <div> I have implemented a few RAC databases and worked with OCFS, OCFS2, NetApp and ASM on different machines.</div> <div> </div> <div> In my opinion, currently, OCFS2 seems to be rather stable for Oracle use, except for some race conditions with CRS when the CRS files are on OCFS2 and the small default timeouts. Both can be tuned or worked around so as to not cause major headaches.</div> <div> </div> <div> One thing that caused me trouble was the fact that 10g has asyncronous I/O linked in by default, this was changed from what was on 9i, and the async I/O handlers deplete very fast if they are not tuned up when using OCFS2. Somehow this seems to be completely undocumented except for some ancient RedHat papers, and seems to cause problems in CRS. This can be seen as /proc/sys/fs/aio-nr reaches the value on /proc/sys/fs/aio-max-nr.</div> <div> </div>
<div> Aside from that usually the problems I have are on changes of the optimizer or some 10g specific bugs causing ORA-600. One thing that is very important is to gather statistics, including "system" statistics, as there is a big change on the optimizer that now considers also the CPU cost for choosing the execution plan. This change on the optimizer also appears when applying 9.2.0.7 and 9.2.0.8.</div> <div> </div> <div> Hope you have better luck on the next try.</div> <div> </div> <div>Regards,</div> <div>Luis</div> <div><BR><B><I>Ulf Zimmermann <ulf@atc-onlane.com></I></B> wrote:</div> <BLOCKQUOTE class=replbq style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #1010ff 2px solid"><BR>> -----Original Message-----<BR>> From: ocfs2-users-bounces@oss.oracle.com [mailto:ocfs2-users-<BR>> bounces@oss.oracle.com] On Behalf Of Sunil Mushran<BR>> Sent: 05/07/2007 10:47<BR>> To:
Alexei_Roudnev<BR>> Cc: Ocfs2-users@oss.oracle.com<BR>> Subject: Re: [Ocfs2-users] Hi<BR>> <BR>> None of what you have written allows you to use our resources to<BR>> spread your opinions as official recommendation.<BR>> <BR>> Alexei_Roudnev wrote:<BR>> ><BR>> > Oracle itself have not a SINGLE opinion (to be curious, I hear a<BR>strong<BR>> > recommendation against OCFSv2 from oracle support, which I can not<BR>agree<BR>> > with), so we can't treat your recommendations as official as well -<BR>you<BR>> are<BR>> > interested in OCFSv2 while users are not (users are interested in<BR>making<BR>> our<BR>> > data centers run smoothly). The only _official_ thing is<BR>_certification<BR>> > matrix_.<BR>> ><BR>> > ----- Original Message -----<BR>> > Alexei,<BR>> > While you are free to use this forum to share your opinions, do not<BR>> > couch these opinions as official
recommendations. When push comes to<BR>> > shove, we are helping users not you. We develop, build, distribute<BR>> > the software, not you. So it may serve to community better if you<BR>> > let us offer the "official" recommendations and not you.<BR>> ><BR>> > Sunil<BR><BR>Just to add some comments from a user of Oracle 9i with OCFSv1 on RedHat<BR>AS2.1 who tried to upgrade to EL4 and OCFSv2 and failed miserable:<BR><BR>Oracle support pretty much told us the problems we were running into are<BR>problems of OCFSv2 and they weren't really willing to help us. The<BR>feeling we were getting was that two Oracle departments (the one writing<BR>the Database RAC engine and the one writing OCFSv2) are fighting with<BR>each other.<BR><BR>In general I have a very low opinion of Oracle and their quality of code<BR>and tools. Like patch revision numbering? Does not exist. Patch tools<BR>suppose to patch all machines in clusters? You wish. Decent
error<BR>messages? They never heard about that.<BR><BR>We ended up with staying on AS2.1 and OCFSv1 for now and just migrating<BR>our data to a new SAN.<BR><BR>Regards, Ulf.<BR><BR>---------------------------------------------------------------------<BR>ATC-Onlane Inc., T: 650-532-6382, F: 650-532-6441<BR>4600 Bohannon Drive, Suite 100, Menlo Park, CA 94025<BR>---------------------------------------------------------------------<BR><BR>_______________________________________________<BR>Ocfs2-users mailing list<BR>Ocfs2-users@oss.oracle.com<BR>http://oss.oracle.com/mailman/listinfo/ocfs2-users<BR></BLOCKQUOTE><BR><p> 
<hr size=1>Ahhh...imagining that irresistible "new car" smell?<br> Check out
<a href="http://us.rd.yahoo.com/evt=48245/*http://autos.yahoo.com/new_cars.html;_ylc=X3oDMTE1YW1jcXJ2BF9TAzk3MTA3MDc2BHNlYwNtYWlsdGFncwRzbGsDbmV3LWNhcnM-">new cars at Yahoo! Autos.</a>