datapatch -verbose

datapatch stores rollback patching files in the database

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.

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. …

Continue reading...

How to speed up datapatch – and much more information

Ok, I promised to write more about patching speed. And this blog post will be just the root post targeting datapatch speed. I will link also to blog posts I’ve written before but also share knowledge which may not be obvious at first stage. The overall topic will be How to speed up datapatch – and much more information.

.

What is datapatch

Let me start at the ground level and explain what datapatch is and why it exists.

When you are still on Oracle Database 11g, you may wonder what datapatch …

Continue reading...

Workaround for sdoloadj.sql errors with Datapatch in 19.9.0 and 19.10.0

The other week a customer from my hometown alerted me about an issue they saw when applying the 19.9.0 RU. A long sequence of errors in the datapatch run, all of them signaled from sdoloadj.sql. They opened an SR. And Support had an – understandable – recommendation the customer didn’t want to implement: Install JAVAVM. But thanks to my PM mate, Hans Viehmann (Mr Spatial), here is a simple Workaround for sdoloadj.sql errors with Datapatch in 19.9.0 and 19.10.0. And it may even apply to later releases, too.

What happens?

Take …

Continue reading...