Ansible Oracle21c Database Opatch Automated Fleet Patching

This Ansible Proof-Of-Concept playbook patches a 21c Oracle database with a Release Update patch, entirely unattended. It can be any Oracle patch, its patch ID is passed as a variable. This is an example of the benefits Ansible or any other automation offers. This POC patches one database, but just as easily it could patch a thousand, in parallel (all at the same time) , while following Oracle's Best Practices all along. The playbook first checks of the prerequisites are met, then it takes a pre-patch SQL Tuning Set, applies the patch, takes another look at top 500 queries using the DBMS_SQLPA , and if the regression score is higher than a certain number it automatically rolls back the patch only on the hosts that the patch will hurt, instead of helping. The Ansible GO/NOGO decision making can be adjusted on many criteria. Takes 3 different levels of backup, if the rollback fails. It re-measures the Impact Score after every change. Can do it on one server, or a thousand, simultaneously.