[chef] Re: RE: Re: Re: Re: Oracle Cookbook

[Ari Riikonen < >]

Ross,

I haven't found any cookbooks publicly available, which setup an Oracle RAC from ground to up. Not yet at least. As you mentioned, there are some tasks for setting up a RAC, that are not easy to orchestrate. Depends heavily on the storage configuration, especially, if you have bare metal at the lower level and how are you configuring the shared disks (Cluster filesystem or ASM).

Hopefully I have the time to develop the echa-oracle cookbook to handle single Grid Infrastructure installation and ASM disks. This is sort of a base to move forward to RAC.

Br, Ari

http://http://oraarir.blogspot.fi/

On Thu, Feb 6, 2014 at 3:42 PM, Ross Mohan < " target="_blank"> > wrote:

Ari and Esteemed Others, 

Thanks much for this resource. For Chef newbies ("busboys"? "dishwashers"?) this is a very valuable resource to have. 

Are you aware of anyone automating an Oracle RAC install? (for others who may not know, RAC is the clustered version of oracle, and the install complexity is an order of magnitude higher, requiring significant OS, storage and networking coordination.)

What I am finding -- and I would love to be dead wrong about this -- is that the install unavoidably involves manual steps spread throughout. So any Chef automation becomes 'stop/start', where one must stop to manually do a check, run another script, etc. 

My question:  Are you aware of anyone working on a full-up Chef Oracle RAC install? I'd like to see one A to Z, all the way from VM provisioning off bare machine to working clustered database, but would welcome learning about folks working on partial solutions (besides myself.)

Thanks,

Ross

---

From: Ari Riikonen < " target="_blank"> >
Sent: Thursday, February 6, 2014 3:41 AM
To: " target="_blank">
Subject: [chef] Re: Re: Re: Oracle Cookbook

 

Hi Anju,

Have you looked at the bash, execute and script resources in chef?

All of these have the 'user' and 'group' attributes among plenty of other useful ones like 'cwd'. With these you can say under which user and group the resources should be executed.

bash

http://docs.opscode.com/chef/resources.html#bash

execute

http://docs.opscode.com/chef/resources.html#execute

script

http://docs.opscode.com/chef/resources.html#script

Br, Ari

On Thu, Feb 6, 2014 at 10:32 AM, Anju M R < " target="_blank"> > wrote:

Thank you  Ari

I went through it, but my doubt is

If I have a node, say test-db. I bootstrapped to the machine as 'root'. Is it
possible to execute the install commands as 'oracle' which is another user?  I
did few trials but it failed.

--
- Ari