opitzconsulting / opitzconsulting.ansible_oracle / 4.7.0 / module / oracle_rsrc_consgroup Manage DBMS_RESOURCE_MANAGER consumer groups | "added in version" 2.2.1 of opitzconsulting.ansible_oracle" Authors: Ilmar Kerm, ilmar.kerm@gmail.com, @ilmarkermopitzconsulting.ansible_oracle.oracle_rsrc_consgroup (4.7.0) — module
Install with ansible-galaxy collection install opitzconsulting.ansible_oracle:==4.7.0
collections: - name: opitzconsulting.ansible_oracle version: 4.7.0
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
- 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 }}"
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