Is your APEX version certified with your Database release?

+++ 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 12.2.0.1.

I did a bit of research and emailing – and thanks to the APEX team – this is the source of truth for APEX certifications.

Is your APEX version certified with your Database release?

Minimum Database version for APEX

See MOS Note:1344948.1: Application Express (APEX) Database and Web Server Certification Reference:

  • For APEX 4.0, the minimum database version is 10.2.0.3
  • For APEX 5.0, the minimum database version is 11.1.0.7
  • For APEX 5.1, the minimum database version is 11.2.0.4
  • For APEX 18.1, 18.2, 19.1, 20.1, 20.2 the minimum database version is 11.2.0.4
  • For APEX 21.1 the minimum database version is 12.1.0.2

Minimum APEX version per Database

See MOS Note:1344948.1: Application Express (APEX) Database and Web Server Certification Reference:

  • 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 12.1.0.2, 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 12.2.0.1, 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

  1. Go to https://support.oracle.com
  2. Click Certifications
  3. Enter Oracle Application Express as Product
  4. Select APEX version from the Release list, for example 5.0.4
Oracle APEX - Certification MOS

Oracle APEX Certification in MyOracle Support

By clicking myself through all the possible combinations I could find out that APEX 5.0.3 is not certified with Oracle Database 12.2.0.1 as are all versions below. So the minimum version of APEX for Oracle Database 12.2.0.1 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?”).

–Mike

Share this: