---
- name: Download and Configure Oracle AutoUpgrade
  hosts: all
  become: yes

  vars:
    central_software_host: "srvgpiaap01"
    oracle_base: "/u01/app/oracle"
    oracle_user: "oracle"
    download_url: "https://download.oracle.com/otn-pub/otn_software/autoupgrade.jar"
    download_dir: "/app/oracle_install/autoupgrade"
    autoupgrade_dir: "{{ oracle_base }}/autoupgrade"
    autoupgrade_dirs:
      - "{{ oracle_base }}/autoupgrade"
      - "{{ oracle_base }}/autoupgrade/logs"
      - "{{ oracle_base }}/autoupgrade/config"
      - "{{ oracle_base }}/autoupgrade/bin"
      - "{{ oracle_base }}/autoupgrade/patchdir"
      - "{{ oracle_base }}/autoupgrade/keystore"
    central_software_path: "/app/oracle_install"
    oracle_installer: "LINUX.X64_193000_db_home.zip"


  tasks:


   # 1. Download AutoUpgrade 

   - name: Download AutoUpgrade utility
     ansible.builtin.uri:
       url: "{{ download_url  }}"
       dest: "{{ download_dir }}/autoupgrade.jar"
       validate_certs: no
     register: response
     #ignore_errors: yes
     failed_when: response.status != 200 and response.status != 304
     delegate_to: "{{ central_software_host }}"

   - name: Show download
     ansible.builtin.debug:
       var: response

   # 2. Prepare directories
   - name: Create AutoUpgrade directory structure
     ansible.builtin.file:
       path: "{{ item }}"
       state: directory
       owner: "{{ oracle_user }}"
       group: oinstall
       mode: '0755'
     loop: "{{ autoupgrade_dirs }}"



   # 3. copy with scp from zentral Server
   - name: Copy Auto Upgarde
     ansible.builtin.command:
       scp -o StrictHostKeyChecking=no ansiblesvc@"{{ central_software_host }}:{{ download_dir }}/autoupgrade.jar" "{{ autoupgrade_dir }}/bin/autoupgrade.jar"
   - name: Download Oracle installer 19.03
     ansible.builtin.command:
       scp -o StrictHostKeyChecking=no ansiblesvc@"{{ central_software_host }}:{{ central_software_path }}/19.03/{{ oracle_installer }}" "{{ autoupgrade_dir }}/patchdir/{{ oracle_installer }}"


   - name: Set environment variables
     ansible.builtin.blockinfile:
       path: "/home/{{ oracle_user }}/.bashrc"
       block: |
          # AutoUpgrade Configuration
          export AUTOUPGRADE_HOME={{ autoupgrade_dir }}
          export PATH=$AUTOUPGRADE_HOME/bin:$PATH
          alias autoupgrade="java -Dhttps.protocols=TLSv1.3 -jar $AUTOUPGRADE_HOME/bin/autoupgrade.jar"
       marker: "# {mark} AUTOUPGRADE CONFIG"

    # 4. Validate installation
   - name: Verify AutoUpgrade installation
     ansible.builtin.command: "java -jar {{ autoupgrade_dir }}/bin/autoupgrade.jar -version"
     register: autoupgrade_version_check
     changed_when: false
     failed_when: autoupgrade_version_check.rc != 0

   - name: Display version info
     ansible.builtin.debug:
       var: autoupgrade_version_check.stdout_lines