v4.13.1

Minor Changes

• Upgrade ansible-doctor 6.0.5 and pre-commit (#517)
• ansible-lint upgrade to 25.2.1 (#517)
• helper script for building releases (#518)
• nix: Adding direnv and nix configuration for easy setup of dev environment via nix-shell (#517)

Security Fixes

• ansible-core: Upgrade versions due to security alerts from dependbot (#517)

Bugfixes

• oradb_tzupgrade_pdbs: compose the list of PDBs in Ansible (#516)

v4.13.0

Minor Changes

• Added a guide on how to install Ansible-Oracle manually on a server without Internet access. (#506)
• Fix typo for sql_zauberkasten (#509)
• ansible-lint: more excludes (#505)
• create OMF enabled databases using dbca's -useOMF flag (#507)
• manage_pdb: Enter nested loop only when oracle_pdbs has an entry (#507)
• oraapex: Added missing option to copy source from remote or local host (#512)
• oradb_manage_db: make hard coded folder .Scripts configurable (#511)
• oradb_tzupgrade: Add orasw_meta_internal as a dependent role (#510)

Bugfixes

• orahost_meta: move scripts_folder variable from common to orahost_meta (#504)

v4.12.0

Minor Changes

• ansible-lint: more excludes (#505)
• common: remove screen from default rhel8,9 package list (#496)
• orahost: firewall_service should default to firewalld on OL/EL 8 (#499)

Bugfixes

• common: Exclude alias interfaces when templating motd.j2 (#486)
• common: force bool type in certain conditionals
• fix for re global flags when extracting sga/processes parameters in orahost_meta (#493)
• orahost_meta: Aggregate SGAs fails if no sga_target or sga_max_size is defined (#498)
• orahost_meta: Applying 'lower' filter to oracle_databases+oracle_asm_instance converts list to string (#484)
• oraswdb_manage_patches, oraswgi_manage_patches: make unarchive check work for combo patches too (#482)
• set and check _oradb_tzupgrade_candidate_pdbs fact when upgrading timezone for a CDB database (#490)

v4.11.1

Bugfixes

• devsec: changed hosts=all to hosts={{ hostgroup | default('all') }} (#479)
• orasw_download_patches: bugfix for empty oracle_databases or oracle_pdbs (#480)
• orasw_meta: empty oracle_databases broke orasw_download_patches (#480)

Release Summary

Roles for APEX and ORDS have been added in experimental state. The old issue with missing support for listener configuration in Oracle GI/Restart has been fixed. A new Playbook manage_sqlnet.ora has been added for easier configuration of listener.ora, sqlnet.ora and tnsnames.ora.

Minor Changes

• ORDS: new experimental role to install and configure ORDS on OracleLinux (#473)
• ansible-oracle Documentation fixes (#473)
• beginner_patching: Inventory for ORDS + APEX (#473)
• example rac: create multiple listener as example (#475)
• galaxy: added new collection as dependency for RAC/Restart listener configuration (#475)
• molecule: Added APEX and ORDS to dbfs-ol9 (#473)
• molecule: added 2nd listener for testing (#475)
• oraapex: New role to install APEX in databases - experimental (#473)
• oradb_manage_db: Configure sqlnet.ora, listener.ora and tnsnames.ora wirh playbook manage_sqlnet.yml (#475)
• orasw_download_patches: added support for downloading apex installation archives (#473)
• orasw_meta: changed assert for playbook manage_sqlnet.yml on RAC/Restart (#475)

Bugfixes

• oraswgi_install: documentation changes for ansible-doctor make happy again (#474)

v4.10.0

Release Summary

ansible-oracle 4.10.0 supports OL9/RHEL9 without the need to install the software
from a golden image. The exmples for beginner_patching and RAC have been fixed to
use the new pre-patching support in oraswdb_install.

Minor Changes

• added missing collection dependencies (#469)
• ansible-builder: moved to new base image (#470)
• ansible-lint: Update ansible-lint to 24.7.0 (#471)
• ansible-lint: fqcn[action-core] for ansible.builtin.yum due to OL7 compatibility (#471)
• antsibull-changelog: Upgrade version 0.29.0 (#472)
• beginner_patching: updated example to ansible-oracle 4.x (#469)
• molecule: changes to dbfs for new dbfs-ol9 szenario (#469)
• molecule: dbfs-ol9 for RDBMS prepatch testing (#469)
• ocenv: version 2024-08-23 of ocenv environment script (#468)
• oraswdb_install: Added support for prepatching in runInstaller for 19c (#469)
• oraswdb_manage_patches: added parameter oraswdb_manage_patches_force_opatch_upgrade for applyRU in runInstaller (#469)
• tools: changed requirements_dev.txt for venv (#470)

Deprecated Features

• End of Life for Oracle Linux 7 and RHEL7 (#466)

Bugfixes

• orahost_meta: Added default for oracle_install_option_gi to limit dependency to other roles (#467)

v4.9.0

Release Summary

This is the 1st production release of ansible-oracle 4.x. The RAC support was the last missing option in 4.x compared to 3.12.0. A documentation for migration from 3.12.0 to 4.x is work in progress.

Minor Changes

• added option to disable transparent hugepages in grub (#460)
• bugfix set custom environment for executables with oracle_script_env (#458)
• global_handlers: Introduce a global handlers role (#455)
• global_handlers: Reboot handler improvements, restart_on_requirement=false, ansible-lint (#457)
• molecule: added MOLECULE_IMAGE for custom images and support for SuSE (#458)
• oracle_opatch.py needs to support configurable temp directory (#462)
• orahost: Add a list of additional hosts to /etc/hosts (#447)
• orahost: add oracle_sysctl_file and oracle_hugepages_sysctl_file variables (#432)
• orahost: set vm.hugetlb_shm_group to oracle user GID (#461)
• orahost_logrotate: logrotate setup for oracle files should be optional (#449)
• orahost_meta: Enable calculation of several kernel parameters (#451)
• orahost_meta: added oracle_tmp_stage for hardened systems (#453)
• oraswdb_manage_patches: make role compatible with oraswgi_manage_patches (#464)
• oraswgi_install: Next refactoring of role for RAC (#464)
• set custom environment for executables with oracle_script_env (#453)

Breaking Changes / Porting Guide

• CV_ASSUME_DISTID: SLES15 when ansible_os_family == 'SuSE' (#458)
• oraswgi_manage_patches: python-module xmltodict needed on ansible-controller (#464)

Bugfixes

• Consider home was removed earlier, leaving REMOVED=T (#437)
• bugfix: added apply_patches_gi to some tasks with patch_before_rootsh (#464)
• default_gipass is not required if sysasmpassword and asmmonitorpassword are set (#433)
• fixed jinja spacing warning (#463)
• oracluvfy did not fail when error was detected (#464)
• orasw_meta: grid_base != oracle_base only required if role_separation=true (#439)
• oraswdb_install: Configure systemd only for Single Instance without GI/Restart (#431)
• oraswgi_install: honour deploy_ocenv setting (#443)

v4.8.0

Minor Changes

• oradb_manage_pdb: added missing defaults for pdbadmin_user and pdbadmin_password (#426)

v4.7.0

Minor Changes

• Replace run_once: _oraswgi_meta_configure_cluster with when condition (#422)
• molecule: download for current cluvfy added (#423)
• oracluvfy: New role for managing cluvfy (#423)
• orahost_meta: increase defaults for memlock limits from 0.90 to 0.91 for cluvfy (#423)
• oraswgi_install: use role oracluvfy for cluvfy during installation (#423)

Bugfixes

• oradb_rman: Removed unwanted newlines from rman_backup.sh command line (#420)
• orahost: fix wrong permissions in filesystem | Create directories (#424)
• oraswdb_install: fix broken Transfer oracle installfiles to server (#421)
• reviewed entire roles/ code basis and removed unwanted indents from yaml multiline blocks (#420)

Known Issues

• RAC installation with oracle_sw_copy=true not working

v4.6.0

Release Summary

This is the 1st Release of ansible-oracle 4.x with RAC support in expeimental stete.
The fixes from (#416) are very important for setups with more then 1 database on a host.
Please remove oracle_db_mem_totalmb from oracle_databases and set sga_target in initparams as a replacement.

Minor Changes

• RAC: Reenabled RAC-Support in 4.x (#418)
• molecule: Added 2nd database to tests (#417)
• oradb_facts: add attribute oradb_facts_ignore_unreachable to oracle_databases (#417)
• oradb_manage_db: Ignore errors during create/manage db when oradb_facts_ignore_unreachable=true (#417)
• oradb_manage_grants: check state from oracledb_facts during execution (#417)
• oradb_manage_parameters: check state from oracledb_facts during execution (#417)
• oradb_manage_pdb: check state from oracledb_facts during execution (#417)
• oradb_manage_profiles: check state from oracledb_facts during execution (#417)
• oradb_manage_redo: Disable role in RAC environments (#418)
• oradb_manage_redo: check state from oracledb_facts during execution (#417)
• oradb_manage_roles: check state from oracledb_facts during execution (#417)
• oradb_manage_services: check state from oracledb_facts during execution (#417)
• oradb_manage_statspack: check state from oracledb_facts during execution (#417)
• oradb_manage_tablespace: check state from oracledb_facts during execution (#417)
• oradb_manage_users: check state from oracledb_facts during execution (#417)
• orahost_ssh: Role rewritten with modern ansible modules (#418)
• orasw_download_patches: Download OPatch for GI/Restart (#415)

Breaking Changes / Porting Guide

• oradb_manage_db: move echo for usage of ocenv from .bashrc to .bash_profile (#418)
• orasw_meta: added assert for oracle_db_mem_totalmb in oracle_databases (#414)
• orasw_meta: added variable orasw_meta_cluster_hostgroup for RAC (#418)
• orasw_meta: assert that cdb from oracle_pdbs is in oracle_databases (#417)

Bugfixes

• global: removed redundant flatten(levels=1) filter on oracle_database/oracle_pdbs (#416)
• global: replaced match filter fith equalto to prevent partial matches where not wanted (#416)
• oradb_facts: Loop gathered facts only for first database from oracle_databases (#416)
• oradb_facts: Prevent re-using results from previous loop run when ignore_errors set to true (#416)
• oradb_manage_redo: Loop processed only first database from oracle_databases (#416)
• oradb_manage_statspack: Loops processed only first database/pdb from oracle_databases/oracle_pdbs (#416)
• oradb_rman: Loops processed only first database from oracle_databases (#416)
• orasw_meta_internal: replaced all odb[0]/opdb[0] with _odb_loop_helper/_opdb_loop_helper (#416)