RE: Location of ASM spfiles in RAC
From: Randy Johnson <oraclelist_at_sbcglobal.net>
Date: Thu, 18 Jun 2009 08:42:37 -0500
Message-ID: <002a01c9f01a$a46ecab0$ed4c6010$_at_net>
Jason is correct. It’s a chicken and egg thing. I always go with local init.ora file. Just personal preference. I guess the main reason is simplicity. I don't need NFS for anything else so why would I add the complexity/liability of a shared file system into my architecture when the ASM parameters are usually "set it and forget it". You rarely have to change the ASM parameters after you get your system setup.
Date: Thu, 18 Jun 2009 08:42:37 -0500
Message-ID: <002a01c9f01a$a46ecab0$ed4c6010$_at_net>
Jason is correct. It’s a chicken and egg thing. I always go with local init.ora file. Just personal preference. I guess the main reason is simplicity. I don't need NFS for anything else so why would I add the complexity/liability of a shared file system into my architecture when the ASM parameters are usually "set it and forget it". You rarely have to change the ASM parameters after you get your system setup.
-Randy
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of jason arneil
Sent: Thursday, June 18, 2009 4:38 AM
To: exriscer_at_gmail.com
Cc: veeeraman_at_gmail.com; ORACLE-L
Subject: Re: Location of ASM spfiles in RAC
Hello,
You can't store the ASM spfile in ASM.
Agreed never local, I'm using raw device.
jason
-- http://jarneil.wordpress.com 2009/6/18 LS Cheng <exriscer_at_gmail.com>:Received on Thu Jun 18 2009 - 08:42:37 CDT
> Hi
>
> Usually I stored inside ASM but a couple of times I used raw devices for
> that. Never local though (no point)
>
> Thanks
>
> --
> LSC
>
>
>
> On Thu, Jun 18, 2009 at 7:39 AM, Ram Raman <veeeraman_at_gmail.com> wrote:
>>
>> Listers,
>>
>> What do you normally use as the location of ASM's spfile in a RAC
>> database. I have to decide between spfiles local to each node vs a shared
>> raw device. oracle 10g with ASM. OCR and VD in raw devices, no CFS.
>>
>> Thanks.
>
-- http://www.freelists.org/webpage/oracle-l __________ Information from ESET NOD32 Antivirus, version of virus signature database 4167 (20090618) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com __________ Information from ESET NOD32 Antivirus, version of virus signature database 4167 (20090618) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com __________ Information from ESET NOD32 Antivirus, version of virus signature database 4167 (20090618) __________ The message was checked by ESET NOD32 Antivirus. http://www.eset.com -- http://www.freelists.org/webpage/oracle-l