Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 23946 invoked from network); 13 Dec 2007 12:23:51 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-69-64-49-119.inaddr.intergenia.de with SMTP; 13 Dec 2007 12:23:51 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9D13C7D87DF; Thu, 13 Dec 2007 13:23:51 -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 28548-06; Thu, 13 Dec 2007 13:23:51 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 12EEC7D84F1; Thu, 13 Dec 2007 13:23:51 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 13 Dec 2007 12:36:55 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6E1257D8BAB for ; Thu, 13 Dec 2007 12:36:55 -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 22409-06 for ; Thu, 13 Dec 2007 12:36:55 -0500 (EST) Received: from nz-out-0506.google.com (nz-out-0506.google.com [64.233.162.224]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BAE2D7D8C1D for ; Thu, 13 Dec 2007 12:36:54 -0500 (EST) Received: by nz-out-0506.google.com with SMTP id s18so425078nze.1 for ; Thu, 13 Dec 2007 09:36:54 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; bh=O7m1D3kD4Sq84Q+C8LsZd5SPgUVuuokEWjxPvRtgaz0=; b=kB+XUjwwhdYWpMS81ZfksBTTflmvwba5Srmw1PThm7R3QaN5KS8unbicI4ZJ8e0UIJnFf6I2oCmfkPP1Oqjg3yKa1oKsM6IEn2rGHrGtq58md+rp5HNEHHtXvxZhApC9SfgSmwZIuqcuV8lw8CEmoyOAlywUSNeDZ+d5qppoBr0= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=Q795xJQxqlSu3MX2ljx0a+2I4wWGc9mwjFrperAhH138gRNTKsaKd5p57zWXJc9iU396GhudzQ4LdgtsxHdjtbWuBYpK3K7MKyTajDsqPbx70nm3LJmHQNZwwUVU+q2psPxYtrsHt+AbsJA+BZ+fAslvVZ+bGqRTPAtJ4f6+Pjk= Received: by 10.114.199.1 with SMTP id w1mr2520834waf.109.1197567413407; Thu, 13 Dec 2007 09:36:53 -0800 (PST) Received: by 10.114.154.3 with HTTP; Thu, 13 Dec 2007 09:36:53 -0800 (PST) Message-ID: <5f35c2320712130936l592b69dbgbe9b8fce42d33b18@mail.gmail.com> Date: Thu, 13 Dec 2007 11:36:53 -0600 From: "Li Li" To: "Niall Litchfield" Subject: Re: separate owner/ORACLE_HOME for crs, ASM, and database in RAC environment Cc: "Dan Norris" , "William Wagman" , finn.oracledba@gmail.com, oracle-l In-Reply-To: <7765c8970712130125p2e81b2f7t7c866300243d2512@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_42720_9014310.1197567413397" References: <774166.43674.qm@web35415.mail.mud.yahoo.com> <5f35c2320712121850p6b62c2a7k15d8fcd452d0e739@mail.gmail.com> <7765c8970712130125p2e81b2f7t7c866300243d2512@mail.gmail.com> X-archive-position: 3929 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: litanli@gmail.com Precedence: normal Reply-to: litanli@gmail.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 ------=_Part_42720_9014310.1197567413397 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Thanks Niall, I did set the ORA_CRS_HOME environment variable On Dec 13, 2007 3:25 AM, Niall Litchfield wrote: > We have a very similar setup - which i don't like by the way - I cant > look today but think you might need to set CRS_ORACLE_HOME in your > environment. I concur about the logs by the way. > > On 13/12/2007, Li Li wrote: > > Hi, Dan, > > > > my OSASM group is "dba" also, I know this defeats some of the > separation, > > but I just wanted to test this out. It's very strange to me that I have > this > > issue because in my case both oracle and oraclex have "oinstall" as > primary > > group and "dba" as second group, and oracle's RDBMS home and oraclex's > RDBMS > > home all have 775 permission. I am trying to get some other eyes on this > > issue to see what I am missing :( > > > > Thank you all for your time to reply! > > -Li > > > > On Dec 12, 2007 7:20 PM, Dan Norris wrote: > > > > > In my experiences with this, the oraclex user (the RDBMS owner) will > have > > > to be in the OSASM group. This defeats some of the separation, but as > I > > > understand it, the Oracle developers know that the separation isn't > quite > > > complete yet and someone told me that we should expect "true" > separation > > in > > > a future release (probably 11g R2). If your OSASM group is also dba, > then > > > I'm not sure I know why you're having issues. I tried the same thing > and > > had > > > three users: 1) a clusterware owner, 2) an ASM owner, and 3) an RDBMS > > owner. > > > I found that the clusterware can be separated pretty cleanly from the > > other > > > two, but the ASM and RDBMS owners essentially have power over each > others' > > > domains since the RDBMS user must be in the OSASM group and I think > the > > ASM > > > owner may have had to be in the OSDBA. I don't have access to my test > > > systems for this any longer, so my memory may be a little off. It's > also > > > possible that things have changed slightly since my testing which was > done > > > with 11gR1-beta5. > > > > > > Dan > > > > > > > > > ----- Original Message ---- > > > From: Li Li > > > To: William Wagman > > > Cc: finn.oracledba@gmail.com; oracle-l > > > Sent: Wednesday, December 12, 2007 5:51:26 PM > > > Subject: Re: separate owner/ORACLE_HOME for crs, ASM, and database in > RAC > > > environment > > > > > > Hi, Bill, > > > > > > I don't use asmlib because its dependency on linux kernel. I just > create > > > ASM diskgroups using RAW devices. when I login as oracle and start > dbca, > > ASM > > > disks are all look/work fine. > > > > > > > > > On Dec 12, 2007 5:14 PM, William Wagman wrote: > > > > > > > Greetings, > > > > > > > > The thinking is to separate CRS, ASM and RDBMS for ease of > maintenance. > > > > This is also the Oracle suggestion that each be in a separate home. > It > > makes > > > > patching and upgrading easier. > > > > > > > > As to the disk issues. First are you using ASMLIB? Make sure if you > are > > > > it is configured correctly and the disks have been created. > > > > > > > > Also look at the status of this disks as described in v$asm_disk. > They > > > > status must be either provisioned or candidate. I have encountered > this > > > > situation before where the status was unknown and that caused me > > problems. > > > > > > > > Also, are you using multipathing? If so make sure you have scanorder > and > > > > scanexclude set correctly in the oracleasm file as that can affect > > things. > > > > There was a thread about this a while ago. > > > > > > > > I apologize for not being more specific but I still don't have a > good > > > > enough understanding of how things work. A lot of what I have done > is > > > > through trial and error and can give you things to look at but > that's > > about > > > > it at this point. > > > > > > > > > > > > Bill Wagman > > > > Univ. of California at Davis > > > > IET Campus Data Center > > > > wjwagman@ucdavis.edu > > > > (530) 754-6208 > > > > > > > > > > > > *From:* oracle-l-bounce@freelists.org > > [mailto:oracle-l-bounce@freelists.org > > > > ] *On Behalf Of *Finn Jorgensen > > > > *Sent:* Wednesday, December 12, 2007 2:09 PM > > > > *To:* litanli@gmail.com > > > > *Cc:* oracle-l > > > > *Subject:* Re: separate owner/ORACLE_HOME for crs, ASM, and database > in > > > > RAC environment > > > > > > > > Before trying to figure this one out, I'm trying to wrap my brain > > > > around why you would do that. What's the thinking behind this setup? > > > > > > > > Finn > > > > > > > > > > > > On 12/12/07, Li Li wrote: > > > > > > > > > > Hi, List, > > > > > > > > > > I am testing to setup a 2-node RAC environment with separate > > > > > owner/ORACLE_HOME for crs, ASM, and database, it's 10gR2 on Redhat > AS > > 4. > > > > > > > > > > 2 users are created: oracle and oraclex, oracle owns clusterware > home > > > > > and ASM home, oraclex owns database home. > > > > > > > > > > first, I login as oracle and installed clusterware and database > > > > > software (in 2 different oracle home of course), configured and > > started ASM > > > > > instance, everything worked fine. > > > > > > > > > > second, I login as oraclex and installed database software, then I > > > > > tried to create a database using dbca, but I ran into error when I > > chose ASM > > > > > as my database storage, the error is: > > > > > "DBCA could not startup the ASM instance configured on this node. > To > > > > > proceed with database creation using ASM you need the ASM instance > to > > be up > > > > > and running. Do you want to recreate the ASM instance on this > node?" > > > > > > > > > > But the ASM instance IS already running. I am guessing this must > be > > > > > because of some permission issue but I am not sure what I am > missing. > > I have > > > > > oracle and oraclex both have "oinstall" as primary group and "dba" > as > > second > > > > > group. > > > > > > > > > > I googled but cannot find any useful information. Can anybody give > me > > > > > some suggestion? Any comment would be greatly appreciated! > > > > > > > > > > Thanks, > > > > > -Li > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > -- > Niall Litchfield > Oracle DBA > http://www.orawin.info > ------=_Part_42720_9014310.1197567413397 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Thanks Niall, I did set the ORA_CRS_HOME environment variable

On Dec 13, 2007 3:25 AM, Niall Litchfield <niall.litchfield@gmail.com> wrote:
We have a very similar setup - which i don't like by the way - I cant
look today but think you might need to set CRS_ORACLE_HOME in your
environment. I  concur about the logs by the way.

On 13/12/2007, Li Li <litanli@gmail.com> wrote:
> Hi, Dan,
>
> my OSASM group is "dba" also, I know this defeats some of the separation,
> but I just wanted to test this out. It's very strange to me that I have this
> issue because in my case both oracle and oraclex have "oinstall" as primary
> group and "dba" as second group, and oracle's RDBMS home and oraclex's RDBMS
> home all have 775 permission. I am trying to get some other eyes on this
> issue to see what I am missing :(
>
> Thank you all for your time to reply!
> -Li
>
> On Dec 12, 2007 7:20 PM, Dan Norris < dannorris@dannorris.com> wrote:
>
> > In my experiences with this, the oraclex user (the RDBMS owner) will have
> > to be in the OSASM group. This defeats some of the separation, but as I
> > understand it, the Oracle developers know that the separation isn't quite
> > complete yet and someone told me that we should expect "true" separation
> in
> > a future release (probably 11g R2). If your OSASM group is also dba, then
> > I'm not sure I know why you're having issues. I tried the same thing and
> had
> > three users: 1) a clusterware owner, 2) an ASM owner, and 3) an RDBMS
> owner.
> > I found that the clusterware can be separated pretty cleanly from the
> other
> > two, but the ASM and RDBMS owners essentially have power over each others'
> > domains since the RDBMS user must be in the OSASM group and I think the
> ASM
> > owner may have had to be in the OSDBA. I don't have access to my test
> > systems for this any longer, so my memory may be a little off. It's also
> > possible that things have changed slightly since my testing which was done
> > with 11gR1-beta5.
> >
> > Dan
> >
> >
> > ----- Original Message ----
> > From: Li Li <litanli@gmail.com>
> > To: William Wagman < wjwagman@ucdavis.edu>
> > Cc: finn.oracledba@gmail.com; oracle-l <oracle-l@freelists.org>
> > Sent: Wednesday, December 12, 2007 5:51:26 PM
> > Subject: Re: separate owner/ORACLE_HOME for crs, ASM, and database in RAC
> > environment
> >
> > Hi, Bill,
> >
> > I don't use asmlib because its dependency on linux kernel. I just create
> > ASM diskgroups using RAW devices. when I login as oracle and start dbca,
> ASM
> > disks are all look/work fine.
> >
> >
> > On Dec 12, 2007 5:14 PM, William Wagman < wjwagman@ucdavis.edu> wrote:
> >
> > >  Greetings,
> > >
> > > The thinking is to separate CRS, ASM and RDBMS for ease of maintenance.
> > > This is also the Oracle suggestion that each be in a separate home. It
> makes
> > > patching and upgrading easier.
> > >
> > > As to the disk issues. First are you using ASMLIB? Make sure if you are
> > > it is configured correctly and the disks have been created.
> > >
> > > Also look at the status of this disks as described in v$asm_disk. They
> > > status must be either provisioned or candidate. I have encountered this
> > > situation before where the status was unknown and that caused me
> problems.
> > >
> > > Also, are you using multipathing? If so make sure you have scanorder and
> > > scanexclude set correctly in the oracleasm file as that can affect
> things.
> > > There was a thread about this a while ago.
> > >
> > > I apologize for not being more specific but I still don't have a good
> > > enough understanding of how things work. A lot of what I have done is
> > > through trial and error and can give you things to look at but that's
> about
> > > it at this point.
> > >
> > >
> > > Bill Wagman
> > > Univ. of California at Davis
> > > IET Campus Data Center
> > > wjwagman@ucdavis.edu
> > > (530) 754-6208
> > >
> > >
> > >  *From:* oracle-l-bounce@freelists.org
> [mailto:oracle-l-bounce@freelists.org
> > > ] *On Behalf Of *Finn Jorgensen
> > > *Sent:* Wednesday, December 12, 2007 2:09 PM
> > > *To:* litanli@gmail.com
> > > *Cc:* oracle-l
> > > *Subject:* Re: separate owner/ORACLE_HOME for crs, ASM, and database in
> > > RAC environment
> > >
> > >   Before trying to figure this one out, I'm trying to wrap my brain
> > > around why you would do that. What's the thinking behind this setup?
> > >
> > > Finn
> > >
> > >
> > > On 12/12/07, Li Li <litanli@gmail.com> wrote:
> > > >
> > > > Hi, List,
> > > >
> > > > I am testing to setup a 2-node RAC environment with separate
> > > > owner/ORACLE_HOME for crs, ASM, and database, it's 10gR2 on Redhat AS
> 4.
> > > >
> > > > 2 users are created: oracle and oraclex, oracle owns clusterware home
> > > > and ASM home, oraclex owns database home.
> > > >
> > > > first, I login as oracle and installed clusterware and database
> > > > software (in 2 different oracle home of course), configured and
> started ASM
> > > > instance, everything worked fine.
> > > >
> > > > second, I login as oraclex and installed database software, then I
> > > > tried to create a database using dbca, but I ran into error when I
> chose ASM
> > > > as my database storage, the error is:
> > > > "DBCA could not startup the ASM instance configured on this node. To
> > > > proceed with database creation using ASM you need the ASM instance to
> be up
> > > > and running. Do you want to recreate the ASM instance on this node?"
> > > >
> > > > But the ASM instance IS already running. I am guessing this must be
> > > > because of some permission issue but I am not sure what I am missing.
> I have
> > > > oracle and oraclex both have "oinstall" as primary group and "dba" as
> second
> > > > group.
> > > >
> > > > I googled but cannot find any useful information. Can anybody give me
> > > > some suggestion? Any comment would be greatly appreciated!
> > > >
> > > > Thanks,
> > > > -Li
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>


--
Niall Litchfield
Oracle DBA
http://www.orawin.info

------=_Part_42720_9014310.1197567413397-- -- http://www.freelists.org/webpage/oracle-l