ibre5041.ansible_oracle_modules.oracle_parameter (3.2.0) — module

Install collection

Install with ansible-galaxy collection install ibre5041.ansible_oracle_modules:==3.2.0

Add to requirements.yml

  collections:
    - name: ibre5041.ansible_oracle_modules
      version: 3.2.0

Description

Manage init parameters in an Oracle database

Also handles underscore parameters. That will require using mode=sysdba, to be able to read the X$ tables needed to verify the existence of the parameter.

See connection parameters for oracle_ping

Requirements

• cx_Oracle
• re

Usage examples

Scanned by Steampunk Spotter

• Success
  Steampunk Spotter scan finished with no errors, warnings or hints.

- name: Set the value of db_recovery_file_dest
  oracle_parameter:
    mode: sysdba
    name: db_recovery_file_dest
    value: '+FRA'
    state: present
    scope: both
    sid: '*'

Scanned by Steampunk Spotter

• Success
  Steampunk Spotter scan finished with no errors, warnings or hints.

- name: Set the value of db_recovery_file_dest_size
  oracle_parameter:
    mode: sysdba    
    name: db_recovery_file_dest_size
    value: 100G
    state: present
    scope: both

Scanned by Steampunk Spotter

• Success
  Steampunk Spotter scan finished with no errors, warnings or hints.

- name: Set the numeric value of open_cursors
  oracle_parameter:
    mode: sysdba
    name: "open_cursors"
    value: "351"
    state: "present"

Scanned by Steampunk Spotter

• Success
  Steampunk Spotter scan finished with no errors, warnings or hints.

- name: Set boolean value of blank_trimming"
  oracle_parameter:
    mode: sysdba
    name: "blank_trimming"
    value: "TRUE"
    state: "present"
    scope: "spfile"

Scanned by Steampunk Spotter

• Success
  Steampunk Spotter scan finished with no errors, warnings or hints.

    
- name: Reset the value of open_cursors
  oracle_parameter:
    mode: sysdba    
    name: db_recovery_file_dest_size
    state: reset
    scope: spfile

Inputs

    
name:
    default: null
    description: The parameter that is being changed
    required: false

state:
    choices:
    - present
    - absent
    - reset
    default: present
    description: The intended state of the parameter (present means set to value, absent/reset
      means the value is reset to its default value).

value:
    default: null
    description: The value of the parameter
    required: false