New home

The downsides of in-place patching – and a patching lab

Happy New Year to all of you at first. I hope you all had a good start – and for myself, I promise to blog a bit more again in 2024. Let me start with my first post since I received a question very often: Why should I patch out-of-place with a new Oracle Home? Since I need to patch a bit today I can easily show the downsides of in-place patching – and a patching lab.

It all started at OCW 2023

Ok, we didn’t really start it at OCW 2023 in

Continue reading...

Patching to Oracle 19.19.0 out-of-place with additional patches

From all my quarterly blog posts you know that I patch usually in-place for space and other reasons. And you may have similar reasons when you patch. But it is not ideal – and just speaking about risk and downtime, you should always patch out-of-place. So let me show you how Patching to Oracle 19.19.0 out-of-place with additional patches works.

What do I need?

Actually, this is not complicated at all. And if you never done it this way, give it a try now please.

  • Base release Oracle Database 19.3.0 image
  • opatch 37 from
Continue reading...

DBMS_OPTIM_BUNDLE and Out-Of-Place Patching

Well, you see, this is most likely my special DBMS_OPTIM_BUNDLE week. And since I receive quite a number of questions, it may be good to discuss here about DBMS_OPTIM_BUNDLE and Out-Of-Place Patching?

DBMS_OPTIM_BUNDLE and Out-Of-Place Patching

Photo by Didssph on Unsplash

Out-of-place Patching

When you patch out-of-place with a new home – which is clearly our recommendation – you may see another tiny pitfall with DBMS_OPTIM_BUNDLE.

When you check DBA_DIRECTORIES, you will find two directories being related to DBMS_OPTIM_BUNDLE.

SQL> select directory_name, directory_path from dba_directories where directory_name like '%OPTIM%'

DIRECTORY_NAME	     DIRECTORY_PATH
-------------------- --------------------------------------------------
DBMS_OPTIM_LOGDIR    /u01/app/oracle/product/19/cfgtoollogs
DBMS_OPTIM_ADMINDIR  /u01/app/oracle/product/19/rdbms/admin

You see the “19” in the …

Continue reading...