ODA ODAVP RDBMS Choices and Restrictions for RDBMS Homes and Versions
Last updated on JANUARY 11, 2016
Applies to:Oracle Database Appliance Software - Version 126.96.36.199 to 188.8.131.52 [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 184.108.40.206.0 was released and supported 220.127.116.11.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 18.104.22.168.8 as well as install any previous RDBMS version provided since ODA 22.214.171.124.0. This includes any historic ODA RDBMS patchset binaries including 126.96.36.199.7, 188.8.131.52.6, 184.108.40.206.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
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 220.127.116.11 will retain ASM storage. Pre-existing 18.104.22.168.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 22.214.171.124 and higher until you are on 126.96.36.199 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 188.8.131.52 and higher you can now download and install 184.108.40.206.15 which is supported for ACFS. 220.127.116.11 and higher also supports ACFS. RDBMS versions for 18.104.22.168.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 22.214.171.124.0. Version 12.1.x GI on the ODA only supports ACFS.
ACFS is not supported on older versions of the RDBMS. The earliest version of RDBMS available on X5-2 is 126.96.36.199.x. unless you are on 188.8.131.52 and higher.
As of ODA version 184.108.40.206 and higher can use the provided ODA 220.127.116.11.15 RDBMS Clone file. This 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms