v4.8.0

Minor Changes

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

v4.7.0

Minor Changes

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

Bugfixes

• oradb_rman: Removed unwanted newlines from rman_backup.sh command line (oravirt#420)
• orahost: fix wrong permissions in filesystem | Create directories (oravirt#424)
• oraswdb_install: fix broken Transfer oracle installfiles to server (oravirt#421)
• reviewed entire roles/ code basis and removed unwanted indents from yaml multiline blocks (oravirt#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 (oravirt#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 (oravirt#418)
• molecule: Added 2nd database to tests (oravirt#417)
• oradb_facts: add attribute oradb_facts_ignore_unreachable to oracle_databases (oravirt#417)
• oradb_manage_db: Ignore errors during create/manage db when oradb_facts_ignore_unreachable=true (oravirt#417)
• oradb_manage_grants: check state from oracledb_facts during execution (oravirt#417)
• oradb_manage_parameters: check state from oracledb_facts during execution (oravirt#417)
• oradb_manage_pdb: check state from oracledb_facts during execution (oravirt#417)
• oradb_manage_profiles: check state from oracledb_facts during execution (oravirt#417)
• oradb_manage_redo: Disable role in RAC environments (oravirt#418)
• oradb_manage_redo: check state from oracledb_facts during execution (oravirt#417)
• oradb_manage_roles: check state from oracledb_facts during execution (oravirt#417)
• oradb_manage_services: check state from oracledb_facts during execution (oravirt#417)
• oradb_manage_statspack: check state from oracledb_facts during execution (oravirt#417)
• oradb_manage_tablespace: check state from oracledb_facts during execution (oravirt#417)
• oradb_manage_users: check state from oracledb_facts during execution (oravirt#417)
• orahost_ssh: Role rewritten with modern ansible modules (oravirt#418)
• orasw_download_patches: Download OPatch for GI/Restart (oravirt#415)

Breaking Changes / Porting Guide

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

Bugfixes

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

v4.5.0

Minor Changes

• Change Shebang to /usr/bin/env bash (oravirt#409)
• Documentation updates (oravirt#389)
• build(deps): bump ansible-core from 2.15.8 to 2.15.9 in /tools/dev (oravirt#408)
• minor fixes for role separation in Oracle Restart (oravirt#409)
• oradb_manage_db: Assert SYS password in inventory before dbca (oravirt#409)

Breaking Changes / Porting Guide

• Removed oracle_password - use default_gipass as replacement (oravirt#409)
• orahost: Removed fixed password for oracle and grid from defaults (oravirt#409)
• orasw_meta: Removed default passwords from default_dbpass and dbpasswords (oravirt#409)
• oraswgi_install: Removed default password from default_gipass (oravirt#409)

Security Fixes

• orahost: Removed fixed password for oracle and grid from defaults (oravirt#409)
• orasw_meta: Removed default passwords from default_dbpass and dbpasswords (oravirt#409)
• oraswgi_install: Removed default password from default_gipass (oravirt#409)

Bugfixes

• orahost: fix for broken configure_hugepages=false (oravirt#412)
• orasw_meta: Removed warning from ansible (oravirt#409)

v4.4.2

Release Summary

This is a BETA Release of ansible-oracle. Do not use it in production environments!

Bugfixes

• oradb_manage_wallet: bugfix for broken Remove DB-Credentials (oravirt#406)
• oradb_manage_wallet: bugfix for broken oracle_wallet_password (oravirt#406)
• oraswdb_manage_patches: refresh opatch lsinv after opatch rollback (oravirt#405)

v4.4.1

Release Summary

This is a BETA Release of ansible-oracle. Do not use it in production environments!

Bugfixes

• oradb_manage_wallet: fixed wrong dbpassword assignment, added debug option for password (oravirt#404)

v4.4.0

Release Summary

This is a BETA Release of ansible-oracle. Do not use it in production environments!

Minor Changes

• ansible-doctor: Update to 4.0.1 (oravirt#397)
• oradb_manage_db: Added support for aliasnames for Oracle Wallet (oravirt#400)
• oradb_manage_db: allow multiline values for keys in sqlnet_ansible.ora (oravirt#400)
• oradb_manage_wallet: New role for managing Oracle Wallets (oravirt#400)
• pre-commit: Update multiple hooks (oravirt#397)

Security Fixes

• dependabo: Update ansible-core in dev-tools (oravirt#398)
• dependabo: bump ansible from 6.7.0 to 8.5.0 in /tools/ansible (oravirt#395)
• dependabo: bump tj-actions/changed-files from 31 to 41 in /.github/workflows (oravirt#396)
• oradb_manage_db: Remove visible password for sys, system and dbsnmp from dbca responsefile for 12.2+ (oravirt#401)

v4.3.0

Release Summary

This is a BETA Release of ansible-oracle. Do not use it in production environments!

Minor Changes

• ansible-lint v6.22.1 (oravirt#392)
• molecule: add tnsname configuration to shared inventory (oravirt#388)
• oradb_facts: Skip oracledb_facts when db not reachable (oravirt#387)

Bugfixes

• common: install lsof for all RHEL/OL distributions (oravirt#391)
• oradb_manage_db: Bugfix for undefined variable listener_home_config (oravirt#386)
• orahost: Fix warning conditional statements should not include jinja2 templating (oravirt#391)

v4.2.0

Release Summary

This is a BETA Release of ansible-oracle. Do not use it in production environments!

Major Changes

• Ansible 7 (2.14) is new minimal version in ansible-oracle 4.x (oravirt#384)

Minor Changes

• example: added oracle_listeners_config and listener_installed due to new asserts in 4.0 (oravirt#384)
• experimental support for OracleLinux 9 (oravirt#384)
• molecule: Switch to RU 19.21 (oravirt#384)

Breaking Changes / Porting Guide

• Ansible 7 (2.14) is new minimal version in ansible-oracle 4.x (oravirt#384)
• oraswdb_golden_image: Fixed wrong varible names oraswdb_golen_* to oraswdb_golden_* from breaking change oravirt#383 (oravirt#384)
• oraswgi_golden_image: Fixed wrong varible names oraswgi_golen_* to oraswgi_golden_* from breaking change oravirt#383 (oravirt#384)

Bugfixes

• oraswdb_manage_patches: bugfix for wrong stage directory when oracle_sw_copy=true (oravirt#384)

v4.1.0

Release Summary

This is a BETA Release of ansible-oracle. Do not use it in production environments!

Minor Changes

• ansible-lint V6.20.3 (oravirt#383)
• molecule: new stage download to prepare dbfs stage (oravirt#383)
• molecule: new stage golden to create golden images (oravirt#383)
• oiraswgi: Added Support for gridSetup.sh -applyRU for 19c and 21c (oravirt#383)
• oraasm_manage_diskgroups: Refactoring and bugfixes for 4.0 (oravirt#383)
• oracle_opatch: replace sqlplus -V with oraversion for newer releases (oravirt#383)
• oraswdb_golen_image: Rename created archive to fixed name (oravirt#383)
• oraswgi_golen_image: Rename created archive to fixed name (oravirt#383)

Breaking Changes / Porting Guide

• oraswdb_golen_image: New variable oraswdb_golen_image_create: false (oravirt#383)
• oraswgi_golen_image: New variable oraswgi_golen_image_create: false (oravirt#383)

Bugfixes

• Bugfix for state=absent in oracle_databases with CDB (oravirt#383)
• molecule: Use shared inventory with download scenario (oravirt#383)
• oracle_opatch: fix wrong rolling parameter definition, fix broken opatch opatchauto rollback (oravirt#383)
• oradb_datapatch: allow execution of role with empty oracle_databases and oracle_pdbs (oravirt#383)
• oradb_manage_db: Regather oradb_facts after database change (oravirt#383)
• oradb_manage_statspack: Bugfix for nonCDB setups (oravirt#383)
• orahost: Do not set NOZEROCONF on SuSE platform (oravirt#383)