Sounds like your other team really didn’t understand Oracle or puppet either
very well.
Automated delivery of Oracle is doable with either tool but they both take some
work.
Matthew Parker
Chief Technologist
Dimensional DBA
Oracle Gold Partner
425-891-7934 (cell)
D&B 047931344
CAGE 7J5S7
Dimensional.dba@xxxxxxxxxxx <mailto:Dimensional.dba@xxxxxxxxxxx>
<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@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> On Behalf
Of Jay.Miller@xxxxxxxxxxxxxxxx
Sent: Tuesday, June 12, 2018 11:51 AM
To: dimensional.dba@xxxxxxxxxxx; cstephens16@xxxxxxxxx
Cc: sethmiller.sm@xxxxxxxxx; Oracle-L@xxxxxxxxxxxxx
Subject: RE: Configuration management / Puppet for Oracle DBA'ing
Unfortunately I don’t really know how they set up the puppet installs. That was
a different department though one of our DBAs worked with them on the initial
setup. I would just get the box handed over to me and spend a while figuring
out whether everything was present and, if not, at what point it failed. No
consistency in where it failed either.
Jay Miller
Sr. Oracle DBA
201.369.8355
From: Matthew Parker [mailto:dimensional.dba@xxxxxxxxxxx] ;
Sent: Tuesday, June 12, 2018 11:20 AM
To: 'Chris Stephens'
Cc: sethmiller.sm@xxxxxxxxx <mailto:sethmiller.sm@xxxxxxxxx> ; Miller, Jay;
'Oracle-L Freelists'
Subject: RE: Configuration management / Puppet for Oracle DBA'ing
Yes we use Biemond’s oradb module as a base and have extended with a matching
custom module to use the building block components within the oradb module.
Deep end of the pool, is the simply complexity of the Oracle Patching
methodology especially the newer RU/RUR and rollback methods. You are dependent
upon testing the Oracle tools which fail for a variety of reasons on their own
because someone did something to the environment. Once you are under automation
control then life becomes easier as long as everyone is working together. The
testing and bringing your environment under control is what makes puppet not
fail.
Matthew Parker
Chief Technologist
Dimensional DBA
Oracle Gold Partner
425-891-7934 (cell)
D&B 047931344
CAGE 7J5S7
Dimensional.dba@xxxxxxxxxxx <mailto:Dimensional.dba@xxxxxxxxxxx>
<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.linkedin.com_pub_matthew-2Dparker_6_51b_944_&d=DwMFaQ&c=nulvIAQnC0yOOjC0e0NVa8TOcyq9jNhjZ156R-JJU10&r=aiKV3Uv2Wo7GqYQcis9TSvB1MZslPOnintrOY1rjG58&m=QI_PYA1UK4QS87wTHgrpN5McJQXcPn1Tnu1VNlvF5HE&s=BvMxIYFTtCW0SBUDBJhpZBkXUwjVriUbSWpDLHgWta4&e=>
View Matthew Parker's profile on LinkedIn
www.dimensionaldba.com
<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.dimensionaldba.com_&d=DwMFaQ&c=nulvIAQnC0yOOjC0e0NVa8TOcyq9jNhjZ156R-JJU10&r=aiKV3Uv2Wo7GqYQcis9TSvB1MZslPOnintrOY1rjG58&m=QI_PYA1UK4QS87wTHgrpN5McJQXcPn1Tnu1VNlvF5HE&s=BnrV7wOhE18dOseXyLxGPVvj-lfZerrFSDl8yDSdkbA&e=>
From: Chris Stephens <cstephens16@xxxxxxxxx <mailto:cstephens16@xxxxxxxxx> >
Sent: Tuesday, June 12, 2018 8:05 AM
To: Matthew Parker <dimensional.dba@xxxxxxxxxxx
<mailto:dimensional.dba@xxxxxxxxxxx> >
Cc: sethmiller.sm@xxxxxxxxx <mailto:sethmiller.sm@xxxxxxxxx> ;
Jay.Miller@xxxxxxxxxxxxxxxx <mailto:Jay.Miller@xxxxxxxxxxxxxxxx> ; Oracle-L
Freelists <Oracle-L@xxxxxxxxxxxxx <mailto:Oracle-L@xxxxxxxxxxxxx> >
Subject: Re: Configuration management / Puppet for Oracle DBA'ing
care to expand on "deep end of the pool"?
do you use custom modules or the one i linked to in original post or another
module?
On Tue, Jun 12, 2018 at 9:52 AM Matthew Parker <dimensional.dba@xxxxxxxxxxx
<mailto:dimensional.dba@xxxxxxxxxxx> > wrote:
I do puppet coding for a variety of clients for delivery of Oracle products.
We have had none of the failures in delivering Oracle with puppet that Jay
spoke of.
Both Puppet and Ansible are viable tools for delivering Oracle. However you
deliver Oracle for all possibilities you are stepping int othe deep end of the
pool, not because of the tools, but because of Oracle itself.
Matthew Parker
Chief Technologist
Dimensional DBA
Oracle Gold Partner
425-891-7934 <tel:(425)%20891-7934> (cell)
D&B 047931344
CAGE 7J5S7
Dimensional.dba@xxxxxxxxxxx <mailto:Dimensional.dba@xxxxxxxxxxx>
<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.linkedin.com_pub_matthew-2Dparker_6_51b_944_&d=DwMFaQ&c=nulvIAQnC0yOOjC0e0NVa8TOcyq9jNhjZ156R-JJU10&r=aiKV3Uv2Wo7GqYQcis9TSvB1MZslPOnintrOY1rjG58&m=QI_PYA1UK4QS87wTHgrpN5McJQXcPn1Tnu1VNlvF5HE&s=BvMxIYFTtCW0SBUDBJhpZBkXUwjVriUbSWpDLHgWta4&e=>
View Matthew Parker's profile on LinkedIn
www.dimensionaldba.com
<https://urldefense.proofpoint.com/v2/url?u=http-3A__www.dimensionaldba.com_&d=DwMFaQ&c=nulvIAQnC0yOOjC0e0NVa8TOcyq9jNhjZ156R-JJU10&r=aiKV3Uv2Wo7GqYQcis9TSvB1MZslPOnintrOY1rjG58&m=QI_PYA1UK4QS87wTHgrpN5McJQXcPn1Tnu1VNlvF5HE&s=BnrV7wOhE18dOseXyLxGPVvj-lfZerrFSDl8yDSdkbA&e=>
From: oracle-l-bounce@xxxxxxxxxxxxx <mailto:oracle-l-bounce@xxxxxxxxxxxxx>
<oracle-l-bounce@xxxxxxxxxxxxx <mailto:oracle-l-bounce@xxxxxxxxxxxxx> > On
Behalf Of Seth Miller
Sent: Tuesday, June 12, 2018 7:36 AM
To: Chris Stephens <cstephens16@xxxxxxxxx <mailto:cstephens16@xxxxxxxxx> >
Cc: Jay.Miller@xxxxxxxxxxxxxxxx <mailto:Jay.Miller@xxxxxxxxxxxxxxxx> ; Oracle-L
Freelists <Oracle-L@xxxxxxxxxxxxx <mailto:Oracle-L@xxxxxxxxxxxxx> >
Subject: Re: Configuration management / Puppet for Oracle DBA'ing
I'm a big fan of Ansible. I've used it on many projects Oracle related. It is
very extensible and fairly easy to pick up, and since the Red Hat acquisition,
it's feature development has really taken off. Take a look at Ansible Tower to
see what I mean.
Seth
On Tue, Jun 12, 2018 at 8:51 AM Chris Stephens <cstephens16@xxxxxxxxx
<mailto:cstephens16@xxxxxxxxx> > wrote:
that's interesting. thanks for input.
On Tue, Jun 12, 2018 at 8:49 AM <Jay.Miller@xxxxxxxxxxxxxxxx
<mailto:Jay.Miller@xxxxxxxxxxxxxxxx> > wrote:
We’re abandoning Puppet for our database installs and patching and are
currently investigating Ansible. We generally had about a 25% failure rate with
our database installs running the exact same process each time.
It might be that the people in charge of Puppet here just weren’t good enough
at it but we ended up doing a lot of manual installs after Puppet failures. It
seems to work well for most non-database related tasks.
Jay Miller
Sr. Oracle DBA
201.369.8355 <tel:(201)%20369-8355>
From: oracle-l-bounce@xxxxxxxxxxxxx <mailto:oracle-l-bounce@xxxxxxxxxxxxx>
[mailto:oracle-l-bounce@xxxxxxxxxxxxx ;<mailto:oracle-l-bounce@xxxxxxxxxxxxx> ]
On Behalf Of Chris Stephens
Sent: Tuesday, June 12, 2018 8:44 AM
To: oracle-l
Subject: Configuration management / Puppet for Oracle DBA'ing
The system administration folks here are big fans of Puppet. After deciding to
take it seriously and reading a bit about it (yes, I'm behind the times), the
advantages are clear and Puppet or some other configuration management software
should probably be in the mix for any well managed database environment.
Ansible seems to be picking up steam in Oracle-land. At least that's true for
my twitter feed and rss subscriptions. Is anyone else out there using Puppet
to perform DBA related tasks? If so, do you have any pointers on where to
start? Is there any reason to avoid Puppet and choose another technology?
There is a free module on Puppet Forge at
https://forge.puppet.com/biemond/oradb ;
<https://urldefense.proofpoint.com/v2/url?u=https-3A__forge.puppet.com_biemond_oradb&d=DwMFaQ&c=nulvIAQnC0yOOjC0e0NVa8TOcyq9jNhjZ156R-JJU10&r=aiKV3Uv2Wo7GqYQcis9TSvB1MZslPOnintrOY1rjG58&m=v5X_cfi1DxSHdWKUTREB24ny4NEojcIiGAbTZDYlMQc&s=cMPGqyKZ9W0TiB4mNEpAyCrA9EnTidYj4M8kUrQSfqU&e=>
. Does anyone have any experience with that?
Thanks in advance for any input.
Chris