+++ Blog post updated on Oct 2, 2019 +++ New additions marked in Red +++
+++ Blog post updated on Aug 3, 2021 +++ New additions marked in Blue +++
Last week I’ve had an interesting discussion with a customer about the certification of APEX and Oracle Database 126.96.36.199.
I did a bit of research and emailing – and thanks to the APEX team – this is the source of truth for APEX certifications.
Minimum Database version for APEX
- For APEX 4.0, the minimum database version is 10.2.0.3
- For APEX 5.0, the minimum database version is 188.8.131.52
- For APEX 5.1, the minimum database version is 184.108.40.206
- For APEX 18.1, 18.2, 19.1, 20.1, 20.2 the minimum database version is 220.127.116.11
- For APEX 21.1 the minimum database version is 18.104.22.168
Minimum APEX version per Database
- For Oracle Database 11.1.0.x, the minimum APEX version is 3.0.
- For Oracle Database 11.2.0.x, the minimum APEX version is 3.2.1
- For Oracle Database 22.214.171.124, the minimum APEX version is 4.2.5
- For usage with Oracle Multitenant, APEX 4.2.3 or newer must be installed
- For Oracle Database 126.96.36.199, the minimum APEX version is 5.0.4
- For Oracle Database 18c, the minimum APEX version is 5.1.3
- For Oracle Database 19c, the minimum APEX version is 18.2
- For Oracle Database 21c, the minimum APEX version is 20.1
And remember: Never install APEX in CDB$ROOT but always in PDBs only!
Checking APEX certifications on MyOracle Support’s Certification Tab
- Go to https://support.oracle.com
- Click Certifications
- Enter Oracle Application Express as Product
- Select APEX version from the Release list, for example 5.0.4
By clicking myself through all the possible combinations I could find out that APEX 5.0.3 is not certified with Oracle Database 188.8.131.52 as are all versions below. So the minimum version of APEX for Oracle Database 184.108.40.206 is APEX 5.0.4.
Unfortunately there’s no reverse certification search in MOS available (“Which APEX version(s) does a given databases release support?”).