opitzconsulting.ansible_oracle.oracle_redo (4.7.0) — module

Install collection

Install with ansible-galaxy collection install opitzconsulting.ansible_oracle:==4.7.0

Add to requirements.yml

  collections:
    - name: opitzconsulting.ansible_oracle
      version: 4.7.0

Description

Manage redogroups

Can be run locally on the controlmachine or on a remote host

Requirements

• cx_Oracle

Usage examples

Scanned by Steampunk Spotter

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

- hosts: all
  gather_facts: true
  vars:
      oracle_home: /u01/app/oracle/12.2.0.1/db1
      hostname: "{{ ansible_hostname }}"
      service_name: orclcdb
      user: system
      password: Oracle_123
      oracle_env:
             ORACLE_HOME: "{{ oracle_home }}"
             LD_LIBRARY_PATH: "{{ oracle_home }}/lib"
      redosize: 15M
      numgroups: 3
  tasks:
  - name: Manage redologs
    oracle_redo:
        service_name={{ service_name }}
        hostname={{ hostname}}
        user={{ user }}
        password={{ password }}
        groups={{ numgroups |default(omit) }}
        size={{ redosize |default(omit)}}
    environment: "{{ oracle_env }}"
    run_once: True

Inputs

    
mode:
    choices:
    - normal
    - sysdba
    default: normal
    description: 'The mode with which to connect to the database

      '
    required: true

port:
    default: 1521
    description: 'The listener port number on the host

      '
    required: false

size:
    default: 50MB
    description: size of redologs
    required: true

user:
    description: 'The Oracle user name to connect to the database, must have DBA privilege

      '
    required: false

groups:
    description: The number of redolog groups
    required: false
    type: int

members:
    default: 1
    description: 'Either to set the preference (present) or reset it to default (absent)

      '
    required: true

hostname:
    default: localhost
    description: The Oracle database host
    required: false

password:
    description: The Oracle user password for 'user'
    required: false

service_name:
    description: 'The database service name to connect to

      '
    required: true