Quarterly PSU/RU patching methods

[chrisdrew1]

I'm wondering how people are handling the quarterly patching with this module. It is great for deploying single/many machines at the same levels. When it comes time to patch you can't just add the psu to the manifest or puppet runs will start failing all over since the databases are all up. How are people handling this type of scenario? Are you using node files, or the like?

[biemond]

I am gonna take a look at puppet tasks / bolt and try to do something adhoc like shutdown the db , patch and start it up again. I think all the components are there in oradb only need to connect them.

thanks

[biemond]

I guess this can work with bolt https://github.com/puppetlabs/tasks-playground/tree/master/puppet-task

use shebang with puppet apply as command and provide the nodes you want to execute this.

create a manifest with

• stop puppet agent
• stop database
• patch
• startup db
• enable cron again for puppet agent.

when it fine add the patch to the normal manifest and it should skip it.

[chrisdrew1]

That might work. Maybe a node yaml file. PR to apply the yaml nodes > PSUs applied > DB started up > done.. Of course, it would have to be within a big if statement so that it didn't stop > apply > start at every puppet run.