remove

Cleaning up older patch artifacts – improving opatch performance

This blog post is about a feature not only I but you did ask for actually for a long time. Cleaning up older patch artifacts – improving opatch performance. Both in one opatch release. And opatch 12.2.0.1.37 from April 2023 has it.

A little bit of history

One of the longest journey I had ever done in my long time in Oracle was helping customers to find a voice for patch cleanup. Oracle 19c is a long term support release. Many customers upgraded to it already. And you apply patches on a regular …

Continue reading...

Why is there a lib32 directory in Oracle 19.8.0 and 19.9.0?

I received two emails from different customers within a week – and both asked the same thing: Why is there a lib32 directory in Oracle 19.8.0 and 19.9.0? In one case, it was more like “We are wondering” but in the other case it caused issues during patching.

Why is there a lib32 directory in Oracle 19.8.0 and 19.9.0?

Photo by Erik Mclean on Unsplash

What happens?

Due to a packaging issue most likely, there is a lib32 directory appearing after you patch your homes to either 19.8.0 or 19.9.0. With the next RU, 19.10.0, this should not be the case anymore.

Why does this sound strage?

The first customer who …

Continue reading...

Remove Underscore Parameters not only before you upgrade

Remove Underscore Parameters not only before you upgradeUnderscore parameters are a wonderful thing in Oracle. They are treated like a secret. But you can view them of course. Everybody can. Make a guess how many underscore parameters exist in Oracle 12.2.0.1.0. You’ll find the answer at the end of this blog post. But why should you remove underscore parameters not only before you upgrade?

I’d like to explain below why underscores, especially too many of them, may cause a lot of trouble. Therefore, housekeeping is very important.

Remove Underscore Parameters not only before you upgrade

This is from a recent upgrade from Oracle 12.1.0.2 to Oracle 12.2.0.1 …

Continue reading...

XDB Clean Up in Oracle Database 11.2-12.2

XDB Clean Up in Oracle Database 11.2-12.2XDB 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.2Oracle 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 …

Continue reading...

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

JAVAVM and XML Clean Up in Oracle Database 11.2-12.2JAVAVM 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

Continue reading...

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

Enterprise Manager (EM) Clean Up in Oracle Database 11.2-12.2Enterprise 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.2As 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:

Continue reading...

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

Expression Filter and Rules Manager (EXF, RUL) Clean Up in Oracle Database 11.2-12.2Oracle 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

Continue reading...

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

Oracle Warehouse Builder (OWB) Clean Up in Oracle Database 11.2-12.2Oracle 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.2According to Oracle Data Integrator and Oracle Warehouse Builder Statement

Continue reading...

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

Oracle Multimedia (ORDIM) Clean Up in Oracle Database 11.2-12.2Oracle 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.2Please 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. …

Continue reading...

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

Oracle Spatial (SDO) Clean Up in Oracle Database 11.2-12.2Oracle 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.2Oracle 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 …

Continue reading...

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

Oracle Spatial (SDO) Clean Up in Oracle Database 11.2-12.2Oracle 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.2Oracle Spatial (formerly known as Spatial Data Option) and Graph are great …

Continue reading...

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

Oracle Label Security (OLS) Clean Up in Oracle Database 11.2-12.2Oracle 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.2Oracle 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 …

Continue reading...

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

Oracle Workspace Manager (OWM) Clean Up in Oracle Database 11.2-12.2I 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 …

Continue reading...

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

Remove and Clean Up Components - Oracle 11.2 - 12.2Remove 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 …

Continue reading...

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

OWM Workspace Tree

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 …

Continue reading...

DROP PLUGGABLE DATABASE – things you need to know

Directly after my DOAG (German Oracle User Group) Conference presentation about “How Single-/Multitenant will change a DBA’s life” Martin Bach (Enkitec) approached me and told me about his experiences with the DROP PLUGGABLE DATABASE command and future recoverability.

Martin discovered that once you issued the DROP PLUGGABLE DATABASE command you can’t reuse a previously taken backup of this particular PDB anymore and recover the PDB into this existing CDB. I wasn’t aware of this and I’m glad that Martin told me about it.

Actually only the meta information in the controlfile or the RMAN catalog will be deleted. But archive

Continue reading...

Recap on Deinstall Routines

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 …

Continue reading...