v4.0.0

Release Summary

This is a BETA Release of ansible-oracle. Do not use it in production environments! The release introduce https://github.com/thegeeklab/ansible-doctor[ansible-doctor] for documentation with annotations. Please make sure, that furture Pull-Requests have updated README.md included, when changes in annotations are included. A new github Action will check for it. Some variable defaults have been changed.

Minor Changes

• Added molecule to improve testing in development (oravirt#318)
• Renamed all playbooks for collection compatibility and added symbolic links (oravirt#318)
• ansible-lint 6.17.0 (oravirt#318)
• antsibull-changelog: Update to 0.23.0 in development tools (oravirt#318)
• common: ansible-doctor (oravirt#318)
• cxoracle: ansible-doctor (oravirt#318)
• cxoracle: removed pip installation for Python2 (oravirt#318)
• github Action ansible-doctor (oravirt#318)
• github Action changelog filecheck only during pull requests (oravirt#318)
• molecule: helper for easier development in ansible-oracle (oravirt#318)
• oradb_facts: new role for oracle_fact.py module (oravirt#318)
• oradb_manage_db: sys and system passwords could be different in database creation (oravirt#318)
• oradb_manage_profiles: added missing option mode for normal/sysdba connections (oravirt#318)
• oradb_manage_statspack: major code refactoring (oravirt#318)
• oradb_manage_tablespace: added missing option mode for normal/sysdba connections (oravirt#318)
• orahost: 1st test of ansible-doctor (oravirt#318)
• orahost: refactoring role (oravirt#318)
• orahost_cron: ansible-doctor (oravirt#318)
• orahost_logrotate: ansible-doctor (oravirt#318)
• orahost_meta: ansible-doctor (oravirt#318)
• orahost_meta: moved some variables from orahost into orahost_meta (oravirt#318)
• oraswdb_install: optimize installations with oracle_sw_copy (oravirt#318)
• oraswgi_instal: replace .profile_grid with ocenv (oravirt#318)
• oraswgi_meta: added asserts for inventory variables ()
• pre-commit: added ShellCheck Hook (oravirt#318)
• python-venv: helper for easier development in ansible-oracle (oravirt#318)
• replaced ansible_hostname with oracle_hostname in oracle manage roles (oravirt#318)
• rman_backup.sh: make scripte shellcheck happy (oravirt#318)

Breaking Changes / Porting Guide

• INCOMPATIBLE CHANGE: Please replace configure_cluster with oracle_install_option_gi (oravirt#318)
• change configure_cluster to _oraswgi_meta_configure_cluster (oravirt#318)
• changed variable defaults for (oravirt#318)
• dbhome-conversion tool removed (oravirt#318)
• oracle_acfs: Rename module to disable it due to broken code (oravirt#318)
• oracle_asmdg: refactoring code, make it usable for ansible-doc, Python3 usable only (oravirt#318)
• oracle_asmvol: refactoring code, make it usable for ansible-doc, Python3 usable only (oravirt#318)
• oracle_awr: refactoring code, make it usable for ansible-doc, Python3 usable only (oravirt#318)
• oracle_datapatch: refactoring code, make it usable for ansible-doc, Python3 usable only (oravirt#318)
• oracle_directory: refactoring code, make it usable for ansible-doc, Python3 usable only (oravirt#318)
• oracle_facts: refactoring code, make it usable for ansible-doc, Python3 usable only (oravirt#318)
• oracle_gi_facts: refactoring code, make it usable for ansible-doc, Python3 usable only (oravirt#318)
• oracle_grants: refactoring code, make it usable for ansible-doc, Python3 usable only (oravirt#318)
• oracle_jobclass: refactoring code, make it usable for ansible-doc, Python3 usable only (oravirt#318)
• oracle_jobs: refactoring code, make it usable for ansible-doc, Python3 usable only (oravirt#318)
• oracle_jobschedule: refactoring code, make it usable for ansible-doc, Python3 usable only (oravirt#318)
• oracle_jobwindow: refactoring code, make it usable for ansible-doc, Python3 usable only (oravirt#318)
• oracle_ldapuser: refactoring code, make it usable for ansible-doc, Python3 usable only (oravirt#318)
• oracle_parameter: refactoring code, make it usable for ansible-doc, Python3 usable only (oravirt#318)
• oracle_pdb: refactoring code, make it usable for ansible-doc, Python3 usable only (oravirt#318)
• oracle_privs: refactoring code, make it usable for ansible-doc, Python3 usable only (oravirt#318)
• oracle_profile: refactoring code, make it usable for ansible-doc, Python3 usable only (oravirt#318)
• oracle_redo: refactoring code, make it usable for ansible-doc, Python3 usable only (oravirt#318)
• oracle_role: refactoring code, make it usable for ansible-doc, Python3 usable only (oravirt#318)
• oracle_rsrc_consgroup: refactoring code, make it usable for ansible-doc, Python3 usable only (oravirt#318)
• oracle_services: refactoring code, make it usable for ansible-doc, Python3 usable only (oravirt#318)
• oracle_sql: refactoring code, make it usable for ansible-doc, Python3 usable only (oravirt#318)
• oracle_sqldba: refactoring code, make it usable for ansible-doc, Python3 usable only (oravirt#318)
• oracle_stat_prefs: refactoring code, make it usable for ansible-doc, Python3 usable only (oravirt#318)
• oracle_tablespace: refactoring code, make it usable for ansible-doc, Python3 usable only (oravirt#318)
• oracle_user: refactoring code, make it usable for ansible-doc, Python3 usable only (oravirt#318)
• orahost: removed default values for host_fs_layout (oravirt#318)

Removed Features (previously deprecated)

• Remove old desupported playbooks from playbooks/desupported (oravirt#318)
• Removed duplicate role oraswgi_opatch. Use oraswgi_manage_patches (oravirt#318)
• Removed inventory folder, comes back in example at later time (oravirt#318)
• removed role oraemagent_install (oravirt#318)

Known Issues

• Oracle Restart is not fully tested at the moment (oravirt#318)
• RAC support not availible in this release (oravirt#318)

v3.12.0

Minor Changes

• oradb_facts: add missing attributes collected by oracle_facts module (oravirt#375)

Security Fixes

• oracle_awr: added no_log attribute to password fields (oravirt#375)
• oracle_facts: added no_log attribute to password fields (oravirt#375)
• oracle_job: added no_log attribute to password fields (oravirt#375)
• oracle_jobclass: added no_log attribute to password fields (oravirt#375)
• oracle_jobschedule: added no_log attribute to password fields (oravirt#375)
• oracle_jobwindow: added no_log attribute to password fields (oravirt#375)
• oracle_ldapuser: added no_log attribute to password fields (oravirt#375)
• oracle_rsrc_consgroup: added no_log attribute to password fields (oravirt#375)

Bugfixes

• oradb_rman: better handle rman_jobs with state: absent (oravirt#374)

v3.11.0

Minor Changes

• new vagrantbox example beginner_patching (oravirt#370)
• oradb_rman: added option state for cronjobs, disabled is optional now (oravirt#369)

Bugfixes

• oradb_manage_db: bugfix for wrong IFILE path in tnsnames.ora and sqlnet.ora when readonly ORACLE_HOME is used (oravirt#371)

v3.10.1

Bugfixes

• oradb_facts: Bugfix for missing default variable definitions (oravirt#366)
• oradb_manage_grant: Bugfix for broken grant on pdb with db_domain (oravirt#365)

v3.10.0

Minor Changes

• oracle_sqldba: refactoring code, make it usable for ansible-doc, Python3 usable only (oravirt#361)
• oradb_manage_db: create _DGMGRL SID in listener.ora for EE only (oravirt#359)

Bugfixes

• Bugfix for missing Listener autostart and readonly Homes in systemd (oravirt#358)
• oracle_sqldba: Bugfix for Python3 (oravirt#361)
• oraswdb_install: shellchecker for manage_oracle_rdbms_procs.sh (oravirt#358)
• pre-commit: Bugfix for known issue from ansible-oracle 3.8.0 (oravirt#383)

v3.9.0

Release Summary

This release adds support for db_domain in init.ora for nonCDB and CDB. Read (oravirt#356) for requirements and notes.

Minor Changes

• Added support for db_domain in init.ora (oravirt#356)
• oradb_facts: Backported role from dev release (oravirt#356)
• oraswdb_install: fixed wrong creates in curl.yml (oravirt#354)

Bugfixes

• oraswdb_install: enable CV_ASSUME_DISTID=OL7 for Golden-Image on OL/RHEL8 (oravirt#355)

v3.8.1

Bugfixes

• oraswdb_install: bugfix for imagename in db_homes_config (oravirt#352)

v3.8.0

Release Summary

This is ansible-oracle 3.8.0. The target database server must have Python3 installaed which is automatically done with role orahost. It is mandatory for the module oracle_db which is used in oradb_manage_db.

Minor Changes

• Add restart possibility after scope=spfile init parameters change (oravirt#342)
• Add state=restarted to oracle_db (oravirt#342)
• Remove deprecation warnings for community.general 7.x (oravirt#339)
• black: adding black to pre-commit (oravirt#343)
• flake8: adding flake8 to pre-commit (oravirt#343)
• github Actions: adding Action for black and flake8 (oravirt#343)
• ocenv: version 2023-06-06 of ocenv environment script (oravirt#347)
• oracle_db: Refactoring code for flake8 (oravirt#342)

Breaking Changes / Porting Guide

• cx_Oracle: requires Python3 installed on target system (oravirt#342)
• cx_oracle: Added installation of cx_Oracle for Python3 (oravirt#346)
• oradb_manage_db: requires Python3 installed on target system (oravirt#342)

Deprecated Features

• modules: all modules will loose support for Python2 in ansible-oracle 4.0.0 (oravirt#346)

Bugfixes

• common: removed assert for python due to oravirt#346 (oravirt#350)
• orasw_download_patches: added missing assert for oracle_sw_source_local (oravirt#340)
• oraswdb_install: changed oracle_databases to db_homes_installed for installation source of ORACLE_HOMEs (oravirt#348)
• oraswdb_manage_patches: Bugfix for missing opatch or opatchauto in db_homs_config dict (oravirt#349)
• pre-commit: added antsibull-changelog-lint (oravirt#345)
• pre-commit: moved ansible-lint to end of pre-commit hooks (oravirt#344)

Known Issues

• pre-commit: Ignore [WARNING] The 'rev' field of repo 'https://github.com/ansible-community/antsibull-changelog.git'. This will be fixed with next antsibull-changelog release.

The collection was released on May 7 but the release on github was not created.

Minor Changes

• added task to REGISTER DATABASE in Rman Catalog (oravirt#336)
• ansible-lint: Update to 6.14.4 (oravirt#329)
• orahost: improve oracle os packages selection for Suse (oravirt#337)

v3.6.0

Minor Changes

• added new orasw_download_patches role (oravirt#332)
• common: assert python2 interpreter on OL/RHEL7 (oravirt#330)
• github action: deploy collection (oravirt#324)
• github action: stale issues & PRs (oravirt#326)
• orasw_meta: added central assert tasks for ansible-oracle (oravirt#325)