Oracle APEX (Application Express) Clean Up in Oracle Database 11.2-12.2

Oracle APEX (Application Express) clean up in Oracle Database 11.2-12.2 is fairly simple and straight forward. With the upgrade to Oracle Database 12.2.0.1 Oracle APEX does not get upgraded automatically anymore. If necessary you should upgrade Oracle APEX upfront of afterwards. But please do keep an eye on the APEX certification with Oracle Database 12.2.0.1 to avoid any issues: Save Upgrade Downtime – Upgrade Oracle APEX upfront Upgrade downtime credited to APEX Is your APEX version certified with your database release? Oracle APEX (Application Express) Clean Up in Oracle Database 11.2-12.2 Before you start removing anything from your database please…

Is your APEX version certified with your Database release?

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. 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 Minimum APEX version per Database See MOS Note:1344948.1: Application Express (APEX) Database…

Use the correct download to patch APEX from 5.1.0 to 5.1.1

When you plan to upgrade Oracle Application Express (APEX) from version 5.1.0 to 5.1.1 please be aware to download a patch from MOS instead the 5.1.1 version from OTN. The text on the OTN page is a bit misleading – and a customer I work with downloaded the wrong version which led to a failed upgrade – even though the scripts seem to be made for this patch upgrade. Even though the page says “This is a cumulative patch set for Application Express 5.1.0” the page offers you a full install and not the patch for an existing APEX 5.1.0…