ODA ODAVP RDBMS Choices and Restrictions for RDBMS Homes and Versions
Last updated on JANUARY 11, 2016
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
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 22.214.171.124 will retain ASM storage. Pre-existing 126.96.36.199.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 188.8.131.52 and higher until you are on 184.108.40.206 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 220.127.116.11 and higher you can now download and install 18.104.22.168.15 which is supported for ACFS. 22.214.171.124 and higher also supports ACFS. RDBMS versions for 126.96.36.199.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 188.8.131.52.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 184.108.40.206.x. unless you are on 220.127.116.11 and higher.
As of ODA version 18.104.22.168 and higher can use the provided ODA 22.214.171.124.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