Unified Auditing policies can slow down the upgrade

I posted several blog posts about Unified Auditing in the past. And recently a large customer in the UK alerted me about their upgrades with PDBs from 12.1 to 12.2 taking much longer when Unified Auditing policies were enabled. It looks like as if Unified Auditing policies can slow down the upgrade. We did some further investigations. See the results below. Unified Auditing You find a good number of blog posts explaining how to migrate to Unified Auditing, the performance tweaks in Oracle 12.1.0.2 and some other things: Unified Auditing – Is it ON or OFF in Oracle 12.2.0.1? Unified…

Cloning with Pluggable Databases in Oracle 18c

We had several discussions on the internal mailing lists the other day about cloning with Pluggable Databases in Oracle 18c (or 12.2.0.1). And I blogged about this topic a while ago but realized I may need to refresh this a bit. My example from the old blog post still works fine. But I realized that I switched my database into read-only mode. Hence, I like to repeat it and check different options. Cloning a 12.1 PDB into Oracle 18c In the source CDB1 I create a fresh PDB first, then open it and create a cloning user with the necessary…

Oracle Label Security (OLS) Clean Up in Oracle Database 11.2-12.2

Oracle Label Security (OLS) clean up in Oracle Database 11.2-12.2 is almost as simple and straight forward as removing OWM or APEX. You can do it online without downtime. But in older releases a relink operation did cause downtime. Oracle Label Security is an extra cost option. More information is available on oracle.com. Oracle Label Security (OLS) Clean Up in Oracle Database 11.2-12.2 Oracle Label Security is dependent on Oracle Database Vault (DV). In case DV is present you must remove it first if you plan to remove Oracle Label Security. Before you start removing anything from your database please…

Non-CDB architecture still exists in Oracle Database 12.2.

I received a question whether the Non-CDB architecture still exists in Oracle Database 12.2.from 3 different colleagues in the past week: “Does Oracle Database 12.2 still allow us to create non-CDB databases?” And as I get this question at every customer-facing workshop these days as well before being able to talk about Single/Multitenant – I think it is important to clarify it. The statement is misleading. And I can’t blame anybody about misreading it. Is the non-CDB architecture still available/supported in Oracle Database 12.2? I did blog about it a while ago – but Google is not always your friend…

Upgrade to Oracle Database 12.2 – New MOS Notes

Some very helpful MOS Notes got published regarding the upgrade to Oracle Database 12.2.0.1: MOS Note: 2173141.1 Complete Checklist for Manual Upgrades to non-CDB Oracle Database 12.2 MOS Note: 2173144.1 Complete Checklist for Manual Upgrade for Multitenant Architecture Oracle Databases from 12.1. to 12.2. MOS Note: 2189854.1 Complete Checklist for Upgrading to Oracle Database 12.2 using DBUA Furthermore check regularly for Known Issues and Alerts – currently the note has no content but exists already: MOS Note: 2239820.1 12.2.0.1 Base Release – Availability and Known Issues Cheers –Mike

Non-CDB architecture of Oracle databases is DEPRECATED since Oracle Database 12.1.0.2

Please find an updated blog post here: https://mikedietrichde.com/2015/09/04/oracle-non-cdb-architecture-may-be-desupported-after-oracle-database-12-2/ https://mikedietrichde.com/2017/03/14/non-cdb-still-exists-in-oracle-database-12-2-oracle-18-oracle-19/ as the text in the Database Upgrade Guide has been changed as well. See the Oracle Database 12.1.0.2 Upgrade Guide: https://docs.oracle.com/database/121/UPGRD/deprecated.htm#BABDBCJI — What does this mean? Deprecation first of all does not mean “desupported”. It means in this case that you of course can have still stand-alone Oracle databases as you know the architecture from previous releases. But you can also have a single-tenant deployment (a CDB with one PDB – no Multitenant license required) or multitenant databases (a CDB with up to 252 PDBs – Multitenant Option license required). But…

New MOS Notes on Database Upgrades for 12c with or without Oracle Multitenant

Please find some new MyOracle Support (MOS) Notes about Database Upgrades to Oracle Database 12c, with or without Oracle Multitenant: MOS Note: 1503653.1 Complete Checklist for Manual Upgrades to Oracle Database 12c Release 1 (12.1) . MOS Note: 1932762.1 Complete checklist for manual upgrade from 12.1.0.1 to 12.1.0.N (Full CDB Upgrade) . MOS Note: 1933391.1 Complete checklist for 12c R1 PDB upgrade (Upgrading single/multiple PDB) . MOS Note: 1932340.1 How to execute sql scripts in Multitenant environment (catcon.pl) . MOS Note: 1933011.1 Complete Checklist for DBUA Upgrade from 12.1.0.1 to 12.1.0.N . Credits for the CDB/PDB Notes go to my colleague, Krishnakumar Kunka  🙂 -Mike