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!

On Tue, Jun 12, 2018 at 2:07 PM Matthew Parker <dimensional.dba_at_comcast.net> wrote:

> 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 <(425)%20891-7934> (cell)*
>
> *D&B *047931344
>
> *CAGE *7J5S7
>
> *Dimensional.dba_at_comcast.net <Dimensional.dba_at_comcast.net>*
>
> *View Matthew Parker's profile on LinkedIn*
> <http://www.linkedin.com/pub/matthew-parker/6/51b/944/>
>
> www.dimensionaldba.com
>
>
>
>
>
> *From:* oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> *On
> Behalf Of *Jay.Miller_at_tdameritrade.com
> *Sent:* Tuesday, June 12, 2018 11:51 AM
> *To:* dimensional.dba_at_comcast.net; cstephens16_at_gmail.com
> *Cc:* sethmiller.sm_at_gmail.com; Oracle-L_at_freelists.org
>
>
> *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 <(201)%20369-8355>
>
>
>
> *From:* Matthew Parker [mailto:dimensional.dba_at_comcast.net
> <dimensional.dba_at_comcast.net>]
> *Sent:* Tuesday, June 12, 2018 11:20 AM
> *To:* 'Chris Stephens'
> *Cc:* sethmiller.sm_at_gmail.com; 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 <(425)%20891-7934> (cell)*
>
> *D&B *047931344
>
> *CAGE *7J5S7
>
> *Dimensional.dba_at_comcast.net <Dimensional.dba_at_comcast.net>*
>
> *View Matthew Parker's profile on LinkedIn*
> <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=>
>
> 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_at_gmail.com>
> *Sent:* Tuesday, June 12, 2018 8:05 AM
> *To:* Matthew Parker <dimensional.dba_at_comcast.net>
> *Cc:* sethmiller.sm_at_gmail.com; Jay.Miller_at_tdameritrade.com; Oracle-L
> Freelists <Oracle-L_at_freelists.org>
> *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_at_comcast.net> 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 <(425)%20891-7934> (cell)*
>
> *D&B *047931344
>
> *CAGE *7J5S7
>
> *Dimensional.dba_at_comcast.net <Dimensional.dba_at_comcast.net>*
>
> *View Matthew Parker's profile on LinkedIn*
> <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=>
>
> 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_at_freelists.org <oracle-l-bounce_at_freelists.org> *On
> Behalf Of *Seth Miller
> *Sent:* Tuesday, June 12, 2018 7:36 AM
> *To:* Chris Stephens <cstephens16_at_gmail.com>
> *Cc:* Jay.Miller_at_tdameritrade.com; Oracle-L Freelists <
> Oracle-L_at_freelists.org>
> *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_at_gmail.com>
> wrote:
>
> that's interesting. thanks for input.
>
>
>
> On Tue, Jun 12, 2018 at 8:49 AM <Jay.Miller_at_tdameritrade.com> 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 <(201)%20369-8355>
>
>
>
> *From:* oracle-l-bounce_at_freelists.org [mailto:
> oracle-l-bounce_at_freelists.org] *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
>
>
>
>

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