opitzconsulting / opitzconsulting.ansible_oracle / 4.7.0 / module / oracle_profile Manage profiles in an Oracle database | "added in version" 2.4.1.0 of opitzconsulting.ansible_oracle" Authors: Mikael Sandström, oravirt@gmail.com, @oravirtopitzconsulting.ansible_oracle.oracle_profile (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 profiles in an Oracle database
# 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 }}"
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 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)