patch_oracle.yml

---
- hosts: oracle_patching
  gather_facts: true
  become: true
  become_user: oracle

  environment:
    ORACLE_HOME: '{{ oracle_home_path }}'
    PATH: '{{ oracle_home_path }}/OPatch:/opt/ora/app/oracle:.:/bin:/usr/ccs/bin:/usr/bin:/usr/sbin:/usr/ucb:/usr/openwin/bin:/usr/local/bin:/opt/ora/app/oracle/lbin:/opt/ora/app/oracle/product/{{ oracle_binary_version }}/bin:/opt/ora/app/oracle/product/{{ oracle_binary_version }}/bin:/usr/local/bin/perl:/home/ORADBA/local_bin:/usr/local/sbin'
    ORACLE_BASE: '/opt/ora/app/oracle'
    LD_LIBRARY_PATH: '/usr/lib:/opt/ora/app/oracle/product/{{ oracle_binary_version }}/lib:/usr/dt/lib:/usr/ucblib'
    ORAENV_ASK: 'NO'
 
  roles:
    - { role: prep }
    - { role: patching }

  tasks:

    - name: "Set the list of database SIDs if not set from prep"
      set_fact:
        DATABASE_SID: '{{ manual_post_sid_string|splitSidString }}'
      when: DATABASE_SID is undefined
      tags:
        - post

    - name: "Loop over the post role with each applicable SID"
      include_role: 
        name: post
      environment:
        ORACLE_SID: '{{ sid }}'
      loop_control:
        loop_var: sid
      with_items: '{{ DATABASE_SID }}'
      tags:
        - post

  post_tasks:
    - name: "Final --- Remove the Ansible patching directory ({{ ansible_patches_dir }})"
      file:
        #path instead of src required pre v2.3
        path: '{{ ansible_patches_dir }}'
        state: absent
      tags:
        - final
        - post

    - name: 'Final --- Enable crontab only after all databases have been patched'
      command: '/bin/bash gen_crontab.sh ; /bin/bash crontab -r'
      args:
        chdir: '/opt/ora/app/oracle/crontab'
      ignore_errors: yes
      tags:
        - final
        - post
...