This is the multi-page printable view of this section. Click here to print.

Return to the regular view of this page.

Features

1: Supported features in ansible-oracle

1 - Supported features in ansible-oracle

Warning

Please check the official Compatibility List from Oracle for RDBMS, Oracle Restart and Grid Infrastructure.
ansible-oracle only supports combinations from Oracle with exceptions from the following table.

Important

As of ansible-oracle 5.0 only Oracle 19c and 26ai are supported for RDBMS. Installation and tests are done for Single Instance databases without and with Oracle Restart.
Grid Infrastructure 26ai for a Cluster is supported (tested with a RAC database 26ai).
Older releases (11.2, 12.1, 12.2, 18c, 21c) are rejected by the assert of db_homes_config, see Breaking Changes - Upgrade Guide.

Note

The number of combinations of options is huge (operating system, Oracle release, Edition, Single Instance / Oracle Restart / Grid Infrastructure, device persistence for ASM, file system or ASM, …). Only a few combinations are tested by the molecule scenarios of ansible-oracle.
All other combinations should work, as long as they are not explicitly excluded in this list and are supported by Oracle. Not tested means: not covered by an automated test, it does not mean does not work.

Important

All Editions from Oracle are supported. See documentation from Oracle for differences between Enterprise and Standard Edition (SE, SE One and SE2)

Note

Terms used in this document:
Oracle Restart: Grid Infrastructure for a Standalone Server (oracle_install_option_gi: HA_CONFIG), Single Instance databases with ASM on one host.
Grid Infrastructure: Grid Infrastructure for a Cluster (oracle_install_option_gi: CRS_CONFIG).
RAC (Real Application Clusters) and RAC One Node need Grid Infrastructure.
Both Oracle Restart and Grid Infrastructure use the software of Grid Infrastructure (oracle_home_gi).

Group Option Version

OracleLinux
Redhat Enterprise Linux

6 ^[1]
7 ^[1]
8
9

SuSE Linux Enterprise Server^[3]

15, 15.3

Management of LVM, Filesystems and swap

all versions of all OS

ntp & chrony

all versions of all OS

custom motd (message of the day)

all versions of all OS

Software

Ansible

ansible-core 2.16 - 2.19 ^[9]

Oracle RDBMS

19c
26ai

Oracle Grid Infrastructure (cluster)

26ai ^[16]

Oracle Restart

19c
26ai

python-oracledb

Python 3

ASM

ASM Filter Driver (ASMFD)

19c

ASMlib

19c

udev

^[3]

Installation Options

DB Options in Binaries

19c
26ai

Statspack for nonCDB, CDB and PDB

RMAN Backup with

cron management in /etc/cron.d
Catalog
Oracle-Wallet for Connection
checkmk mk_job monitoring
custom RMAN-scripts

dNFS (direct NFS)

Golden Image for RDBMS and Grid Infrastructure software (Oracle Restart)

Create from Installation
Install from Image

19c
26ai

readonly Homes for RDBMS

Oracle Data Guard: physical standby databases with Data Guard Broker (Standby Databases, experimental! ^[2]) ^[13]

19c
26ai

Database Migrations: Upgrade of PDBs with AutoUpgrade (Unplug/Plug, experimental! ^[2]) ^[12]

19c ⇒ 26ai

Prepatch installations ^[10]

not supported

Database Management

Grants

19c
26ai

init.ora Parameter ^[7])

possibility to set Parameters after DBCA execution

Pluggable Database Management ^[8]

Database Profiles

Redolog Groups ^[6]

Database Roles

Database Services ^[3]

Tablespaces

Users

Scripts with SQLPlus

Custom DBCA-Templates

Define Characterset during DBCA

Enable/Disable Archivelogmode & FRA

Timezone Upgrades

19c
26ai

Database Patching

Release Updates^[11]

19c
26ai

OneOff Patches^[11]

Install
Remove with unique patch id option

automatic datapatch execution^[11]

Patch Download from Oracle

Out-of-Place Patching: switch of a database into another ORACLE_HOME ^[14]

19c
26ai

Out-of-Place Patching of Oracle Restart and Grid Infrastructure: switch of the Grid Infrastructure home ^[15]

26ai

Oracle APEX (experimental!)

Installation of APEX in PDB. Not supported for CDB or nonCDB.

19c
26ai

Oracle AutoUpgrade (experimental! ^[2])

AutoUpgrade with role autoupgrade

Installation and update of autoupgrade.jar on database server or Ansible controller
Keystore for My Oracle Support
Download of patches and gold images from My Oracle Support
Unplug/Plug upgrade of PDBs (analyze, fixups, deploy) ^[12]
Patching with AutoUpgrade is not implemented

Download: 19c, 21c, 23ai, 26ai
Upgrade: 19c ⇒ 26ai

Oracle Autonomous Health Framework (under development, experimental!)

AHF with roles ahf and ahf_fleet_insights

Important

Under development and experimental. Breaking changes can happen at any time and are not always documented.

Installation and upgrade of AHF (root or non-root)
Activation of TFA daemon and Compliance scheduler, settings for TFA and orachk
Central web interface with AHF Fleet Insights and registration of the clients

19c
26ai

Environment script

dynamic shell environment ocenv for Oracle

19c
26ai

Footnotes

¹	Was supported by `ansible-oracle`. It is not tested anymore.
²	Still in development and not fully tested at the moment. Breaking changes in new commits are possible. Please do not use this feature in production environments.
³	Limited support. Not tested for Oracle Restart and Grid Infrastructure.
⁴	Only tested with PDB on 19c+. May be work in nonCDB as well but noch in CDB.
⁵	in development and not implemented at the moment.
⁶	Not working in Real Application Cluster Setups
⁷	Limited to Parameter with SID="*"
⁸	only create/drop PDB
⁹	`ansible-oracle` 5.x supports ansible-core 2.16 - 2.19. `ansible-oracle` 4.2 - 4.x supports ansible-core 2.14 - 2.18.
¹⁰	Use the Golden-Image feature as a workaround.
¹¹	Supported for Single Instance databases without and with Oracle Restart. Not tested with Grid Infrastructure (cluster).
¹²	Source CDB (old release) and target CDB (new release) must run on the same host. See Upgrade of PDBs with AutoUpgrade.
¹³	Single Instance databases without Oracle Restart and without Grid Infrastructure only. Not supported for Oracle Restart, Grid Infrastructure (cluster), RAC and RAC One Node.
¹⁴	Single Instance primary databases without and with Oracle Restart. Not supported for Grid Infrastructure (cluster), RAC and RAC One Node.
¹⁵	Oracle Restart and Grid Infrastructure (cluster) 26ai (`gridSetup.sh -switchGridHome`, cluster: `root.sh` rolling), inside the same release (e.g. 23.26.3 ⇒ 23.26.4). Not supported for 19c. Grid Infrastructure (cluster): no switch back into a former home.
¹⁶	Tested with Grid Infrastructure 26ai on 2 nodes and a RAC database 26ai (molecule scenario `rac`), see Oracle Restart and Grid Infrastructure. Grid Infrastructure 19c, RAC databases 19c and RAC One Node are not tested.