Deinstalling Oracle Database 12.2.0.1

This is part of a blog post series where I install Oracle 18c on-premises in our Hands-On Lab and upgrade the Multitenant 12.2.0.1 database as well. But in order to save space, deinstalling Oracle Database 12.2.0.1 is my next task. You find all the blog posts connected to each other here: Deinstalling Oracle Database 12.2.0.1 Installing Oracle Database 18.1.0  Patching Oracle 18.1.0 to 18.2.0 Upgrade Oracle 12.2.0.1 to Oracle Database 18c on-premises Deinstalling Oracle Database 12.2.0.1 In the Oracle Installation documentation you’ll find this part: Removing Oracle Database Software The documentation lists two removal options: Deinstallation with the Oracle Universal…

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…

Oracle Workspace Manager (OWM) Clean Up in Oracle Database 11.2-12.2

I have blogged about Oracle Workspace Manager (OWM) clean up in Oracle Database 11.2-12.2 just a few weeks ago: https://mikedietrichde.com/2017/06/28/uninstalling-owm-from-a-multitenant-container-database/ Yet I didn’t cover all currently supported releases from Oracle Database 11.2.0.4 to Oracle Database 12.2.0.1. Therefore as part of my “Clean Up” blog series I will repeat myself just a bit but in a consistent format. Oracle Workspace Manager (OWM) Clean Up in Oracle Database 11.2-12.2 Before you start removing anything from your database please make sure you read my introductory blog post about how to Remove and Clean Up Components from Oracle 11.2 – 12.2 . You’ll find…

Uninstalling OWM from a Multitenant container database

Caution Let me put a warning first: The intention of this blog post is NOT to recommend to uninstall anything just “because”. It is meant only as a guidance and explanation how to uninstall a component in an Oracle Multitenant container database deployment correctly without braking anything. And as this is not documented yet clearly, I bring up this blog post. Oracle Workspace Manager Oracle Workspace Manager (OWM) is a pretty cool feature of the Oracle Database. It does not require an extra license. OWM is meant to enable application developers and DBAs to manage current, proposed and historical versions…