Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 26567 invoked from network); 12 Dec 2007 18:38:23 -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; 12 Dec 2007 18:38:23 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 372AD7D7D43; Wed, 12 Dec 2007 19:38:24 -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 08952-06; Wed, 12 Dec 2007 19:38:24 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 929017D7CDD; Wed, 12 Dec 2007 19:38:23 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 12 Dec 2007 18:51:27 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5E07A7D82EF for ; Wed, 12 Dec 2007 18:51:27 -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 32442-09-4 for ; Wed, 12 Dec 2007 18:51:27 -0500 (EST) Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.181]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DC1F87D8269 for ; Wed, 12 Dec 2007 18:51:26 -0500 (EST) Received: by wa-out-1112.google.com with SMTP id k22so750429waf.18 for ; Wed, 12 Dec 2007 15:51:26 -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=9ije+KfPeaTsQ9pWhwHPAk4Y5rsrqXvXOqX6zpFlbTU=; b=KXWqfxa1XnuOABwgJOiD1R2CPGQu3f9I8DU74FP6usofSUSBrnbpMGx83X2Z8HGNdzr1ArNKx6FL9CRO5nAkQ5IQmzt+BMgD2O+XaeaPSJhQJmx5MSmR3cSkfTiPWM4AiBY4QRSmR/wDc9GkxKAS+uNaNCflYbc0lRqMfu+EuK4= 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=bcmIZpzYGvyQz3XhWUbXztV0ZJhQB9jXec9SNsTLphCZx5H3VCZYGlgpSa/d40mwWoA0Tgk6uXDHEjm6DWe3Z7kN+jQakKP9Zz9YmDbZyqwyRk0kCX+uJFDKOzdMpGZCofhQeoZNRgTNU32qXib/vSNITxWL2Y5sxZ/qNMbffnQ= Received: by 10.114.56.1 with SMTP id e1mr1429125waa.148.1197503486463; Wed, 12 Dec 2007 15:51:26 -0800 (PST) Received: by 10.114.124.9 with HTTP; Wed, 12 Dec 2007 15:51:26 -0800 (PST) Message-ID: <5f35c2320712121551w56ced217q92f77fe46b2e2453@mail.gmail.com> Date: Wed, 12 Dec 2007 17:51:26 -0600 From: "Li Li" To: "William Wagman" Subject: Re: separate owner/ORACLE_HOME for crs, ASM, and database in RAC environment Cc: finn.oracledba@gmail.com, oracle-l In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_37426_19484430.1197503486452" References: <74f79c6b0712121408g725831c1w12a7289ef7acc87@mail.gmail.com> X-archive-position: 3903 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_37426_19484430.1197503486452 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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_37426_19484430.1197503486452 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
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
 
 


------=_Part_37426_19484430.1197503486452-- -- http://www.freelists.org/webpage/oracle-l