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

[Ross Mohan < >]

Ari, 

Thanks. 

The storage orchestration you mention exemplifies the challenge. One allocates SAN space, and then feeds the disk discovery string back into the install flow. Jumping out to manually check and remediate error thrown from mis-configs is typical.

The overall flow we're seeing for now is:

• bare metal VM spin up
• provisioning
• OS pre-work (storage, networking, cluster prep)
• Grid Infrastructure/Cluster Ready Services (GI/CRS)
• OS post-checks and tweaks
• RDBMS/RAC install
• dbms schema & tools
• PSU patching

Some of these are pretty big buckets. But the automated/manual steps flow in and out of each step

Most of the 'easy' stuff looks like ".... ./runInstaller    <flags>......"

most of the unavoidably manual stuff is scanning logs to triage errors into ignore/resolve categories. 

Going forward, having recipes for for "add/remove a node" and "patching an existing cluster" will help contribute to elasticity needs. 

Thanks again for your work; it's really very much in the lead and a great service to those of us who are beginners!

-Ross

---

From: Ari Riikonen < >
Sent: Thursday, February 6, 2014 11:01 AM
To:
Subject: [chef] Re: RE: Re: Re: Re: Oracle Cookbook

 

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