Removal

Deinstalling Oracle Database 12.2.0.1

Posted on June 19, 2018 by Mike.Dietrich Removal 8

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

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

XDB Clean Up in Oracle Database 11.2-12.2

Posted on August 8, 2017 by Mike.Dietrich Removal 2

XDB Clean Up in Oracle Database 11.2-12.2 will apply to Oracle Database 11.2.0.x only as XDB became a mandatory component since Oracle Database 12.1.0.1. You can’t have an Oracle 12c database without XDB. Therefore the following blog post won’t explain how to clean up XDB from an Oracle 12c database. It explains only briefly the case before Oracle Database 12c.

XDB Clean Up in Oracle Database 11.2-12.2

XDB Clean Up in Oracle Database 11.2-12.2 Oracle XML DB provides full support for all of the key XML standards, including XML, Namespaces, DOM, XQuery, SQL/XML and XSLT. By providing full support for XML standards, Oracle XML DB …

JAVAVM and XML Clean Up in Oracle Database 11.2-19c

Posted on August 7, 2017 by Mike.Dietrich JVM Removal 25

JAVAVM and XML clean up in Oracle Database 11.2-19c is a tough topic. Many have suffered from the rolling patch upgrade issues with the OJVM (Oracle Java Virtual Machine) even though most of the issues have been cured with the recent patches.

Please see my previous blog posts starting here:

And please see also this very important MOS Note: 2217053.1 – RAC Rolling Install Process for the “Oracle JavaVM Component Database …

Enterprise Manager (EM) Clean Up in Oracle Database 11.2-12.2

Posted on August 5, 2017 by Mike.Dietrich Enterprise Manager Removal 0

Enterprise Manager (EM) clean up in Oracle Database 11.2-12.2 is targeting Enterprise Manager Database Control only. EM DB Control does not exist anymore since Oracle Database 12c and got replaced by EM Express, a light-weight EM.

Enterprise Manager (EM) Clean Up in Oracle Database 11.2-12.2

Enterprise Manager (EM) Clean Up in Oracle Database 11.2-12.2 As Enterprise Manager Database Control gets replaced by EM Express since Oracle Database 12.1.0.1 its repository must be removed when upgrading to Oracle Database 12c or later. The following MOS Notes offer plenty of information:

Expression Filter and Rules Manager (EXF, RUL) Clean Up in Oracle Database 11.2-12.2

Posted on August 4, 2017 by Mike.Dietrich Removal 5

Oracle Expression Filter and Rules Manager (EXF, RUL) clean up in Oracle Database 11.2-12.2 is very simple and straight forward. One script, and several seconds later EXF and RUL are cleaned up. Both options require JAVA to be installed into the database. But their removal doesn’t do anything to JAVA.

Expression Filter and Rules Manager (EXF, RUL) Clean Up in Oracle Database 11.2-12.2

Expression Filter and Rules Manager are obsolete since Oracle Database 12c. You’ll find the official statement in MOS Note: 1233535.1 – Obsolescence Notice: Rules Manager and Expression Filter Features of Oracle Database.

Before you start …

Oracle Warehouse Builder (OWB) Clean Up in Oracle Database 11.2-12.2

Posted on August 3, 2017 by Mike.Dietrich Removal 14

Oracle Warehouse Builder (OWB) clean up in Oracle Database 11.2-12.2 is very simple and straight forward. There’s only one script to execute. And it completes flawless and does not require any workarounds.

Oracle Warehouse Builder (OWB) Clean Up in Oracle Database 11.2-12.2

The Oracle Warehouse Builder actually does come automatically installed until Oracle Database 11.2. OWB is a data warehousing-centered data integration solution. It got replaced by ODI in later released.For more information on OWB click here. You may have to license certain parts of OWB.

Oracle Warehouse Builder (OWB) Clean Up in Oracle Database 11.2-12.2 According to Oracle Data Integrator and Oracle Warehouse Builder Statement …

Oracle OLAP (XOQ, APS, AMD) Clean Up in Oracle Database 11.2-19c

Posted on August 2, 2017 by Mike.Dietrich Removal 30

Oracle OLAP (XOQ, APS, AMD) Clean Up in Oracle Database 11.2-12.2

Oracle OLAP (XOQ, APS, AMD) Clean Up in Oracle Database 11.2-19c requires recompilation and some workarounds in most releases. Nevertheless, I’m documenting the removal steps for all 3 OLAP parts:

XOQ – OLAP API
APS – OLAP Analytical Workspace
AMD – OLAP Catalog

Again, let me emphasize that none of these blog posts is meant to recommend the removal of any component. It is just meant to explain procedures and workarounds as I sometimes face the situation to remove a component from a database.

Oracle OLAP (XOQ, APS, AMD) Clean Up in Oracle Database 11.2-19c

Oracle OLAP (XOQ, APS, AMD) Clean Up in Oracle Database 11.2-12.2 Even though a lot of …

Oracle Multimedia (ORDIM) Clean Up in Oracle Database 11.2-12.2

Posted on August 1, 2017 by Mike.Dietrich Removal 26

Oracle Multimedia (ORDIM) clean up in Oracle Database 11.2-12.2 is not complicated especially as the removal script checks for the usage of the option first.

Oracle Multimedia (ORDIM) Clean Up in Oracle Database 11.2-12.2

Oracle Multimedia (ORDIM) Clean Up in Oracle Database 11.2-12.2 Please be aware that Oracle Spatial (SDO) depends on Oracle Multimedia. Therefore, when you remove Oracle Multimedia then Oracle Spatial will be removed as well.

Oracle Multimedia was called “Intermedia” in earlier releases. It integrates multimedia data with enterprise information stored in Oracle Database. Multimedia data can be stored, managed and retrieved with SQL, PL/SQL and Java in the same way as standard relational data. …

Oracle Text (CONTEXT) Clean Up in Oracle Database 11.2-19c

Posted on July 31, 2017 by Mike.Dietrich Removal 5

Oracle Spatial (SDO) Clean Up in Oracle Database 11.2-12.2 Oracle Text (CONTEXT) clean up in Oracle Database 11.2-19c is an interesting topic. A removal script exists but some additional tasks may be necessary depending on the database release.

Oracle Text (CONTEXT) Clean Up in Oracle Database 11.2-19c

Oracle Text (CONTEXT) Clean Up in Oracle Database 11.2-12.2 Oracle Text (formerly known as Context Option) is a excellent feature a lot of people using actively. You can access all the necessary resources on OTN.

Oracle Text uses standard SQL to index, search, and analyze text and documents stored in the Oracle database, in files, and on the web. Oracle Text can perform linguistic analysis on documents, as well as …

Oracle Spatial (SDO) Clean Up in Oracle Database 11.2-19c

Posted on July 30, 2017 by Mike.Dietrich Removal 27

Oracle Spatial (SDO) clean up in Oracle Database 11.2-19c is mostly straight forward. You can do it with the database up and running in Oracle Database 12c. Nevertheless it is very important that you check beforehand if Spatial and/or Graph are in use.

Be positively aware:
Since December 5, 2019, Oracle Spatial and Graph are both included automatically in all database licenses back to Oracle 11.2.0.4, for EE as well as for SE2. Generally. Read more here: https://mikedietrichde.com/2019/12/06/great-license-news-spatial-and-graph-machine-learning/

Oracle Spatial (SDO) Clean Up in Oracle Database 11.2-19c

Oracle Spatial (SDO) Clean Up in Oracle Database 11.2-12.2 Oracle Spatial (formerly known as Spatial Data Option) and Graph …

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

Posted on July 29, 2017 by Mike.Dietrich Removal 22

Oracle Label Security (OLS) clean up in Oracle Database 11.2-19c 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-19c

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 …

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

Posted on July 28, 2017 by Mike.Dietrich Removal 13

I have blogged about Oracle Workspace Manager (OWM) clean up in Oracle Database 11.2-19c 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-19c

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 – 19c . You’ll find …

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

Posted on July 27, 2017 by Mike.Dietrich APEX Removal 17

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:

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

Before you start removing anything from your database please …

Remove and Clean Up Components from Oracle Database 11.2 – 19c

Posted on July 26, 2017 by Mike.Dietrich Removal 28

Remove and Clean Up Components - Oracle 11.2 - 12.2

I will start a series of blog posts on how to remove and clean up components from Oracle Database 11.2 – 19c.

Precaution

This series of blog posts is not meant to recommend the removal of any options from an Oracle Database. It is not meant to create any sort of negativeness on any of the components or options. It’s is only meant to give you some advice and guideline in the case you’ll need to remove something.

The OUI (Oracle Universal Installer) installed everything on disk – and there’s a very good reason to do this. The purpose of …

Uninstalling OWM from a Multitenant container database

Posted on June 28, 2017 by Mike.Dietrich Removal Single-/Multitenant 3

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

Workspace Tree

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 …

Remove components from Oracle’s kernel with chopt

Posted on February 23, 2017 by Mike.Dietrich Removal 6

Remove components from Oracle's kernel with chopt

I’ve had an interesting discussion today. Somebody removed OLAP with chopt – and got issues afterwards. My guess: chopt will only remove the binary option and is meant to be used before a database got created. But if you use it afterwards you’ll have to make sure to remove the dictionary components as well.

A while back a blogged about chopt already:

Removing Options from the Oracle Database kernel in 12c

And there are some helpful Support Notes out there:

(KB135195) How to Check and Enable/Disable Oracle Binary Options ?

This note WILL NOT address product specific scripts that are

Clean up APEX – Journey to the Cloud IV

Posted on January 19, 2016 by Mike.Dietrich APEX Cloud Removal 3

What happened so far on my Journey to the Cloud?

Today’s journey: Cleanup APEX removal leftovers

When you read my “Patch” blog post from Dec 22, 2015 you’ll see

Switch on/off + Remove – Journey to the Oracle Cloud – II

Posted on December 4, 2015 by Mike.Dietrich Cloud Removal 6

What happened so far on my Journey to the Cloud?

Day 2 of my Cloud exploration journey.

In my blog posts about my DBaaS Cloud journey I won’t explain …

What or who is JOX? And what happens if …

Posted on December 2, 2015 by Mike.Dietrich Removal 2

Are you worried because of the title of this blog post? Don’t worry … it will be about the Oracle database and not about miraculous additives.

Months back I wrote about how to remove options from the Oracle database’s kernel by either using chopt or linking options off:

Removing Options from the Oracle Database kernel in 12c

Recently a very interesting case was logged in relation to a bug:
A customer had linked off the JOX option from the database kernel.
.

What is JOX?

Well, do a quick search for “JOX” in the Oracle Documentation and …

Why you should remove APEX from the CDB$ROOT

Posted on November 19, 2015 by Mike.Dietrich APEX Removal Single-/Multitenant 11

Upgrade Blog posts about Oracle Application Express:

Oracle APEX (Application Express) is great piece of software. But it gets installed by default into the container database’s CDB$ROOT unless you’d customized your CDB creation via scripts in Oracle 12.1.0.2. See:

Create Container Databases (CDB) with less options – it’s now supported in Oracle 12.1.0.2

on how to customize a Single/Multitenant Database with less options.

But that is not the topic I …

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

Posted on June 22, 2015 by Mike.Dietrich JVM Removal 30

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

Removing Options from the Oracle Database kernel in 12c

Posted on May 27, 2015 by Mike.Dietrich Removal 5

Remove Options from the Oracle Database Kernel - chopt

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

Rules Manager and Expression Filter getting removed

Posted on November 12, 2012 by Mike.Dietrich Removal 1

I doubt that many people are using the Oracle features “Rules Manager” and “Expression Filter” as usually people handle these things (such as ensuring that a zip code or a car number plate has a certain format) within the application code and not inside the database. Oracle Beehive for instance uses that just on the side.

Anyway, just learned today that Rules Manager and Expression Filter components will get removed once our next database release most likely called Oracle Database 12c will get released. So before upgrading to Oracle Database 12c you can remove EXF and …

Database Registry: Component Dependencies

Posted on July 4, 2011 by Mike.Dietrich Removal 4

Recently I had to dig a bit into the component dependency topic as I was working with an Oracle Database 10.1.0.5 customer planning to upgrade to Oracle Database 11.2.0.2 with a limited downtime window. To achieve the given downtime window we planned to remove some unused components from the database.

Database Component Dependencies
Example: Component Dependencies in Oracle Database 11.1

As you know already the time it’ll take to upgrade an Oracle database is mainly dependent on the number of installed components. If you’ll query DBA_REGISTRY (or the underlying REGISTRY$) you’ll spot all the installed (and usually configured) database components. And the …

Recap on Deinstall Routines

Posted on November 15, 2010 by Mike.Dietrich Oracle Database 11g Removal 0

A few weeks ago I’Ve posted something about the deinstall utility as OUI doesn’t offer a “deinstall software” option anymore:
How to deinstall “old” SW after 11.2.0.2 has been applied?

And I’ve got some feedback (which is a good sign as it means that some of the content might be useful and will be read – and from the follow-up you see that we’ll read your comments and emails as well 🙂 ).

Anyway, the feedback was either CRS deinstall does not work the right way or deinstall cleans up too many things. So Roy did follow …

Removal

Deinstalling Oracle Database 12.2.0.1

XDB Clean Up in Oracle Database 11.2-12.2

Enterprise Manager (EM) Clean Up in Oracle Database 11.2-12.2

Expression Filter and Rules Manager (EXF, RUL) Clean Up in Oracle Database 11.2-12.2

Oracle Warehouse Builder (OWB) Clean Up in Oracle Database 11.2-12.2

Oracle OLAP (XOQ, APS, AMD) Clean Up in Oracle Database 11.2-19c

Oracle Multimedia (ORDIM) Clean Up in Oracle Database 11.2-12.2

Oracle Text (CONTEXT) Clean Up in Oracle Database 11.2-19c

Oracle Spatial (SDO) Clean Up in Oracle Database 11.2-19c

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

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

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

Precaution

Caution

Oracle Workspace Manager

What happened so far on my Journey to the Cloud?

Today’s journey: Cleanup APEX removal leftovers

What happened so far on my Journey to the Cloud?

What is JOX?

Question:

Answer:

Archives

Categories

Upgrade @YouTube

Subscribe via Email

Recent Posts