opitzconsulting.ansible_oracle.oracle_rsrc_consgroup (4.7.0) — module

Manage DBMS_RESOURCE_MANAGER consumer groups

| "added in version" 2.2.1 of opitzconsulting.ansible_oracle"

Authors: Ilmar Kerm, ilmar.kerm@gmail.com, @ilmarkerm

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 DBMS_RESOURCE_MANAGER consumer groups

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

For more accurate documentation about attributes, please check Oracle DB documentation about DBMS_RESOURCE_MANAGER


Requirements

Usage examples

  • 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: job class
      oracle_rsrc_consgroup:
        hostname: "{{ oraclehost }}"
        port: "{{ oracleport }}"
        service_name: "{{ oracleservice }}"
        user: "{{ oracleuser }}"
        password: "{{ oraclepassword }}"
        state: present
        name: testgroup1
        comments: hello world
        grant:
          - OE
          - SH
          - PM
          - IX
        grant_user_profile:
          - HR1
        map_oracle_user_profile:
          - HR1
        map_oracle_user:
          - OE
          - SH
          - PM
          - IX
        map_service_name:
          - app1
          - app2
        map_client_machine:
          - appserver3
      environment: "{{ oracle_env }}"

Inputs

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

name:
    description: Resource consumer group name
    required: true

port:
    default: 1521
    description: The listener port number on the host
    required: false

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

      '
    required: false

state:
    choices:
    - present
    - absent
    description: 'If present, then consumer group is created, if absent, then consumer
      group is removed

      '
    required: true

category:
    default: other
    description: Describes the category of the consumer group

comments:
    description: Comment about the group
    required: false

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

mgmt_mth:
    default: round-robin
    description: Name of CPU resource allocation method

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

grant_name:
    aliases:
    - grant
    - grant_user
    - grant_role
    - grants
    description: 'List of users and roles that will be granted switch to this consumer
      group

      '
    required: false
    type: list

service_name:
    description: The database service name to connect to
    required: true

map_client_id:
    description: 'This procedure adds, deletes, or modifies entries that map sessions
      to consumer groups, based on the session''s login and runtime attributes. Check
      Oracle documentation on DBMS_RESOURCE_MANAGER.SET_CONSUMER_GROUP_MAPPING on more
      details.

      '
    required: false
    type: list

map_module_name:
    description: 'This procedure adds, deletes, or modifies entries that map sessions
      to consumer groups, based on the session''s login and runtime attributes. Check
      Oracle documentation on DBMS_RESOURCE_MANAGER.SET_CONSUMER_GROUP_MAPPING on more
      details.

      '
    required: false
    type: list

map_oracle_user:
    description: 'This procedure adds, deletes, or modifies entries that map sessions
      to consumer groups, based on the session''s login and runtime attributes. Check
      Oracle documentation on DBMS_RESOURCE_MANAGER.SET_CONSUMER_GROUP_MAPPING on more
      details.

      '
    required: false
    type: list

map_service_name:
    description: 'This procedure adds, deletes, or modifies entries that map sessions
      to consumer groups, based on the session''s login and runtime attributes. Check
      Oracle documentation on DBMS_RESOURCE_MANAGER.SET_CONSUMER_GROUP_MAPPING on more
      details.

      '
    required: false
    type: list

grant_user_profile:
    description: 'All users with these profiles will be granted switch to this consumer
      group

      '
    required: false
    type: list

map_client_machine:
    description: 'This procedure adds, deletes, or modifies entries that map sessions
      to consumer groups, based on the session''s login and runtime attributes. Check
      Oracle documentation on DBMS_RESOURCE_MANAGER.SET_CONSUMER_GROUP_MAPPING on more
      details.

      '
    required: false
    type: list

map_client_os_user:
    description: 'This procedure adds, deletes, or modifies entries that map sessions
      to consumer groups, based on the session''s login and runtime attributes. Check
      Oracle documentation on DBMS_RESOURCE_MANAGER.SET_CONSUMER_GROUP_MAPPING on more
      details.

      '
    required: false
    type: list

map_client_program:
    description: 'This procedure adds, deletes, or modifies entries that map sessions
      to consumer groups, based on the session''s login and runtime attributes. Check
      Oracle documentation on DBMS_RESOURCE_MANAGER.SET_CONSUMER_GROUP_MAPPING on more
      details.

      '
    required: false
    type: list

map_service_module:
    description: 'This procedure adds, deletes, or modifies entries that map sessions
      to consumer groups, based on the session''s login and runtime attributes. Check
      Oracle documentation on DBMS_RESOURCE_MANAGER.SET_CONSUMER_GROUP_MAPPING on more
      details.

      '
    required: false
    type: list

map_oracle_function:
    description: 'This procedure adds, deletes, or modifies entries that map sessions
      to consumer groups, based on the session''s login and runtime attributes. Check
      Oracle documentation on DBMS_RESOURCE_MANAGER.SET_CONSUMER_GROUP_MAPPING on more
      details.

      '
    required: false
    type: list

map_module_name_action:
    description: 'This procedure adds, deletes, or modifies entries that map sessions
      to consumer groups, based on the session''s login and runtime attributes. Check
      Oracle documentation on DBMS_RESOURCE_MANAGER.SET_CONSUMER_GROUP_MAPPING on more
      details.

      '
    required: false
    type: list

map_oracle_user_profile:
    description: 'Module appends all users with mentioned profiles to map_oracle_user
      parameter list

      '
    required: false
    type: list

map_service_module_action:
    description: 'This procedure adds, deletes, or modifies entries that map sessions
      to consumer groups, based on the session''s login and runtime attributes. Check
      Oracle documentation on DBMS_RESOURCE_MANAGER.SET_CONSUMER_GROUP_MAPPING on more
      details.

      '
    required: false
    type: list