Solved

Oracle Grid & RAC install guides?

Posted on 2014-04-02
5
507 Views
Last Modified: 2014-04-22
I'm installing a 2-node Oracle 11g RAC cluster on Solaris, and I wanted to know if anyone had a simple "OFA" style guide to where everything should go?  As usual Oracle are overly complex in the way they document things, and find it impossible to distill information down to a "HowTo" guide.

My main concerns are:

1) Which users should own the clusterware?  Should it all be owned by "oracle:dba", or should the clusterware be owned by something like "grid:dba"?
2) Where should I put the cluster registry?
3) Where should I put the voting files?  (I'm using NetApp nfs filesystems)
0
Comment
Question by:Sophia Paterakis
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 16

Assisted Solution

by:Wasim Akram Shaik
Wasim Akram Shaik earned 200 total points
ID: 39973264
Hmm.. probably you don't want to go through a lot of documentation..

fine then.. refer to tim hall site, where in he had simpilified steps for rac installation for solaris

http://www.oracle-base.com/articles/11g/oracle-db-11gr2-installation-on-solaris-10.php
0
 
LVL 1

Author Comment

by:Sophia Paterakis
ID: 39973285
Hi wasimibm,

Thanks for the link, but that doesn't cover my burning question... should I install RAC clusterware as the "oracle" user, or create a new user just for that.  It seems redundant to me and makes life more difficult, but if there is a valid reason behind it I would love for someone to explain what that is.

This document on the same site doesn't even mention using anything other than the "oracle" user, so why does Oracle deliberately complicate the process?  This is Linux however, but I'm closer than I was 10 minutes ago:

http://www.oracle-base.com/articles/11g/oracle-db-11gr2-rac-installation-on-linux-using-nfs.php

If anyone has first-hand experience of RAC on Solaris, I'd love to hear from you.

Thanks.
Sophia.
0
 
LVL 23

Expert Comment

by:David
ID: 39973368
I'm familiar with a client who went with oracle / oinstall, root ownership on the directories, and DBAs excluded from the oinstall group.  This meets the US gov't DISA requirements.
0
 
LVL 8

Accepted Solution

by:
Pepe2323 earned 300 total points
ID: 39974078
Hi Install Oracle 11 rac there are many thing to checkout, so i pretty sure every documento you find will be a big one

I will try to answer you questions:

1) Which users should own the clusterware?  Should it all be owned by "oracle:dba", or
should the clusterware be owned by something like "grid:dba"?
Answer: oracle and the main group for oracle user in my case is oinstall but can be also dba

2) Where should I put the cluster registry?
Answer: OCR must be shared storage that all nodes of that cluster shall be able to see it , OCFS2 file system can be an option and ASM ( RAW is also an option but Oracle 11 does not suggest to do it)
3) Where should I put the voting files?  (I'm using NetApp nfs filesystems)
Answer: Voting file can be put on ocfs2 file system or ASM , it has to be a shared storage

i attached a document for Oracle RAC 11 best practice for Netapp

[REMOVED BY SOUTHMOD]

I hope this helps
0
 
LVL 1

Author Closing Comment

by:Sophia Paterakis
ID: 40009796
I ended up installing both Grid and Database software under the "oracle" account, as I couldn't see any conflict from doing this.  Aside from the oracle vs. oinstall argument, I didn't see any reason that someone would have permission to install the Grid software but not the Database software.

Also, using srvctl to start/stop everything made life difficult if I had to keep swapping from oracle to grid... then back to oracle to run sqlplus... then back to grid to stop the instance.  Putting it all under the one user makes life simple, as there is one user for maintenance of the Cluster and the Database.  It may not work in some highly-secure environments, but I've never had to use the oracle/oinstall differentiation either so for us it doesn't matter.

I also put my Oracle Cluster Registry (ocr) and Voting Files on:

/u02/ocr
/u03/ocr
/u04/ocr

I couldn't find any OFA style documentation on where to put them or what to name them, so I came up with a local standard that works for us.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

717 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question