# ansible-power-aix-oracle-dba

**Repository Path**: mirrors_ibm/ansible-power-aix-oracle-dba

## Basic Information

- **Project Name**: ansible-power-aix-oracle-dba
- **Description**: Automate Administration Tasks of Oracle DB on AIX
- **Primary Language**: Unknown
- **License**: Apache-2.0
- **Default Branch**: main
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2022-06-30
- **Last Updated**: 2025-08-09

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

# PowerODBA Ansible Collection

Overview: The Power Oracle Database Automation (PowerODBA) Collection modules are based on the Oravirt collection https://github.com/oravirt/ansible-oracle which automates Oracle Database Administration activities on AIX. These have been modified and tested exclusively to work on AIX.

Following functionalities can be achieved with this collection.

- Database creation [Single Instance/RAC & Multitenant]
- Apply RU Patches [Standalone DB/Database on ASM & RAC]
- Manage Users [Create/drop users, grant/revoke privileges]
- Manage Pluggable databases
- Manage Tablespaces
- Manage Redo logs
- Manage Database directories.
- Manage ASM
- Manage ACFS
- Manage DBMS jobs
- Single Instance Grid Infrastructure and Database Upgrade from 12c to 19c
- RAC Grid Infrastructure and Database Upgrade from 12c to 19c
- Introduced Dataguard feature for single instance database using RMAN Backup and RMAN DUPLICATE method

Version Change:

PODBA v2.0.8

- Refactored oradb_create role for integration with Oracle SI ansible collection.

PODBA v2.0.7

- Introduced Dataguard feature for single instance database using RMAN Backup and RMAN DUPLICATE method.

PODBA v2.0.6

- Introduced RAC Grid Infrastructure and Database Upgrade from 12c to 19c.

PODBA v2.0.5

- Latest RU patches can be applied during the upgrade to 19c. Previously it was restricted till RU 19.17.
- Introduced patch staging options – NFS, local (target node) and remote (ansible controller) for Single Instance Upgrade.

PODBA v2.0.4
- Enhanced the role "oraswdb_manage_patches" patching module to restart DB and listener services. While using "opatch" utility, the DB and listener servies of the Oracle home will be stopped before patching and started post patching.
- Introduced patch staging options – NFS, local (target node) and remote (ansible controller) for patching module.
- The role "orasw_download_patches" has been tested to download EBS patches as well.

PODBA v2.0.3
- Introduced a common path to place the variable files for all the playbooks. 
- Refined existing documentation.
- New documentation to execute playbooks from AAP2 GUI.

PODBA v2.0.2
- Upgrade Oracle 12c Single Instance Grid Infrastructure & Multiple Databases to Oracle 19c.

PODBA v2.0.1
- Download Patches from My Oracle Support.

PODBA v2.0.0
- Upgrade Oracle 12c Single Instance Grid Infrastructure & Databases to Oracle 19c.

PODBA v1.0.0
- Base release

# Documentation:

- Instructions to get started with this collection can be found here: https://github.com/IBM/ansible-power-aix-oracle-dba/blob/main/docs/PowerODBA_Ansible_Collection.pdf
- Readmes for each capability can be found here: https://github.com/IBM/ansible-power-aix-oracle-dba/blob/main/docs

# Executing PowerODBA collection using Ansible Automation Platform 2 (AAP2)

- Readme: https://github.com/IBM/ansible-power-aix-oracle-dba/blob/main/docs/PowerODBA_using_AAP2.pdf