ansible-oracle v3.0.0

v3.0.0

Release Summary

ansible-oracle has been converted into a collection.
This release starts using antsibull-changelog for managing the CHANGELOG.rst.

Major Changes

• Added antsibull-changelog for managing the CHANGELOG.rst (opitzconsulting#102)
• moved ansible-oracle into a collection (opitzconsulting#99)

Minor Changes

• Parameter oracle_asm_disk_string could be set when asmlib is used (opitzconsulting#82)
• Refactoring oraswgi-install for 19c and 21c (opitzconsulting#82)
• Removed parameter -ignorePrereq during GridSetup.sh (opitzconsulting#82)
• Replace broken .profile_* Envrionmentscript with ocenv (opitzconsulting#85)
• added execution of runcluvfy.sh before GridSetup.sh (opitzconsulting#82)
• added extra debug tasks with "msg: install-home-gi | Start .." before long running tasks (opitzconsulting#82)
• added support for updating opatch under 19c and 21c (opitzconsulting#98)
• added support to interpret password as hash instead of plaintext in dbpasswords by setting users[*].password_is_hash=true (opitzconsulting#81)
• ansible-lint: move to ansible-lint-action@v6.5.2 (opitzconsulting#261)
• merge ansible-oracle-modules/oc into plugins/modules (opitzconsulting#103)
• new way installing cvuqdisk.rpm in Grid-Infrastructure (opitzconsulting#82)
• ocenv: update to 2022-08-10 (#261)
• oradb-manage-db: use custom DBCA-Templates from ORACLE_HOME directly (opitzconsulting#87)
• orahost: add new attributes to host_fs_layout (opitzconsulting#96)
• oraswgi: assert OL8 and GI 19.3 without RU (opitzconsulting#84)
• oraswgi: move from package to yum for cvuqdisk.rpm (opitzconsulting#84)
• refactoring the includes for 19c and 21c (opitzconsulting#82)
• removed all check exceptions from .ansible-lint (opitzconsulting#99)
• uid/gid/passwd attribute in oracle_users/grid_users/oracle_groups is now optional (opitzconsulting#107)
• update ansible-lint for git pre-commit to v6.3.0 (opitzconsulting#99)

Breaking Changes / Porting Guide

• Ansible 2.9+ needed (opitzconsulting#99)
• moved old playbooks to playbooks folder (opitzconsulting#99)
• rename all roles with '-' in name to '_' (opitzconsulting#99)
• renamed variable for EE-Options in Binaries (opitzconsulting#99)

Removed Features (previously deprecated)

• role removed: oraasm-createdg - replaced by oraasm_manage_diskgroups (opitzconsulting#97)
• role removed: oradb-create - replaced by oradb_manage_db (opitzconsulting#97)
• role removed: oradb-delete - replaced by oradb_manage_db (opitzconsulting#97)
• role removed: oradb-failover - should be implemented in oraswgi-install -no replacement availible (opitzconsulting#97)
• role removed: oraswgi-clone - not working with current Oracle versions, no replacement availible (opitzconsulting#97)

Bugfixes

• added asmoper to oracle user in orahost (opitzconsulting#82)
• be less verbose during ansible-playbook (opitzconsulting#101)
• does not require host_fs_layout to have "disks" attribute when "configure_host_disks==false" (opitzconsulting#108)
• fixed gold image copy path (opitzconsulting#92)
• fixes a problem where oracle user home directory has been hardcoded to be under /home (opitzconsulting#93)
• make ansible-lint more happy due to new rules (opitzconsulting#94)
• make collection compatble for galaxy.ansible.com (opitzconsulting#101)
• oracle_db: Set SYSTEM password when creating a DB
• oracle_profile: make it compatible for Python3 (opitzconsulting#95)
• oradb_manage_grants & oradb_manage_users: pass container and container_data parameters to modules
• oradb_manage_statspack: Bugfix for db.state <> present
• oraswgi_install: fixed wrong script task to shell (#261)
• remove auto execution of ocenv from .bashrc (opitzconsulting#100)

Known Issues

• Problem Instance <db_unique_name> is not running during DBCA in RAC (opitzconsulting#91)
• removal of database not working when db_name <> db_instance_name (opitzconsulting#28)
• wrong ORACLE_BASE in RAC with role sepepration (#259)

ansible-oracle v2.4.0

This will be the last release before changing ansible-oracle into a collection.
This is mostly for backward compatibility, because 3.0.0 has a long list with breaking changes due to role renames.

Removed deprecated roles:

• oraasm-createdg - replaced by oraasm-manage-diskgroups
• oradb-create - replaced by oradb-manage-db
• oradb-delete - replaced by oradb-manage-db
• oradb-failover - should be implemented in oraswgi-install -no replacement availible
• oraswgi-clone - not working with current Oracle versions, no replacement availible

The following list is an incomplete list of changes:

• ansible-lint for nearly all roles
• Fixes for RAC-Setups
• assert some values from oracle_databases
• oracle_sql: fix for quoted sqldelim fixes
• old inventory: make ansible-lint happy for existing playbooks + inventory
• orahost-storage: added option nolock to dnfsoptions
• orahost_meta: New role to share defaults from role orahost
• orahost: added support for swap in host_fs_layout, fixed linter in handler
• oraswdb-install: fix for missing memory settings in systemd
• Github Actions: work on all roles
• git-pre-commit configuration
• orahost: Disable NOZEROCONF in /etc/sysconfig/network
• oraswgi-install: cleanup - removed old comments
• oraswgi-install: added runcluvfy.sh before GI/Restart configuration
• orahost: added user oracle to group asmoper
• oraswgi-install: added runcluvy.sh to role for 19c and 21c
• oraswgi-install: Refactoring Tasks for 19c+21c
• oraasm-manage-diskgroups: added support for custom oracle_asm_disk_string when asmlib is used
• oraswgi: assert OL8 and GI 19.3 without RU
• oraswgi: move from package to yum for cvuqdisk.rpm
• oradb-manage-db: use custom DBCA-Templates from ORACLE_HOME directly
• ansible-lint: lots of changes to make linting happy
• orahost: added options to host_fs_layout
• oracle_profile: Bugfix python2+3
• bugfix: gold image copy path
• bugfix hardcoded /home/oracle - use oracle_user_home
• oradb-manage-db: Replace broken .profile_* Envrionmentscript with ocenv
• single quotes for create .. identified by values - implemented check for password change for hashes - implemented check for plaintext password against S: pw hash
• added support to interpret password as hash instead of plaintext in dbpasswords by setting
• opatch: Added missing entries for 19c and 21c

ansible-oracle v1.6.6

Merge branch 'master' of github.com:oravirt/ansible-oracle

ansible-oracle v1.6.5

Merge branch 'development' of github.com:oravirt/ansible-oracle into …

ansible-oracle v1.6.4

• 18c
• New home management solution
• rdbms patching

ansible-oracle v1.6.3

Merge pull request #92 from Rendanic/prservicename

oradb-manage-*: support for service_name + listener_port

ansible-oracle v1.6.2

New role: oradb-manage-redo

ansible-oracle v1.6.1

Added ansible-oracle-modules as a submodule.

• Modules to manage: diskgroups, pdbs

Possible to customize databases after initial creation

• Modules to manage: tablespaces, users, roles, grants, services

ansible-oracle v1.6.0

Minimum Ansible version 2.1

ansible-oracle v1.5.4

Not using master_node anymore