install_oracle_restart_19c.ec2.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_ec2
      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_2022_Oct.zip"
      tags: [ oraclerestart ]
    
    - role: oracle_db_home
      oracle_db_media: "db_home_2022_Oct.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:true
          - 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