oravirt / ansible-oracle

Oracle related stuff. Installs RAC/RAC One Node/Single Instance
MIT License
346 stars 249 forks source link

Enable calculation of several kernel parameters #451

Closed ThiloSolbrig closed 5 months ago

ThiloSolbrig commented 6 months ago

Changes:

Enhancements:

Note (1): Kernel paramers are no actually set by these changes. Aggregates rather can be used to e.g. configure oracle_sysctl list or size_in_gb_hugepages.

Example:

size_in_gb_hugepages: "{{ oracle_databases_sga_sum | default(0) | int / 1024**3 }}"
oracle_sysctl:
  - name: kernel.panic # sysctl_kernel_panic defined by orahost_meta
    value: "{{ sysctl_kernel_panic }}"
  - name: kernel.sem
    value: "{{ sysctl_kernel_sem }}"
  - name: kernel.shmall # Doc ID 301830.1
    value: "{{ (( oracle_databases_sga_sum | default(0) | int ) / ( page_size_bytes | int )) | int }}"

Note (2): ASM instance should be described if it's forced to use hugepages:

oracle_asm_instance:
  - init_parameters:
      - name: sga_target
        value: 4G
      - name: processes
        value: "{{ (oracle_databases | default([])) | length * 450 + 50 }}"
Rendanic commented 6 months ago

Closes #450