RE: Configuration management / Puppet for Oracle DBA'ing

The base code is about deployment and config, but as you expand what you put under automation, it is about general operations to.  

The real part of automation and deployment is about repeatable task implementation and being able to perform against the whole fleet even at the same time.  

With puppet modules I have developed a standard RU/RUR from deployment of code to server to patch apply completion is 12 minutes. Now imagine patching your whole fleet in the same 12 minutes.

Automation is about being a force multiplier for you and insurance of fleet consistency.  

For full operational automation you have to start thinking in terms of SOPs. If you can write down the steps that need to be performed, you can automate the process.  

Matthew Parker

Chief Technologist

Dimensional DBA

Oracle Gold Partner

425-891-7934 (cell)

D&B 047931344

CAGE 7J5S7 Dimensional.dba_at_comcast.net <mailto:Dimensional.dba_at_comcast.net>

 <http://www.linkedin.com/pub/matthew-parker/6/51b/944/> View Matthew Parker's profile on LinkedIn

www.dimensionaldba.com <http://www.dimensionaldba.com/>    

From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> On Behalf Of Ethan Post Sent: Thursday, June 14, 2018 8:24 PM
To: cstephens16_at_gmail.com; 'Matthew Parker' <dimensional.dba_at_comcast.net> Cc: Jay.Miller_at_tdameritrade.com; sethmiller.sm_at_gmail.com; Oracle-L_at_freelists.org Subject: RE: Configuration management / Puppet for Oracle DBA'ing  

I took a quick look at the github repo, it looked like a lot of code/config. My question is will it still work in a year or two? If not are you ready to fix the supporting code in the repo?  

I have never worked in an environment where provisioning was a big issue and certainly not the bulk of workload. I feel like many of us are adopting a provisioning mindset because the folks designing tools like puppet, chef and ansible are heavy users of provisioning and higher ups are pushing “automation”. If provisioning was an issue I would probably just build out an image which can quickly be replicated or find some other solution which off the top of my head I can think of a few.  

Just my 2 cents. Been here for many years but like a bunch of you just lurk these days. No better list in the world IMHO.  

Thanks!

Ethan      

From: oracle-l-bounce_at_freelists.org <mailto:oracle-l-bounce_at_freelists.org> <oracle-l-bounce_at_freelists.org <mailto:oracle-l-bounce_at_freelists.org> > On Behalf Of Chris Stephens Sent: Tuesday, June 12, 2018 2:38 PM
To: Matthew Parker <dimensional.dba_at_comcast.net <mailto:dimensional.dba_at_comcast.net> > Cc: Jay.Miller_at_tdameritrade.com <mailto:Jay.Miller_at_tdameritrade.com> ; sethmiller.sm_at_gmail.com <mailto:sethmiller.sm_at_gmail.com> ; Oracle-L_at_freelists.org <mailto:Oracle-L_at_freelists.org> Subject: Re: Configuration management / Puppet for Oracle DBA'ing  

as appealing as ansible sounds (at least to investigate), i think i'll run with puppet for now since I'm new here and it's what everyone uses. thanks for all the input!

--
http://www.freelists.org/webpage/oracle-l