Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 29882 invoked from network); 10 Dec 2007 16:11:09 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 10 Dec 2007 16:11:01 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 798767D6960; Mon, 10 Dec 2007 17:10:57 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 01708-05-2; Mon, 10 Dec 2007 17:10:57 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9AFAB7D6B15; Mon, 10 Dec 2007 17:10:56 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 10 Dec 2007 17:08:48 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E678F7D6732 for ; Mon, 10 Dec 2007 17:08:47 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 01099-03-6 for ; Mon, 10 Dec 2007 17:08:47 -0500 (EST) Received: from usi.net (ms3aeo04.usi.net [209.135.62.29]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1E5917D6808 for ; Mon, 10 Dec 2007 17:08:47 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C83B79.3873EC02" Subject: RE: Oracle 10g RAC on AIX 5.3 Date: Mon, 10 Dec 2007 17:08:39 -0500 Message-ID: <56211FD5795F8346A0719FEBC0DB06750183548E@mds3aex08.USIEXCHANGE.COM> In-Reply-To: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Oracle 10g RAC on AIX 5.3 References: <746B47FAF6783042B256C0E7CC0795CD02557133@caonmastxm02.na.capgemini.com> From: "Crisler, Jon" To: , Cc: X-archive-position: 3828 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: Jon.Crisler@usi.com Precedence: normal Reply-to: Jon.Crisler@usi.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain ------_=_NextPart_001_01C83B79.3873EC02 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable I just finished an implementation of 10.2.0.3 RAC on AIX 5.3, having done many Linux and Solaris versions before. =20 OCFS / OCFS2 is only available for Linux and Windows. For AIX, GPFS or possibly Veritas Cluster File System would be the way to go (I am not positive that VCS is available for AIX). However, both are costly- we decided purely on cost to go with ASM. =20 For ASM , you have the database and (optional) flash recovery area on the SAN (which is presented as raw devices to ASM), and the Oracle home on local disks (one home each for every RAC node). You also present raw devices for the OCR and Voting disk- they are small (200mb or less) but due to storage system limitations you might have a minimum size requirement for a device. Our storage systems have a 1gb minimum size for each LUN, and I have heard of up to 8gb for other systems, but each is different. =20 ASM is actually easier to implement than I thought- you don't need to worry about sharing, mounting etc. You just have your storage guy or Unix sysadmin present the devices to the host, make sure the permissions are correct for the Oracle user, and that the devices map correctly (for example, /dev/rhdisk1 MUST be /dev/rhdisk1 on each and every node). This is actually a subset of the tasks that they would have gone through for a filesystem anyhow. Having separate Oracle homes makes patching a bit more flexible, since you can do rolling upgrades which cannot be done with a shared Oracle home. Not every patch is eligible for rolling upgrades, but the patchsets generally are. =20 Backups must be done with RMAN: if you are still doing old-style hotbackups at the filesystem level, then be prepared to abandon that method. But if you are using RMAN then everything is covered. Both Exports and Datapump can be used but you need to write to a filesystem. =20 Your direct question was: So the question, do we need OCFS, or GPFS, or neither, or both?? The answer is Neither, or GPFS / VCS, depending on what you want to do. The only drawback is that storage presented to ASM can only be used by ASM. =20 For AIX on RAC, there are a number of OS modules required, and most are detailed in the Oracle AIX manuals, but some are not- they become identified as prereqs for the other modules. The Cluster Verification Utility should point out what is missing. For instance, even in a non-HACMP setup, you still need a bunch of HACMP modules that are part of the base OS but not frequently installed. =20 =20 ________________________________ From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Jason Heinrich Sent: Monday, December 10, 2007 2:48 PM To: richard.goulet@capgemini.com Cc: oracle-l@freelists.org Subject: Re: Oracle 10g RAC on AIX 5.3 =20 Last I checked, Oracle does not provide OCFS for AIX, so if the client needs a clustered file system, GPFS would be the way to go. Whether or not they need it depends on what they want to do. You could install the Oracle software on each node and use ASM for the database storage. However, if you want a shared ORACLE_HOME or a shared non-ASM logging location, you'll need the clustered file system.=20 On 12/10/07, Goulet, Dick wrote: Guys & Gals, =20 I've done Oracle RAC install on Linux before, but noiw I'm being asked to do so on AIX 5.3 and I seem to be getting mixed signals from Oracle. The client originally wants to install AIX 5.3 with GPFS, but now to save a buck has decided not to install GPFS, but to instead use OCFS. On the other hand the Oracle docs are telling me that a clustered file system is only needed for the Oracle binaries. So the question, do we need OCFS, or GPFS, or neither, or both?? Anyone really know?? =20 =20 --=20 Jason Heinrich=20 ------_=_NextPart_001_01C83B79.3873EC02 Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

I just finished an implementation = of 10.2.0.3 RAC on AIX 5.3, having done many Linux and Solaris versions = before.

 

OCFS / OCFS2 is only available for = Linux and Windows.  For AIX, GPFS or possibly Veritas Cluster File System = would be the way to go (I am not positive that VCS is available for AIX).  = However, both are costly- we decided purely on cost to go with = ASM.

 

For ASM , you have the database and (optional) flash recovery area on the SAN (which is presented as raw = devices to ASM), and the Oracle home on local disks (one home each for every RAC = node).  You also present raw devices for the OCR and Voting disk- they are small = (200mb or less) but due to storage system limitations you might have a minimum = size requirement for a device. Our storage systems have a 1gb minimum size = for each LUN, and I have heard of up to 8gb for other systems, but each is = different.

 

ASM is actually easier to implement = than I thought- you don’t need to worry about sharing, mounting = etc.  You just have your storage guy or Unix sysadmin present the devices to the host, = make sure the permissions are correct for the Oracle user, and that the = devices map correctly (for example, /dev/rhdisk1 MUST be /dev/rhdisk1 on each and = every node).  This is actually a subset of the tasks that they would have = gone through for a filesystem anyhow.  Having separate Oracle homes = makes patching a bit more flexible, since you can do rolling upgrades which cannot be = done with a shared Oracle home.  Not every patch is eligible for rolling = upgrades, but the patchsets generally are.

 

Backups must be done with RMAN: if = you are still doing old-style hotbackups at the filesystem level, then be = prepared to abandon that method.  But if you are using RMAN then everything is = covered.  Both Exports and Datapump can be used but you need to write to a = filesystem.

 

Your direct question was: So the = question, do we need OCFS, or GPFS, or neither, or both??   The answer = is Neither, or GPFS / VCS, depending on what you want to do.  The only drawback is = that storage presented to ASM can only be used by = ASM.

 

For AIX on RAC, there are a number = of OS modules required, and most are detailed in the Oracle AIX manuals, but = some are not- they become identified as prereqs for the other modules.  The = Cluster Verification Utility should point out what is missing.  For = instance, even in a non-HACMP setup, you still need a bunch of HACMP modules that are part = of the base OS but not frequently installed.

 

 

From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] = On Behalf Of Jason Heinrich
Sent: Monday, December = 10, 2007 2:48 PM
To: = richard.goulet@capgemini.com
Cc: = oracle-l@freelists.org
Subject: Re: Oracle 10g = RAC on AIX 5.3

 

Last I = checked, Oracle does not provide OCFS for AIX, so if the client needs a clustered file = system, GPFS would be the way to go.  Whether or not they need it depends = on what they want to do.  You could install the Oracle software on each = node and use ASM for the database storage.  However, if you want a shared ORACLE_HOME or a shared non-ASM logging location, you'll need the = clustered file system.

On 12/10/07, Goulet, Dick <richard.goulet@capgemini.com > = wrote:

Guys & Gals,

 

    &nbs= p;       I've done Oracle RAC install on Linux before, but noiw I'm being asked = to do so on AIX 5.3 and I seem to be getting mixed signals from Oracle.  The = client originally wants to install AIX 5.3 with GPFS, but now to save a buck = has decided not to install GPFS, but to instead use OCFS.  On the other = hand the Oracle docs are telling me that a clustered file system is only = needed for the Oracle binaries.  So the question, do we need OCFS, or GPFS, or = neither, or both??  Anyone really know??

 

 


--
Jason Heinrich

------_=_NextPart_001_01C83B79.3873EC02-- -- http://www.freelists.org/webpage/oracle-l