Oracle 18c Patch Release Update Rollback [ RAC 18.5 to 18.3 | January'19 ] using ANSIBLE TOWER

Oracle 18.5 Patch Release Update Rollback [ RAC ] using ANSIBLE TOWER

This article is for applying RU on 18c RAC database with one PDB.

========================
SET UP - ANSIBLE TOWER
========================
i. Create Credential

Go to settings
select CREDENTIALS - to create click on +ADD and pass necessary values.
 - Here I created three users oracleuser,griduser and rootuser of Machine kind
 - I created githubpass of Source Control type

ii. Create INVENTORIES

Go to INVENTORIES tab and click on +ADD to create a inventory.
Here I created
  - one inventory dbservers

iii. Create group and assigned HOSTS 
Go to INVENTORIES -->dbservers
 - click on +ADD HOST to add a new host entry
 - Assign them to a group if needed

iv. Create PROJECTS
 - click on PROJECTS tab
 - Pass the values for
    NAME,
    ORGANIZATION,
    SCM TYPE,
    PLAYBOOK DIRECTORY
 - click SAVE button.

v. Create TEMPLATE
 - click on TEMPLATE
 - Pass the values for
    NAME,
    JOB TYPE (check / Run) ,
    INVENTORY,
    PROJECT,
    PLAYBOOK (master playbook),
    credential,
    VERBOSITY (level)
    OPTIONS [ choose based on the requirements]
 -  click on SAVE button.

                                                  video: execute job from the Ansible tower

TO EXECUTE the JOB -
go to the TEMPLATES and select the right template - and click on "Start a job using this template" launcher button

Check the JOB Status

Go to the JOBS tab
select the job and you can get the job details on the left pane and logs on the right pane.

Master Playbook

We are running a role 'racdb_patch_rollback'  for RU rollback



Tree structure for this rollback setup is as below -

The main.yml contents of this playbook is as below -