Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 16606 invoked from network); 12 Dec 2007 17:06:07 -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 17:06:06 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 568647D8764; Wed, 12 Dec 2007 18:06:07 -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 23133-05; Wed, 12 Dec 2007 18:06:07 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C208B7D80CF; Wed, 12 Dec 2007 18:06:06 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 12 Dec 2007 17:19:10 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CB1467D7A7C for ; Wed, 12 Dec 2007 17:19:09 -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 12685-03 for ; Wed, 12 Dec 2007 17:19:09 -0500 (EST) Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.183]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 063A97D7A9E for ; Wed, 12 Dec 2007 17:19:08 -0500 (EST) Received: by wa-out-1112.google.com with SMTP id k22so706412waf.18 for ; Wed, 12 Dec 2007 14:19:07 -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=V5W6pvTZa/5xI7q81Df84C0Z6jc3AboU99QjkYAIp+8=; b=Zh4A3ADHzh/U/nvvhyK2z5xP0kRSL7UULebQtQnHja7vHxL3q2tccO51FxC1owQ9hWlkjIDrzv0haHZqc6x8oyTjP5dzlq6d1EljQ8sL57NriVO0IXbzLXZNnqgt3tNcaw8LCttcB3RMJffjTnoqEucEwkKLGrDFRw5YKdhuGqk= 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=YDGT1/7cU8Eiq6eD4cto78C61i7HR3Msl0Hy99KaJmvJ4y+HEPmvHTVkHeZ4AvBulnYnSFcj5v+zO8a2I+xltJsZecgeW+uH1Ae3zR53b6jJoplWfIZkEHcjg0gOk1RWePh6h+4tdpb6HW20G0UyjPfvXOhz5GG3nFs4cJQFkSg= Received: by 10.114.181.1 with SMTP id d1mr1390920waf.10.1197497947510; Wed, 12 Dec 2007 14:19:07 -0800 (PST) Received: by 10.114.124.9 with HTTP; Wed, 12 Dec 2007 14:19:07 -0800 (PST) Message-ID: <5f35c2320712121419n2ba1fa9rc7ccf23c6f536930@mail.gmail.com> Date: Wed, 12 Dec 2007 16:19:07 -0600 From: "Li Li" To: "Finn Jorgensen" Subject: Re: separate owner/ORACLE_HOME for crs, ASM, and database in RAC environment Cc: oracle-l In-Reply-To: <74f79c6b0712121413q1f170d32sdcfaefde87969f16@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_37102_9926644.1197497947508" References: <5f35c2320712121351t319a3662ie7bc03d83ffcbf4b@mail.gmail.com> <74f79c6b0712121408g725831c1w12a7289ef7acc87@mail.gmail.com> <5f35c2320712121411s25674885i9ab385864233c5d8@mail.gmail.com> <74f79c6b0712121413q1f170d32sdcfaefde87969f16@mail.gmail.com> X-archive-position: 3895 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_37102_9926644.1197497947508 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline it does allow oraclex to write to them... On Dec 12, 2007 4:13 PM, Finn Jorgensen wrote: > I'm shooting a little blind here, but my first guess would be that the > permissions on the raw devices used for ASM does not allow the oraclex owner > to write to them? > > Finn > > > On 12/12/07, Li Li wrote: > > > > the thinking is to seperate the responsibilities of the DBAs and ASM/CRS > > admins. I'd like to hear any comments on this :) > > > > On Dec 12, 2007 4:08 PM, Finn Jorgensen > > wrote: > > > > > 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_37102_9926644.1197497947508 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline it does allow oraclex to write to them...

On Dec 12, 2007 4:13 PM, Finn Jorgensen <finn.oracledba@gmail.com> wrote:
I'm shooting a little blind here, but my first guess would be that the permissions on the raw devices used for ASM does not allow the oraclex owner to write to them?
 
Finn

 
On 12/12/07, Li Li <litanli@gmail.com> wrote:
the thinking is to seperate the responsibilities of the DBAs and ASM/CRS admins. I'd like to hear any comments on this :)


On Dec 12, 2007 4:08 PM, Finn Jorgensen <finn.oracledba@gmail.com> wrote:
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_37102_9926644.1197497947508-- -- http://www.freelists.org/webpage/oracle-l