Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 24262 invoked from network); 13 Dec 2007 12:26:04 -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:26:04 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id BB2CB7D8B26; Thu, 13 Dec 2007 13:26:04 -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 28798-06; Thu, 13 Dec 2007 13:26:04 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 331BB7D84B6; Thu, 13 Dec 2007 13:26:04 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 13 Dec 2007 12:39:08 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1116D7D8C7E for ; Thu, 13 Dec 2007 12:39:08 -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 22715-01 for ; Thu, 13 Dec 2007 12:39:07 -0500 (EST) Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.177]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5A5A67D8C31 for ; Thu, 13 Dec 2007 12:39:07 -0500 (EST) Received: by wa-out-1112.google.com with SMTP id k22so1294125waf.18 for ; Thu, 13 Dec 2007 09:39:06 -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=gHYmSPsoMh7t0SCkP92VBrfD3apjUbvAQSGH6drDtOM=; b=j6+TNR/esKCBI78+kzHg+ENPRpYtlv/wjllb2/OcHIuJdJFcrlopDu3XQt26dqmdheSmrNTE5jUn2lZAhbNiAc2l5+xg4TJx65g+7npXziZyeSBz9qTC/umhZFiQl2QpMu4mH4o4u0b/Q0Bom3HBT3d/plu2aTYGrZ1V7n6WM80= 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=AbBZh7mnwqk5XwT+Ciy9oTZtkYGqFIuuxiPqWWRUH/UKoWHxRTioHZO2nNCxKsVmatGYPTMz58XsTUyb04CfjA0/4juHWVC2meHJTw3cpAFSEJ78ODJfMX9DXTOSzPkaR+1bhgxdlnzjIJYZnRyJ41yv9UQcT1XfkcXuMMvdhJE= Received: by 10.114.209.1 with SMTP id h1mr2526605wag.115.1197567546270; Thu, 13 Dec 2007 09:39:06 -0800 (PST) Received: by 10.114.154.3 with HTTP; Thu, 13 Dec 2007 09:39:06 -0800 (PST) Message-ID: <5f35c2320712130939x453e98acje9b85ad118913538@mail.gmail.com> Date: Thu, 13 Dec 2007 11:39:06 -0600 From: "Li Li" To: "Dan Norris" Subject: Re: separate owner/ORACLE_HOME for crs, ASM, and database in RAC environment Cc: "William Wagman" , finn.oracledba@gmail.com, oracle-l In-Reply-To: <115017.6959.qm@web35413.mail.mud.yahoo.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_42740_561485.1197567546258" References: <115017.6959.qm@web35413.mail.mud.yahoo.com> X-archive-position: 3930 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_42740_561485.1197567546258 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Thanks Dan! You suggested the same thing that Rajeev did. Please see my reply to Rajeev. I'll try your other suggestions as well later. On Dec 12, 2007 9:12 PM, Dan Norris wrote: > Hi Li, > > If you haven't already, I'd check the ASM instance logs, the DBCA trace > output (I don't remember how, but there's an env var or a mod to the dbca > start script that enables DBCA tracing), or the listener log to determine > how far your DBCA is getting the process before failing. > > I'd also probably try creating an instance by hand (without DBCA) to see > if it's a DBCA issue or a core RDBMS/ASM issue. > > One of those locations is bound to yield some useful log information to > get you closer to finding the root cause of the issue. For the record, I'm > not guessing...the issue going to be shown in one of those places for sure. > I'm a card-carrying BAAG member ;). > > Until you responded, I was hoping that you used a different OSASM group > and that would be your issue. Hopes dashed...:( > > Dan > > P.S. I don't know how Oracle Support does it--solving issues with no > access to see the issue and having to ask 1000's of questions to get the > info they need. I still think they could do better, but it's threads like > this one that remind me why I don't do phone support! > > ----- Original Message ---- > From: Li Li > To: Dan Norris > Cc: William Wagman ; finn.oracledba@gmail.com; > oracle-l > Sent: Wednesday, December 12, 2007 8:50:42 PM > Subject: Re: separate owner/ORACLE_HOME for crs, ASM, and database in RAC > environment > > 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 < litanli@gmail.com> > > 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 > > > > > > > > > > > > > > > > > > > > > > > > ------=_Part_42740_561485.1197567546258 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Thanks Dan! You suggested the same thing that Rajeev did. Please see my rep= ly to Rajeev. I'll try your other suggestions as well later.

On Dec 12, 2007 9:12 PM, Dan Norris <dannorris@dannorris.com> wrote:<= br>
Hi = Li,

If you haven't already, I'd check the ASM instance logs,= the DBCA trace output (I don't remember how, but there's an env va= r or a mod to the dbca start script that enables DBCA tracing), or the list= ener log to determine how far your DBCA is getting the process before faili= ng.=20

I'd also probably try creating an instance by hand (without DBC= A) to see if it's a DBCA issue or a core RDBMS/ASM issue.

One o= f those locations is bound to yield some useful log information to get you = closer to finding the root cause of the issue. For the record, I'm not = guessing...the issue going to be shown in one of those places for sure. I&#= 39;m a card-carrying BAAG member ;).

Until you responded, I was hoping that you used a different OSASM g= roup and that would be your issue. Hopes dashed...:(

Dan

P.S. I don't know how Oracle Support does i= t--solving issues with no access to see the issue and having to ask 1000= 9;s of questions to get the info they need. I still think they could do bet= ter, but it's threads like this one that remind me why I don't do p= hone support!

----- Original Message ----
From: Li Li <litanli@gmail.com><= br>To: Dan Norris < dannorris@dannorris.com>
Cc: William Wagman <wjwagman@ucdavis.edu>; finn.oracledba@gm= ail.com ; oracle-l <oracle-l@freelists.org>
Sent: Wednesday, December 12, 2007 8:= 50:42 PM
Subject: Re: separate owner/ORACLE_HOME for crs, ASM, and datab= ase in RAC environment

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 t= o see what I am missing :(=20

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 RD= BMS owner) will have to be in the OSASM group. This defeats some of the sep= aration, but as I understand it, the Oracle developers know that the separa= tion 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 havin= g issues. I tried the same thing and had three users: 1) a clusterware owne= r, 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 owne= rs essentially have power over each others' domains since the RDBMS use= r must be in the OSASM group and I think the ASM owner may have had to be i= n 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.=20

Dan


----- Original Message ----
From: Li Li < litanli@= gmail.com>
To: William Wagman < wjwagman@ucdavis.edu>
Cc: finn.oracledba@gmail.com ; orac= le-l < oracle-l@freelists.org>
Sent: Wednesday, December 12, 2007 5:51:2= 6 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 d= bca, ASM disks are all look/work fine.

 
On Dec 12, 2007 5:14 PM, William Wagman <wjwagma= n@ucdavis.edu> wrote:
Greetings,
 
The thinking is to separate CRS, ASM and RDBMS for ease of mai= ntenance. This is also the Oracle suggestion that each be in a separate hom= e. It makes patching and upgrading easier.=20
 
As to the disk issues. First are you using ASMLIB? Make sure i= f 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_di= sk. They status must be either provisioned or candidate. I have encountered= this situation before where the status was unknown and that caused me prob= lems.=20
 
Also, are you using multipathing? If so make sure you have sca= norder and scanexclude set correctly in the oracleasm file as that can affe= ct things. There was a thread about this a while ago.=20
 
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 d= one is through trial and error and can give you things to look at but that&= #39;s about it at this point.=20
 

Bill Wagman
Univ. of California at Davis
IET Camp= us Data Center
wjwagman@ucdavis.edu
(530) 754-6208

 

= From: oracle-l-bounce@freelists.org [mailto: o= racle-l-bounce@freelists.org=20 ] On Behalf Of Finn Jorgensen
Sent: Wednesday, Decembe= r 12, 2007 2:09 PM
To: litanli@gmail.com
Cc: oracle-l<= br> Subject: Re: separate owner/ORACLE_HOME for crs, ASM, and database i= n 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:=20
Hi, List,
 
I am testing to setup a 2-node RAC environment with separate owner/ORA= CLE_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 softwa= re (in 2 different oracle home of course), configured and started ASM insta= nce, everything worked fine.
 
second, I login as oraclex and installed database software, then I tri= ed to create a database using dbca, but I ran into error when I chose ASM a= s 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 b= e up and running. Do you want to recreate the ASM instance on this node?&qu= ot;=20
 
But the ASM instance IS already running. I am guessing this must be be= cause 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 &quo= t;dba" as second group.=20
 
I googled but cannot find any useful information. Can anybody give me = some suggestion? Any comment would be greatly appreciated!
 
Thanks,
-Li
 
 






------=_Part_42740_561485.1197567546258-- -- http://www.freelists.org/webpage/oracle-l