opitzconsulting / opitzconsulting.ansible_oracle / 4.7.0 / module / oracle_awr Manage AWR configuration | "added in version" 2.2.1 of opitzconsulting.ansible_oracle" Authors: Ilmar Kerm, ilmar.kerm@gmail.com, @ilmarkermopitzconsulting.ansible_oracle.oracle_awr (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 AWR configuration
Can be run locally on the controlmachine or on a remote host
--- - hosts: localhost vars: oraclehost: 192.168.56.101 oracleport: 1521 oracleservice: orcl12c 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: set AWR settings oracle_awr: hostname: "{{ oraclehost }}" port: "{{ oracleport }}" service_name: "{{ oracleservice }}" user: "{{ oracleuser }}" password: "{{ oraclepassword }}" interval: 30 retention: 40 environment: "{{ oracle_env }}"
mode: choices: - normal - sysdba default: normal description: 'The mode with which to connect to the database ' required: true type: str 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 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 snapshot_interval_min: aliases: - interval default: 60 description: 'AWR snapshot interval in minutes; 0 disables ' type: int snapshot_retention_days: aliases: - retention default: 8 description: 'AWR snapshot retention time in days ' type: int