Different database tasks automated using Ansible.
DISCLAIMER:
THE CONTRIBUTIONS IN THIS ORGANIZATION WERE NOT REVIEWED BY ORACLE EMPLOYEES. THE REPOSITORIES WERE ALSO NOT REVIEWED FOR SECURITY CONCERNS. USE AT YOUR OWN RISK.
- NOTE
! Please do modify based on your own setup. This is purely based on my own lab setup.This repository contains Ansible playbooks for Oracle Database 21c setup and management. Below are the requirements for installation:
- OS: OEL 7.5
- Ansible Version: 2.7.6
- Database Version: Oracle 21.3 Linux64
Setup Instructions:
- Download the required Oracle software from Oracle Technology Network (OTN) or My Oracle Support (MOS), depending on your support status.
- Stage the Oracle binaries from "edelivery: Oracle Database 21c Software (64-bit)".
- Follow the tasks outlined in each role for your desired configuration.
Refer to Oracle's official documentation for detailed installation and upgrade guides:
This repository includes roles for specific Oracle Database tasks. Below is a summary of the roles and their functionality:
| Role | Description |
|---|---|
| dbsoftware21c_install | Install Oracle SI database software on multiple servers. View role |
| cdb_create_21c | Deploy an empty Container Database (CDB). View role |
| pdb21c_create | Deploy a pluggable database (PDB) to an existing CDB. View role |
| sbdb21c_create | Create a physical standby database and set up Data Guard Broker. View role |
| racgi21c_install | Install Oracle Grid Infrastructure. View role |
| racdbsoft21c_install | Install Oracle RAC software. View role |
| racdb21c_create | Create a two-node RAC database. View role |
| racdb21c_patch_apply | Apply GI and database release updates for 21c (October 2021). View role |
| racgi_ss_21c_install | Configure Oracle Grid Infrastructure for a standalone server. View role |
| oracleclient21c_install | Deploy Oracle Database 21c Client for Linux x86–64. View role |
| racdb_preupgrade | Pre Upgrade script |
| racdb_upgrade | Upgrade RAC CDB Database to with one pluggable database PDB |
| racdb_predwngrade | Prep Downgrade script |
| racdb_dwngrade | Downgrade Oracle database to version using Flashback with minimum outage |
For questions related to these playbooks, feel free to contact me or open an issue in this repository.
- NOTE
! Please do modify based on your own setup. This is purely based on my own lab setup.