Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 15936 invoked from network); 12 Dec 2007 17:00:57 -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:00:57 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E736F7D85DA; Wed, 12 Dec 2007 18:00:57 -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 22344-02; Wed, 12 Dec 2007 18:00:57 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 605EA7D8711; Wed, 12 Dec 2007 18:00:57 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 12 Dec 2007 17:14:00 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4B10C7D86E8 for ; Wed, 12 Dec 2007 17:14:00 -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 11504-01 for ; Wed, 12 Dec 2007 17:14:00 -0500 (EST) Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.181]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id DD50D7D86DE for ; Wed, 12 Dec 2007 17:13:59 -0500 (EST) Received: by py-out-1112.google.com with SMTP id u77so1085570pyb.3 for ; Wed, 12 Dec 2007 14:13:59 -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=igPS2ErVzCWG3z0fNWWT5U1a02iLm6TIr7vbX3l6Mrs=; b=Pc7HQ7Sz9XDy/FI1FT8bpvlCpceyFxtbsv3ATTL0eh/eFLCnLeo0b1D2v6p8D9dNCJV8rgSEtFsH4Dn8gV0PUPUZzzRikn2y2F2o4iZOIL782UeDzdZWR/Ip+tWUlgiuEDT22ypGCfbwBlTQ7yBDsXW9A/YjkGbp+XdRX56h4Ac= 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=gOdFVMYfa9MsqMXm8985SqtgEm0yPMWqcDpP2o4xVyTeh+wquUZWioOY31DVRoudhtbHHkVNvhx959nLrfHyadnwua4hrsMtfVgWQsOyZ1tYr0TwBoWnU4sosjy1q+MZ8ytkyH7PRV/XLl+X7zaVC3/uRPoyRkXMtYKvWo3+srA= Received: by 10.35.60.15 with SMTP id n15mr1346198pyk.33.1197497639321; Wed, 12 Dec 2007 14:13:59 -0800 (PST) Received: by 10.35.119.5 with HTTP; Wed, 12 Dec 2007 14:13:59 -0800 (PST) Message-ID: <74f79c6b0712121413q1f170d32sdcfaefde87969f16@mail.gmail.com> Date: Wed, 12 Dec 2007 17:13:59 -0500 From: "Finn Jorgensen" To: "Li Li" Subject: Re: separate owner/ORACLE_HOME for crs, ASM, and database in RAC environment Cc: oracle-l In-Reply-To: <5f35c2320712121411s25674885i9ab385864233c5d8@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_6877_16707286.1197497639265" References: <5f35c2320712121351t319a3662ie7bc03d83ffcbf4b@mail.gmail.com> <74f79c6b0712121408g725831c1w12a7289ef7acc87@mail.gmail.com> <5f35c2320712121411s25674885i9ab385864233c5d8@mail.gmail.com> X-archive-position: 3894 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: finn.oracledba@gmail.com Precedence: normal Reply-to: finn.oracledba@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_6877_16707286.1197497639265 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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_6877_16707286.1197497639265 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
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_6877_16707286.1197497639265-- -- http://www.freelists.org/webpage/oracle-l