Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: separate owner/ORACLE_HOME for crs, ASM, and database in RAC environment

Re: separate owner/ORACLE_HOME for crs, ASM, and database in RAC environment

From: Li Li <litanli_at_gmail.com>
Date: Wed, 12 Dec 2007 17:44:35 -0600
Message-ID: <5f35c2320712121544x2a78dc3aode37f0d6eca3cb5c@mail.gmail.com>


unfornately nope.

On Dec 12, 2007 5:13 PM, Ghassan Salem <salem.ghassan_at_gmail.com> wrote:

> I suppose they are in the same group?
> when logged in as oraclex, can you connect to the asm instance (via
> sqlplus)?
>
>
> On Dec 12, 2007 11:19 PM, Li Li < litanli_at_gmail.com> wrote:
>
> > it does allow oraclex to write to them...
> >
> >
> > On Dec 12, 2007 4:13 PM, Finn Jorgensen <finn.oracledba_at_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_at_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_at_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_at_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
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > > >
> > > >
> > >
> >
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Dec 12 2007 - 17:44:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US