How long can you provision database version X in the Cloud?

That’s a question I have gotten several times already: How long can you provision database version X in the Cloud? Meaning, is there a fixed date when you’ll be unable to provision an instance containing Oracle Database 12.1.0.2 for instance? How long can you provision database version X in the Cloud? First of all, it is important to note that the support time frames between on-prem and cloud are the same. But it is also important for you to notice that after a certain date you won’t be able to provision an instance with a specific database version anymore. And…

Create Multitenant databases with DBCA – Things to Know

When you create Multitenant databases with DBCA there are some Things to Know. And in Oracle Database 12.2.0.1’s Database Creation Assistant (DBCA) there is a common pitfall in the “Options” screen. It was grayed out in the previous release but when you choose to create a “custom” database you can select the options/components now. Be careful … Previous posts I did blog several times about the DBCA already: Always create databases as customer databases Use your own templates in DBCA when you create databases Does DBCA execute datapatch in Oracle Database 12.2? Create Container databases with less options And there…

Always create databases as CUSTOM databases

I’m giving this advice to customers for many years: When you create a fresh Oracle database ALWAYS create databases as CUSTOM databases. Via template or not doesn’t matter. In the DBCA better use your own and wisely configured template rather than the prebuilt (we used to call them: seed) databases. The seed databases for “Data Warehouse” and “General Purpose or Transaction Processing” have all options and components included. I use them for testing from time to time. As the upgrade duration mainly depends on the number of installed components I’d recommend to choose the components to install, and configure redo…

Why does the upgrade of PDB$SEED always take longer?

Upgrading the PDB$SEED takes always longer than any other container. What is the reason for an upgrade of the PDB$SEED taking so much longer in a real world environment? How does an upgrade with Oracle Multitenant work? I have written several blog posts in the past about the different techniques to upgrade an Oracle Multitenant environment: Upgrade Everything At Once Upgrade via Unplug/Plug/Upgrade The interesting case happens in the “Everything At Once“. The PDB$SEED takes significantly longer to upgrade than any other container. Upgrading the PDB$SEED takes always longer? Quick recap: The PDB$SEED is the (I call it) blueprint PDB…

DBUA and Read-Only Tablespaces – Things to Know II

Related Blog Posts: DBUA and Read-Only Tablespaces – Things to Know – I (Feb 3, 2016) DBUA and Read Only Tablespaces – Things to Know – II (Mar 30, 2016) DBUA displays wrong RMAN Backup for Restore (Sep 21, 2015) DBUA 12c and “datapatch.pl” – things to know (Jul 20, 2015) Thanks to Rodolfo Baselli¬†commenting on a previous blog post about the DBUA and Read-Only Tablespaces I dug a bit deeper and found out that “assuming silently” does not mean “works as intended“. But one piece after another. Rodolfo commented that if he triggers the DBUA to switch all data…

Upcoming Upgrade Workshops in Prague and Bucharest

I’ve just returned from a work intense week from Seoul, South Korea – and there are upcoming Upgrade / Migrate /Consolidate to Oracle Database 12c workshops already on my radar – and both are almost booked out completely. So if you are either based in the Prague or the Bucharest region you may quickly sign up (and show up as well) ūüôā Upgrade / Migrate / Consolidate to Oracle Database 12cWednesday, October, 7, 2015 Prague, Czech Republic @Oracle Czech Registration Link is here Upgrade / Migrate / Consolidate to Oracle Database 12cTuesday, October 13, 2015 Bucharest, Romania @Oracle Romania Registration…

Can you have Oracle Multitenant in Oracle 12.1.0.2 SE2?

Please find¬†all our articles about Oracle Database Standard Edition 12.1.0.2 SE2:   Sept 17, 2015: SE2 – Some questions, some answers Sept 8, 2015: MOS Download for Oracle SE2 Sept 7, 2015: Support and Patches for Oracle 12.1.0.1 SE/SE1 Sept 3, 2015: Can you have Multitenant with Oracle SE2? Sept 1, 2015: Oracle Standard Edition SE2 available for download     Can you have Oracle Multitenant in Oracle Standard Edition 12.1.0.2 SE2? No, you can’t as Oracle Multitenant is a licensable option for Enterprise Edition (EE) databases only. But wait a second … You can do Oracle Single Tenant with…

Ouch, this hurts: bug 17325413 – patch BEFORE upgrade!

I really don’t want to turn this blog into something making our database look bad. But in this case it is really necessary as it is VERY UNUSUAL that we recommend to patch the database BEFORE upgrade. Just for clarification: The following topic will affect all databases between 11.1.0.6 and 11.2.0.4.1 – those (and only those) need to be patched BEFORE upgrade. The topic is fixed in 12.1.0.2 but as it gets introduced with the BEFORE upgrade database version you’ll have to apply the fix before upgrade. The inclusion of the fix in 12.1.0.2 means only that the misbehavior won’t…

DBCA 12c and “datapatch.pl” – things to know

A few weeks ago I did blog about the DBUA (Database Upgrade Assistant) not executing ‘datapatch’ (i.e. not applying the SQL changes involved with a SPU/PSU/BP) automatically: DBUA 12c and “datapatch.pl” – things to know For DBUA, please note that this behavior DOES NOT APPLY to command line upgrades done with catctl.pl – as you can see from this somewhat disturbing messages¬†during the upgrade in phase 65 and phase 69¬†(which are not errors but just informational messages for datapatch’s execution): But afterwards I have learned that things are worse. The same behavior is true when you create a database. Not…

Removing Options from the Oracle Database kernel in 12c

Sometimes people have the desire to remove options from the database kernel (i.e. from the oracle executable). It’s a matter of fact that by default you’ll get plenty of things linked into your kernel in Oracle Database 12c. In case you’d like to remove things the chopt utility does still exist in Oracle Database 12c – but you may recognize a difference between Oracle 11.2 and Oracle 12.1. Anyhow, ideally you’ll do these changes before you create a database directly after the installation has been completed. See the documentation for Post Installation Tasks first: Oracle 11.2 – chopt utility options:…