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

  • From: "William Wagman" <wjwagman@xxxxxxxxxxx>
  • To: <finn.oracledba@xxxxxxxxx>, <litanli@xxxxxxxxx>
  • Date: Wed, 12 Dec 2007 15:14:31 -0800

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@xxxxxxxxxxx
(530) 754-6208 

 

________________________________

From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Finn Jorgensen
Sent: Wednesday, December 12, 2007 2:09 PM
To: litanli@xxxxxxxxx
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@xxxxxxxxx> 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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 12-2007