Ansible Role: oracle

This role includes several variables needed by other roles related to Oracle.

Supported Operating Systems:

• RedHat
• CentOS
• OracleLinux

Requirements:

None

Role Variables:

Here are the available variables with their default values (see defaults/main.yml):

• Oracle OS User and Group

  • oracle_user: oracle
  • oracle_oinstall_group: oinstall
  • oracle_dba_group: dba

• Oracle Nagios User

  • oracle_nagios_user: nagios

• Scripts Directory

  • oracle_scripts_dir: /home/{{ oracle_user }}/scripts
  • oracle_sql_scripts_dir: "{{ oracle_scripts_dir }}/sql"
  • oracle_log_scripts_dir: "{{ oracle_scripts_dir }}/log"

• Facts Directory

  • oracle_facts_dir: "{{ oracle_scripts_dir }}/facts.d"

• Grid Infrastructure Information

  • oracle_gi_info: '{{ oracle_gatherinfo_gi_gi_info|default({}, true) }}'
    This can be automatically discovered or set manually.

• List of Databases

  • oracle_databases: '{{ oracle_gatherinfo_databases_oracle_databases|default([], true) }}'
    This can be automatically discovered or set manually.

• Registered Listeners

  • oracle_registered_listeners: '{{ oracle_gatherinfo_listener_registered_listeners|default([], true) }}'

• Running Listeners

  • oracle_running_listeners: '{{ oracle_gatherinfo_listener_running_listeners|default([], true) }}'

• Registered DB Console Services

  • oracle_dbconsole_registered_services: '{{ oracle_gatherinfo_dbconsole_registered_services|default([], true) }}'

• Running DB Console Services

  • oracle_dbconsole_running_services: '{{ oracle_gatherinfo_dbconsole_running_services|default([], true) }}'

• Default Backup Directory

  • oracle_default_backup_dir: "{% if oracle_gi_info.rac_nodes|default('',true)|length == 0 %}/u01/app/psu/backup{% else %}/u01/app/oracle/psu/backup{% endif %}"

• Default Log Directory

  • oracle_default_log_dir: "{% if oracle_gi_info.rac_nodes|default('',true)|length == 0 %}/u01/app/psu/log{% else %}/u01/app/oracle/psu/log{% endif %}"

• Default Installation Directory

  • oracle_default_stage_install_dir: /u01/app/oracle/install

• RMAN Catalog Connection String

  • oracle_rmancat_connection_string: "rmancat/secret@RMANCAT"

Dependencies:

None

Example Playbook:

N/A

This role is not directly used but is referenced in meta.yml in other Oracle roles.

To override the variables in vars/main.yml, group_vars/.., or host_vars/..:

• Example Overrides
  • oracle_user: oracle
  • oracle_oinstall_group: dba
  • oracle_dba_group: dba
  • oracle_rmancat_connection_string: "rmancat/otherpass@RMANCAT"

License:

GPLv3 - GNU General Public License v3.0

Author Information:

This role was created in 2018 by Krzysztof Lewandowski.