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).
Table 1. Featurelist
Group Option Version

OS

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
1

Was supported by ansible-oracle. It is not tested anymore.
2

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.
3

Limited support. Not tested for Oracle Restart and Grid Infrastructure.
4

Only tested with PDB on 19c+. May be work in nonCDB as well but noch in CDB.
5

in development and not implemented at the moment.
6

Not working in Real Application Cluster Setups
7

Limited to Parameter with SID="*"
8

only create/drop PDB
9

ansible-oracle 5.x supports ansible-core 2.16 - 2.19.
ansible-oracle 4.2 - 4.x supports ansible-core 2.14 - 2.18.
10

Use the Golden-Image feature as a workaround.
11

Supported for Single Instance databases without and with Oracle Restart. Not tested with Grid Infrastructure (cluster).
12

Source CDB (old release) and target CDB (new release) must run on the same host. See Upgrade of PDBs with AutoUpgrade.
13

Single Instance databases without Oracle Restart and without Grid Infrastructure only. Not supported for Oracle Restart, Grid Infrastructure (cluster), RAC and RAC One Node.
14

Single Instance primary databases without and with Oracle Restart. Not supported for Grid Infrastructure (cluster), RAC and RAC One Node.
15

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.
16

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.
Last modified November 13, 2026: oraswgi_install: Out-of-Place Patching of Grid Infrastructure (cluster) (c13a454c)