Cleanup

Final blog post about datapatch cleanup and purge?

Posted on February 28, 2025 by Mike.Dietrich Patch Recommendation 30

Uh … this was a long journey. In September 2022 Jannes Arends contacted me showing me his growing SYSTEM tablespace with every patch cycle. And not only for the CDB$ROOT only but in every PDB. Over time, I wrote some blog posts I link at the end of this blog post. But finally, we should have a working solution without any additional risk. So, I am hoping that this will be my final blog post about datapatch cleanup and purge.

Final blog post about datapatch cleanup and purge?

Photo by Clay Banks on Unsplash

What’s the point (summary)?

With every patch run, datapatch stores the entire collection …

News and updates in opatch 12.2.0.1.45 (Jan 2025)

Posted on January 23, 2025 by Mike.Dietrich Patch Recommendation 10

Are you interested in the news and updates in opatch 12.2.0.1.45 (Jan 2025)? This is the opatch version being released on January 21, 2025 together with the January Release Updates (RUs) and other patch bundles.

Photo by Khyta on Unsplash

What’s new in opatch 12.2.0.1.45 (Jan 2025)?

When I refer to opatch, I mean the opatch tool for the Oracle Database installations. You can always download it via OPatch Download: Patch 6880880. You will use this opatch for Oracle Database 12.1.0.2, 12.2.0.1, 18c, 19c and 21c. In addition, the same changes and updates are present in opatch 11.2.0.3.49 …

More about cleaning up datapatch patching files

Posted on September 30, 2024 by Mike.Dietrich Patch Recommendation 10

One of the reasons why I love my job: We have the smartest customers out there. Incredible. When I blogged the other day (after a longer pause) about Cleanup datapatch patching files in your database some of you commented the other day with either success messages, or tried out to rollback – or simply missed steps in the README. And since we have also smart developers at Oracle, I received some additional facts from the datapatch architect which I let him explain below.

More about cleaning up datapatch patching files

Photo by Brian Yurasits on Unsplash

The README file

Well, Devin commented on the previous blog post…

datapatch stores rollback patching files in the database

Posted on January 17, 2024 by Mike.Dietrich Patch Recommendation 29

I held back this blog post for a longer while. A customer (Thanks Jannes!) reported this to me many months ago but the fix was not as trivial as we thought initially, and there were several unlucky circumstances delaying it multiple times. But now it is time to tell you how datapatch stores rollback patching files in the database. And of course, how to cleanup.

datapatch stores rollback patching files in the database

Photo by Pawel Czerwinski on Unsplash

Why is this important?

At first, you may ask yourself: Why should I care? And you are right. This is normally nothing you should care about. …

Cleaning up older patch artifacts – improving opatch performance

Posted on May 16, 2023 by Mike.Dietrich Patch Recommendation 51

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.

Cleaning up older patch artifacts - improving opatch performance

Photo by Toon Lambrechts on Unsplash

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 …

Pitfall: Upgrade to 21c fails when ORDIM is present but no SDO

Posted on August 25, 2021 by Mike.Dietrich Flaws and Pitfalls Oracle Database 21c Upgrade / Migration 4

You may have read my previous blog post about Upgrading a non-CDB to Oracle Database 21c. And I referred to a potential Pitfall: Upgrade to 21c fails when ORDIM is present but no SDO. In this blog post I would like to explain how to avoid this pitfall beforehand and explain what needs to be done.

Pitfall: Upgrade to 21c fails when ORDIM is present but no SDO

Photo by Sara Codair on Unsplash

What’s the problem?

In my previous blog post I showed you the ideal and normal way. But during my tests I came across an issue I was not aware of – and I simply had no …

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 …

Cleanup

Final blog post about datapatch cleanup and purge?

What’s the point (summary)?

News and updates in opatch 12.2.0.1.45 (Jan 2025)

What’s new in opatch 12.2.0.1.45 (Jan 2025)?

More about cleaning up datapatch patching files

The README file

datapatch stores rollback patching files in the database

Why is this important?

Cleaning up older patch artifacts – improving opatch performance

A little bit of history

Pitfall: Upgrade to 21c fails when ORDIM is present but no SDO

What’s the problem?

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

Precaution

Archives

Categories

Upgrade @YouTube

RSS Feed for Upgrade your Database – NOW!

Subscribe via Email

Recent Posts