ari_stark.ansible_oracle_modules.oracle_directory (1.2.1) — module

Install collection

Install with ansible-galaxy collection install ari_stark.ansible_oracle_modules:==1.2.1

Add to requirements.yml

  collections:
    - name: ari_stark.ansible_oracle_modules
      version: 1.2.1

Description

This module manage Oracle directory objects.

It can create, replace or drop directories.

Requirements

• Python module cx_Oracle
• Oracle basic tools.

Usage examples

Scanned by Steampunk Spotter

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

- name: create a directory
  oracle_directory:
    hostname: 127.0.0.1
    port: 1521
    service_name: pdbtest
    username: sys
    password: password
    mode: sysdba
    directory_name: dir
    directory_path: /data/imp

Inputs

    
mode:
    choices:
    - normal
    - sysdba
    default: normal
    description:
    - This option is the database administration privileges.
    type: str

port:
    default: 1521
    description:
    - Specify the listening port on the database server.
    type: int

state:
    choices:
    - present
    - absent
    default: present
    description:
    - Define the state of the directory being managed.
    - If I(present), directory will be created if it does not exist or modified if the
      path is different.
    - If I(absent), directory will be dropped if it exists.
    type: str

hostname:
    default: localhost
    description:
    - Specify the host name or IP address of the database server computer.
    type: str

password:
    description:
    - Set the password to use to connect the database server.
    - Must not be set if using Oracle wallet.
    required: false
    type: str

username:
    description:
    - Set the login to use to connect the database server.
    - Must not be set if using Oracle wallet.
    required: false
    type: str

oracle_home:
    description:
    - Define the directory into which all Oracle software is installed.
    - Define ORACLE_HOME environment variable if set.
    required: false
    type: str

service_name:
    aliases:
    - tns
    description:
    - Specify the service name of the database you want to access.
    required: true
    type: str

directory_name:
    aliases:
    - name
    - directory
    description:
    - The name of the directory being managed.
    required: true
    type: str

directory_path:
    aliases:
    - path
    description:
    - The path to the directory being managed.
    - Not required when I(state=absent).
    required: false
    type: str

Outputs

ddls:
  description: Ordered list of DDL requests executed during module execution.
  elements: str
  returned: always
  type: list