ari_stark.ansible_oracle_modules.oracle_profile (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

Manage profiles in an Oracle database

Requirements

• cx_Oracle

Usage examples

Scanned by Steampunk Spotter

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

# Create a profile
- hosts: dbserver
  vars:
      oracle_home: /u01/app/oracle/12.2.0.1/db1
      hostname: "{{ inventory_hostname }}"
      service_name: orclpdb
      user: system
      password: Oracle_123
      oracle_env:
             ORACLE_HOME: "{{ oracle_home }}"
             LD_LIBRARY_PATH: "{{ oracle_home }}/lib"
      profiles:
               - name: profile1
                 attribute_name:
                            - password_reuse_max
                            - password_reuse_time
                            - sessions_per_user
                 attribute_value:
                            - 6
                            - 20
                            - 5
                 state: present
  tasks:
  - name: Manage profiles
    oracle_profile:
            name={{ item.name }}
            attribute_name={{ item.attribute_name}}
            attribute_value={{ item.attribute_value}}
            state={{ item.state }}
            hostname={{ hostname }}
            service_name={{ service_name }}
            user={{ user }}
            password={{ password }}
    environment: "{{oracle_env}}"
    with_items: "{{ profiles }}"

Inputs

    
name:
    aliases:
    - profile
    default: None
    description:
    - The name of the profile
    required: true

port:
    default: 1521
    description:
    - The listener port to connect to the database if using dbms_profile
    required: false

state:
    choices:
    - present
    - absent
    default: present
    description:
    - The intended state of the profile.

hostname:
    aliases:
    - host
    default: localhost
    description:
    - The host of the database if using dbms_profile
    required: false

password:
    aliases:
    - pw
    default: None
    description:
    - The password for the DB user
    required: false

username:
    aliases:
    - un
    default: sys
    description:
    - The DB username
    required: false

oracle_home:
    aliases:
    - oh
    default: None
    description:
    - The GI ORACLE_HOME
    required: false

service_name:
    aliases:
    - sn
    description:
    - The profile_name to connect to the database.
    required: false

attribute_name:
    aliases:
    - an
    default: None
    description:
    - The attribute name (e.g PASSWORD_REUSE_TIME)

attribute_value:
    aliases:
    - av
    default: None
    description:
    - The attribute value (e.g 10)