ibre5041.ansible_oracle_modules.oracle_facts (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

Returns some facts about Oracle DB

See connection parameters for oracle_ping

Requirements

• cx_Oracle

Usage examples

Scanned by Steampunk Spotter

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

- name: Oracle DB facts
  oracle_facts:
    mode: sysdba
    userenv: false
    database: false
    instance: false
    password_file: true
    redo: summary
    standby: summary
    parameter:
      - audit_file_dest
      - db_name
      - db_unique_name
      - instance_name
      - service_names
  register: database_facts

Scanned by Steampunk Spotter

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

- name: database facts
  debug:
    var: database_facts

Inputs

    
redo:
    choices:
    - None
    - detail
    - summary
    default: None
    description:
    - Query info about redologs
    - 'summary => return array aggregated by threads: [{THREAD:1, COUNT:3, SIZE_MB: 512,
      MIN_SEQ: 1, MAX_SEQ: 3 }]'
    - detail => return array of rows from v$log
    required: false

temp:
    default: false
    description: Dislay information about temporary tablespaces
    required: false

standby:
    choices:
    - None
    - detail
    - summary
    default: None
    description: Query info about standby redologs
    required: false

userenv:
    default: true
    description: Query values from userenv
    required: false

database:
    default: true
    description: Query values from v$database
    required: false

instance:
    default: false
    description: Query values from v$instance
    required: false

parameter:
    default: false
    description: Query values from userenv
    required: false

patch_level:
    default: true
    description: Query registry to get database patch level. DB must be OPEN to display
      this value
    required: false

tablespaces:
    default: false
    description: Dislay information about permanent tablespaces
    required: false

password_file:
    aliases:
    - paths
    description:
    - Detect location of password file
    - 'Also detects other paths like: crs_home, pfile and spfile path'
    - 'This only works with mode: sysdba, when executed on db server, these paths can
      not be queried remotely'
    required: false