feauturelist.adoc

Supported feautures in ansible-oracle

Warning

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

Important

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

Table 1. Feauturelist

Group	Option	Version
OS	OracleLinux Redhat Enterprise Linux	6 [1] 7 8
	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	2.9 [9] 2.10 2.12 (used for all tests)
	Oracle RDBMS	11.2.0.3 [1] 11.2.0.4 [1] 12.1.0.2 [1] 12.2.0.1 [1] 18c [1] 19c 21c
	Oracle Grid-Infrastructure	12.1.0.2 [1] 12.2.0.1 [1] 18c [1] 19c 21c
	Oracle Restart	12.1.0.2 [1] 12.2.0.1 [1] 18c [1] 19c 21c
	cxOracle for Python	Python 2, 3
ASM	ASM Filter Driver (ASMFD)	19c (experimental! [2]) 21c (experimental! [2])
	ASMlib	12.1.0.2 [1] 12.2.0.1 [1] 18c [1] 19c 21c
	udev	[3]
Installation Options	DB Options in Binaries	12.1.0.2 [1] 12.2.0.1 [1] 18c [1] 19c 21c
	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, Restart & GI Create from Installation Install from Image	19c 21c
	readonly Homes for RDBMS
	Oracle Data-Guard	19c (planned! [5]) 21c (planned! [5])
	automatic Database Migrations	not supported
	Prepatch installations [10]
Database Management	Grants	11.2.0.3 [1] 11.2.0.4 [1] 12.1.0.2 [1] 12.2.0.1 [1] 18c [1] 19c 21c
	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	12.1.0.2 [1] 12.2.0.1 [1] 18c [1] 19c 21c
Database Patching	Release Updates[11]	12.1.0.2 [1] 12.2.0.1 [1] 18c [1] 19c 21c
	OneOff Patches[11] Install Remove with unique patch id option
	automatic datapatch execution[11]
Environment script	dynamic shell environment ocenv for Oracle	12.1.0.2 [1] 12.2.0.1 [1] 18c [1] 19c 21c

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 possivle. Please do not use it in production environments.
3	Limited support. Not tested for Oracle Restart & Grid-Infrastructure
4	2.9 is minimum version with limited support for Ansible Collections. Please use 2.10 as a minimum.
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 is based on a Collection. Ansible 2.9 has limited support for Collections. You should use 2.10 or newer.
10	Use the Golden-Image feauture as a work arround.
11	Supported for Single-Instance, Oracle Restart and Oracle Grid-Infrastructure.