Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 22786 invoked from network); 12 Dec 2007 18:10:29 -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:10:29 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 24AF57D841E; Wed, 12 Dec 2007 19:10:30 -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 03656-03; Wed, 12 Dec 2007 19:10:30 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9192E7D82F9; Wed, 12 Dec 2007 19:10:29 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 12 Dec 2007 18:23:33 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7B0AD7D7C19 for ; Wed, 12 Dec 2007 18:23:01 -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 26442-06 for ; Wed, 12 Dec 2007 18:23:01 -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 F0A097D7BCD for ; Wed, 12 Dec 2007 18:23:00 -0500 (EST) Received: by wa-out-1112.google.com with SMTP id k22so737565waf.18 for ; Wed, 12 Dec 2007 15:23:00 -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:in-reply-to:mime-version:content-type:references; bh=2OH/Md/HInQ2mwKDuvAvu0SuOL8Dyzsf0AHWUlST+7g=; b=ViFF6HGYoppykoEsFBzkpEfVt5Li/TCT875viIeQJRZd8rDnIdVBZkIMteV25pFaad/7LiSjPPEKT4BNcofKGvK8uayJmwbauKvrsr1cnqQA9zfcBm7p+t8qwi3NpqI02JjzukW/uLjwhmUaViO+OkvnLyiAINyJ5yLKFINHfsk= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=oJsn6yakXtxkqLIjCXBeeL+x8HjZzGA8+/rYvrc7YRiNZFvC/a14OOTpUlhoJE9CW3+imfCPKey+4YOpfc1SX6YskN/e47VLx4xt11YjtjNYWTnjkkamFGrOFH0nsEu+5QVcWMy+ZNir5XzPJ+Kx3YaNQvEhmA4zyx9XJcnvpmE= Received: by 10.114.199.1 with SMTP id w1mr1445998waf.38.1197501780041; Wed, 12 Dec 2007 15:23:00 -0800 (PST) Received: by 10.114.124.9 with HTTP; Wed, 12 Dec 2007 15:22:59 -0800 (PST) Message-ID: <5f35c2320712121522scc70b03y208f46e55e496fcb@mail.gmail.com> Date: Wed, 12 Dec 2007 17:22:59 -0600 From: "Li Li" To: oracle-l Subject: Re: separate owner/ORACLE_HOME for crs, ASM, and database in RAC environment In-Reply-To: <20071213095842718.00000003112@PETE> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_37368_22330602.1197501780025" References: <5f35c2320712121351t319a3662ie7bc03d83ffcbf4b@mail.gmail.com> <20071213095842718.00000003112@PETE> X-archive-position: 3900 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_37368_22330602.1197501780025 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi Pete, Start dbca as oracle showed ASM works fine, but start dbca as oraclex (in a different oracle home) cannot see the ASM instance. like I said, the reason to have separate owner is to separate the responsibilities, and I think this is oracle's direction too, as in 11g, there's a new privilege "sysasm". On Dec 12, 2007 4:58 PM, Pete Sharman wrote: > Li Li > > > > If you want to check this is a permissions thing, probably the easiest way > is to start DBCA as oracle, not oraclex. > > > > One thing you didn't mention directly is WHICH dbca you were using. Is it > the one in ASM home or the database home? > > > > Personally, I'm yet to be convinced that there really is a valid reason > for having two separate user ID's for this sort of configuration. It's an > argument I've seen used many times and I really think it only causes grief > somewhere along the line. Separate ORACLE_HOMES I can see as sensible, but > still not convinced about separate user ID's owning them. > > > > Pete > > > > "Controlling developers is like herding cats." > > Kevin Loney, Oracle DBA Handbook > > > > "Oh no, it's not, it's much harder than that!" > > Bruce Pihlamae, long term Oracle DBA > ------------------------------ > > *From:* oracle-l-bounce@freelists.org [mailto: > oracle-l-bounce@freelists.org] *On Behalf Of *Li Li > *Sent:* Thursday, 13 December 2007 8:52 AM > *To:* oracle-l > *Subject:* separate owner/ORACLE_HOME for crs, ASM, and database in RAC > environment > > > > 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_37368_22330602.1197501780025 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi Pete,
 
Start dbca as oracle showed ASM works fine, but start dbca as oraclex (in a different oracle home) cannot see the ASM instance.
 
like I said, the reason to have separate owner is to separate the responsibilities, and I think this is oracle's direction too, as in 11g, there's a new privilege "sysasm".

On Dec 12, 2007 4:58 PM, Pete Sharman <peter.sharman@oracle.com> wrote:

Li Li

 

If you want to check this is a permissions thing, probably the easiest way is to start DBCA as oracle, not oraclex.

 

One thing you didn't mention directly is WHICH dbca you were using.  Is it the one in ASM home or the database home?

 

Personally, I'm yet to be convinced that there really is a valid reason for having two separate user ID's for this sort of configuration.  It's an argument I've seen used many times and I really think it only causes grief somewhere along the line.  Separate ORACLE_HOMES I can see as sensible, but still not convinced about separate user ID's owning them.

 

Pete

 

"Controlling developers is like herding cats."

Kevin Loney, Oracle DBA Handbook

 

"Oh no, it's not, it's much harder than that!"

Bruce Pihlamae, long term Oracle DBA

From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Li Li
Sent: Thursday, 13 December 2007 8:52 AM
To: oracle-l
Subject: separate owner/ORACLE_HOME for crs, ASM, and database in RAC environment

 

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_37368_22330602.1197501780025-- -- http://www.freelists.org/webpage/oracle-l