opitzconsulting.ansible_oracle.oracle_facts (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

Returns some facts about Oracle DB

Requirements

• cx_Oracle

Usage examples

Scanned by Steampunk Spotter

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

- hosts: localhost
  vars:
    oraclehost: 192.168.56.101
    oracleport: 1521
    oracleservice: orcl
    oracleuser: system
    oraclepassword: oracle
    oracle_env:
      ORACLE_HOME: /usr/lib/oracle/12.1/client64
      LD_LIBRARY_PATH: /usr/lib/oracle/12.1/client64/lib
  tasks:
    - name: gather database facts
      oracle_facts:
        hostname: "{{ oraclehost }}"
        port: "{{ oracleport }}"
        service_name: "{{ oracleservice }}"
        user: "{{ oracleuser }}"
        password: "{{ oraclepassword }}"
      register: dbfacts
    - debug:
        var: dbfacts

Inputs

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

      '
    required: false
    type: str

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

      '
    required: false
    type: str

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

      '
    required: false
    type: str

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

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

      '
    required: false
    type: str

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

      '
    required: true
    type: str