install_oracle_restart_19c.vmware.yml

---

# TODO 
#      r/o OH ?
#      hugepages
#      tuned-adm profile oracle

- hosts: all
  collections:
    - ibre5041.ansible_oracle_modules    
  become: yes
  become_user: root
  become_method: sudo

  roles:
    # - role: base_host_ec2
    #   tags: [ base, basehost ]
    
    - role: base_oracle_vmware
      tags: [ base, baseoracle ]

    # included from oracle_restart_19c
    #- role: oracle_asm_disks_ec2
    #  tags: [ oracle, oraclerestart, oracleasm ]
    
    - role: oracle_restart_19c
      oracle_gi_media: "grid_home_19_21.zip"
      tags: [ oraclerestart ]
    
    - role: oracle_db_home
      oracle_db_media: "db_home_19_21.zip"
      tags: [ oracle, oracledbhome ]
    
    # - role: oracle.db.create.19c
    #   tags: [ oracle, oracledb ]
  
    - role: oracle_post_install
      tags: [ oraclepost ]

  tasks:
    - name: create database
      oracle_db:
        oracle_home: "{{ oracle_home }}"
        db_name: 'TEST19C'
        sid: 'TEST19C'
        db_unique_name: 'TEST19C_1'
        sys_password: X43ofljfksjfkhfr3fkh        
        #system_password:
        #dbsnmp_password:
        #template:
        db_options:
          JSERVER: False
          ORACLE_TEXT: False
          IMEDIA: False
          CWMLITE: False
          SPATIAL: False
          OMS: False
          APEX: False
          DV: False
        initparams:
          memory_target: 0
          memory_max_target: 0
          sga_target: 1500MB
          sga_max_size: 1500MB
        storage_type: ASM
        datafile_dest: +XDATA
        recoveryfile_dest: +XDATA
        #state: absent
        state: present
      tags: [oracledb]
      become_user: "{{ oracle_os_user }}"
      become: yes