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

  • From: Dan Norris <dannorris@xxxxxxxxxxxxx>
  • To: litanli@xxxxxxxxx, William Wagman <wjwagman@xxxxxxxxxxx>
  • Date: Wed, 12 Dec 2007 17:20:53 -0800 (PST)

In my experiences with this, the oraclex user (the RDBMS owner) will have to be 
in the OSASM group. This defeats some of the separation, but as I understand 
it, the Oracle developers know that the separation isn't quite complete yet and 
someone told me that we should expect "true" separation in a future release 
(probably 11g R2). If your OSASM group is also dba, then I'm not sure I know 
why you're having issues. I tried the same thing and had three users: 1) a 
clusterware owner, 2) an ASM owner, and 3) an RDBMS owner. I found that the 
clusterware can be separated pretty cleanly from the other two, but the ASM and 
RDBMS owners essentially have power over each others' domains since the RDBMS 
user must be in the OSASM group and I think the ASM owner may have had to be in 
the OSDBA. I don't have access to my test systems for this any longer, so my 
memory may be a little off. It's also possible that things have changed 
slightly since my testing which was done
 with 11gR1-beta5.

Dan

----- Original Message ----
From: Li Li <litanli@xxxxxxxxx>
To: William Wagman <wjwagman@xxxxxxxxxxx>
Cc: finn.oracledba@xxxxxxxxx; oracle-l <oracle-l@xxxxxxxxxxxxx>
Sent: Wednesday, December 12, 2007 5:51:26 PM
Subject: Re: separate owner/ORACLE_HOME for crs, ASM, and database in RAC 
environment


Hi, Bill,

 

I don't use asmlib because its dependency on linux kernel. I just create ASM 
diskgroups using RAW devices. when I login as oracle and start dbca, ASM disks 
are all look/work fine.


 

On Dec 12, 2007 5:14 PM, William Wagman <wjwagman@xxxxxxxxxxx> wrote:



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