ODA ODAVP RDBMS Choices and Restrictions for RDBMS Homes and Versions
(Doc ID 1670474.1)
Last updated on JANUARY 31, 2020
Applies to:Oracle Database Appliance Software - Version 184.108.40.206 to 220.127.116.11 [Release 2.9 to 12.1]
Oracle Database Appliance - Version All Versions to All Versions [Release All Releases]
Oracle Database Appliance X3-2 - Version All Versions to All Versions [Release All Releases]
Oracle Database Appliance X4-2 - Version All Versions to All Versions [Release All Releases]
Information in this document applies to any platform.
The ODA does not use generic RDBMS patchsets or PSUs.
- The ODA uses unique patched RDBMS versions tested and released with the ODA patch bundle (Infra/GI/RDBMS), End User Bundle (EUB) or as an independent RDBMS CLONE.
- Originally ODA 18.104.22.168.0 was released and supported 22.214.171.124.x and higher versions. However, ODA installations were limited to the default ODA RDBMS patched version provided and future patched versions which could be used as upgrades.
- Any ODA provided RDBMS patched versions that pre-existed the originally ODA version used were not supported until 2.8.
- From 2.8 to 2.10 any existing ODA patched RDBMS version could be installed on the ODA.
ODA 2.9 has the option of installing provided RDBMS patched 126.96.36.199.8 as well as install any previous RDBMS version provided since ODA 188.8.131.52.0. This includes any historic ODA RDBMS patchset binaries including 184.108.40.206.7, 220.127.116.11.6, 18.104.22.168.x and so on. A la carte choices of older RDBMS versions would hold true between 2.9 and 2.10.
However, upgrading or installing ODA 12.1.x changes RDBMS version availability
NOTE: The information in this note is not current and does not discuss the following Hardware or ODA Versions
- 22.214.171.124 or higher including any 12.2
- Any X6-2 hardware version including X6-2 HA, X6-2 S/M/L
- Any X7-2 hardware version including X7-2 HA, X7-2 S/M
- Any versions
As of ODA 12.1.x there are two notable changes in RDBMS availability.
For X4-2, X3-2 and V1 you can continue to use any existing and installed RDBMS versions that exist before upgrading to ODA 12.1.x.
However, once you are upgrading or re-installing (Bare metal) 12.1.x you must create any new databases using ACFS as the storage option.
Pre-existing databases below 126.96.36.199 will retain ASM storage. Pre-existing 188.8.131.52.x databases will allow migrating to ACFS or retaining ASM.
Any NEW databases as of 12.1.x ODA can only be created using ACFS storage. This is not optional.
As of ODA 12.1.x and higher the only allowed new RDBMS homes allowed are 184.108.40.206 and higher until you are on 220.127.116.11 and higher.
The reason is that all new databases created 12.1.x and higher default to using only ACFS on top of ASM. ASM only is not an option for new databases.
IF you are on 18.104.22.168 and higher you can now download and install 22.214.171.124.15 which is supported for ACFS. 126.96.36.199 and higher also supports ACFS. RDBMS versions for 188.8.131.52.x does _not_support ACFS.
However, if upgrading from 2.10 or lower any RDBMS versions installed prior to the 12.x upgrade would also be supported and continue to work.
The lowest version the X5-2 comes with is 184.108.40.206.0. Version 12.1.x GI on the ODA only supports ACFS (until 220.127.116.11 and higher)
ACFS is not supported on versions of the ODA on 2.10 and / or the GI at 18.104.22.168.x .
Originally the earliest version of RDBMS available on X5-2 was 22.214.171.124.x. unless you are on 126.96.36.199 and higher.
As of ODA version 188.8.131.52 and higher can use a specific ODA 184.108.40.206.15 provided RDBMS Clone file.
This RDBMS Clone file can be downloaded from My Oracle Support ( MOS ) or via links found in note 888888.1.
One frequently asked question is installing RDBMS versions on a Virtualized image.
Although Virtualized RDBMS versions can be installed in ODAVP [ODA Virtualized Platform], performance will not be equivalent to ODA RDBMS versions installed on ODA_BASE.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!