Be aware of database options selections for PDBs in DBCA

I did blog about several things-to-know with DBCA (Database Configuration Assistant) in the past. And one issue came up in our internal mailing list the other day. Be aware of database options selections for PDBs in DBCA. Missing one or the other “click” may bring you in trouble later on. I blogged about this already a while ago but this was only part of a larger post: Create Multitenant Databases with DBCA – Things to Know. Be aware of database options selections for PDBs in DBCA When you create a custom container database with DBCA you will see this screen….

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…

APEX is in CDB$ROOT again – Journey to the Cloud VII

Well … it’s been a while … but I would like to continue my journey to the cloud … What happened so far on my Journey to the Cloud? Part I – Push a Button (Dec 3, 2015) Part II – Switch On/Off and Remove (Dec 4, 2015) Part III – Patch, patch, patch (Dec 22, 2015) Part IV – Clean Up APEX (Jan 19, 2016) Part V – TDE is wonderful (Jan 28, 2016) Part VI – Patching does not work (Apr 18, 2016) You are here ==> Part VII – APEX is in CDB$ROOT again (Dec 21, 2016) Oracle Database…

Clean up APEX – Journey to the Cloud IV

What happened so far on my Journey to the Cloud? Part I – Push a Button (Dec 3, 2015) Part II – Switch On/Off and Remove (Dec 4, 2015) Part III – Patch, patch, patch (Dec 22, 2015) You are here! ==> Part IV – Clean Up APEX (Jan 19, 2016) Part V – TDE is wonderful (Jan 28, 2016) Part VI – Patching does not work (Apr 18, 2016) Part VII – APEX is in CDB$ROOT again (Dec 21, 2016) Today’s journey: Cleanup APEX removal leftovers  When you read my “Patch” blog post from Dec 22, 2015 you’ll see that I…

Upgrade downtime credited to APEX

What do you think when you see this post-upgrade result? Oracle Database 12.1 Post-Upgrade Status Tool 08-07-2015 15:08:26 Component Current Version Elapsed Time Name Status Number HH:MM:SS Oracle Server UPGRADED 12.1.0.2.0 00:19:26 JServer JAVA Virtual Machine VALID 12.1.0.2.0 00:10:52 Oracle Workspace Manager VALID 12.1.0.2.0 00:01:52 OLAP Analytic Workspace VALID 12.1.0.2.0 00:00:34 OLAP Catalog OPTION OFF 11.2.0.3.0 00:00:00 Oracle OLAP API VALID 12.1.0.2.0 00:00:42 Oracle XDK VALID 12.1.0.2.0 00:01:07 Oracle Text VALID 12.1.0.2.0 00:01:36 Oracle XML Database VALID 12.1.0.2.0 00:03:55 Oracle Database Java Packages VALID 12.1.0.2.0 00:00:22 Oracle Multimedia VALID 12.1.0.2.0 00:03:57 Spatial UPGRADED 12.1.0.2.0 00:08:56 Oracle Application Express VALID 4.2.5.00.08…

Java in the database – OJVM non-rolling patches – OJVM Removal

Question: How can I find out if Oracle’s JVM is used in my database? Answer: This is unfortunately not as trivial as I thought initially … Let’s start with: MOS Note:397770.1 Until Oracle version 11.2 or later, there was no way to confirm if Oracle JVM is not actively used in the database.  However, what can be said is: 1) If there are non-Oracle schemas that contain java objects, then 3rd party products or user defined java programs could be actively using the Oracle JVM. 2) If there are Oracle schemas, other than SYS, that contain java objects, then other Oracle products or Oracle Applications could be actively using…

Save Upgrade downtime: Upgrade APEX upfront

See also: Upgrade downtime credited to APEX With almost every patch or release upgrade of the Oracle Database a new version of Oracle Application Express (APEX) will be installed. And as APEX is part of the database installation it will be upgraded as part of the component upgrades after the ORACLE SERVER component has been successfully upgraded to the new releases. But the APEX upgrade can take a bit (several minutes or even more in some cases). Therefore it is a common advice to upgrade APEX upfront before upgrading the database as this can be done online while the database…