Choose your desired time zone version (DST) upgrade

Choose your desired time zone version (DST) upgrade 4

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

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

Patching process changes with MRPs

Patching process changes with MRPs 5

Cleaning up older patch artifacts – improving opatch performance

Cleaning up older patch artifacts - improving opatch performance 18

Virtual Classroom Seminar 16: Release and Patching Strategy for Oracle 19c and 23c

9

Datapatch may be slower when Traditional and Unified Auditing are on

7

Oracle Database World in London – THE event in April 2023

Oracle Database World in London - THE event in April 2023 7

Oracle Database 23c Free Developer Release is available

Oracle Database 23c Free Developer Release is available 5

Virtual Classroom Seminar #15: Data Pump Best Practices on April 5, 2023

Virtual Classroom Seminar #15: Data Pump Best Practices on April 5, 2023 4

A patch (RU, OJVM, 32-bit) is not available yet – where will I find information?

2

Choose your desired time zone version (DST) upgrade

Posted on May 24, 2023 by Time Zone - DST Transportable 4

This morning I received a very reasonable question from a customer who has a time zone mismatch between source and target database. And he wants to transport into a PDB on Exadata. Even though, this sounds trivial at first sight, unfortunately it isn’t. But a bug fix done recently for a German automotive customer is very handy here. So let me show you how you can Choose your desired time zone version (DST) upgrade.

Choose your desired time zone version (DST) upgrade

Photo by Vince Veras on Unsplash

Where does the problem start?

In this particular – and not unusual case – the customer wants to migrate …

Continue reading...

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

Posted on May 23, 2023 by AutoUpgrade Patch Recommendation 21

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

Patching process changes with MRPs

Posted on May 22, 2023 by Patch Recommendation 5

I blogged about the Monthly Recommended Patches (MRP) several times before. And due to the feedback you and we had given, a few things got changed. The main change is from having the MRP bundled as a system patch making opatchauto a requirement. See below what Patching process changes with MRPs were implemented recently.

Before …

As you could read already in:

the introduction of the MRPs added one major flaw: They’ve been built as system patches which made …

Continue reading...

Cleaning up older patch artifacts – improving opatch performance

Posted on May 16, 2023 by Patch Recommendation 18

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

Virtual Classroom Seminar 16: Release and Patching Strategy for Oracle 19c and 23c

Posted on May 8, 2023 by Patch Recommendation Release Schedule Workshop 9

There are just two days left to sign up for our Virtual Classroom Seminar 16: Release and Patching Strategy for Oracle 19c and 23c. We’ll talk to you on Wednesday, May 10 at 16:00h CET.

What’s the topic?

We’ll try to cover everything for your best release and patching strategy with Oracle Database 19c of course, but also moving forward to Oracle Database 23c. Our big focus will be several aspects of patching. You’ll hear us talking not only about standard database patching but especially about patching in RAC environments.

We’ll put together a …

Continue reading...

Datapatch may be slower when Traditional and Unified Auditing are on

Posted on April 11, 2023 by Auditing Flaws and Pitfalls 7

I wrote several times especially about Unified Auditing in the past. It is a very efficient and useful way to audit operations in the database. But you need to be a bit careful about what’s on, and what isn’t. Now we recently had a customer case where it was clearly proven that Datapatch may be slower when Traditional and Unified Auditing are on. But how can this happen?

Recapping Traditional Auditing

At first, I am neither a security not an auditing expert. But I played quite a bit with Unified Auditing over the …

Continue reading...

Oracle Database World in London – THE event in April 2023

Posted on April 5, 2023 by Conference Workshop 7

You may have heard or seen – or even registered already – for the regional Oracle Cloud World in London on April 19, 2023 already. But were you aware that the “event to be at” happens just the next day on April 20? It will be Oracle Database World in London – THE event in April 2023.

Oracle Database World in London - THE event in April 2023

When and where will it happen?

April 20, 2023, a Thursday will be the day to mark in your calendar. We’ll meet you at Oracle Database World, the regional database event to be at in London this year at the …

Continue reading...

Oracle Database 23c Free Developer Release is available

Posted on April 4, 2023 by Oracle Database 23c 5

Yesterday at the regional Oracle Cloud World (OCW) in Singapore it got announced: Oracle Database 23c Free Developer Release is available for download from now on.

Oracle Database 23c Free Developer Release is available

Where can you download it?

That is most likely the most important link you are looking for. You can download the Oracle Database 23c Free Developer Release from here: Download Oracle Database 23c Free Developer Release. You will download an RPM.

Please note that Oracle Database 23c on Linux requires your OS to be either OL8 or RHEL8.

You can find the preinstall package here:

And my colleague Gerald Venzl

… Continue reading...

Virtual Classroom Seminar #15: Data Pump Best Practices on April 5, 2023

Posted on March 23, 2023 by Best Practice Data Pump Workshop 4

We are quite busy these days. And I am lagging behind in answering your comments on the blog. So please be patient, nothing will be lost. Meanwhile, we work hard on the slides for our next Virtual Classroom Seminar #15: Data Pump Best Practices on April 5, 2023.

What will be the topic?

Data Pump Best Practices and Real World Scenarios tells you already what we are planning to do. After we had a “Data Pump Deep Dive with Development” seminar last year (time flies so quickly), we decided that we should tackle …

Continue reading...

A patch (RU, OJVM, 32-bit) is not available yet – where will I find information?

Posted on March 7, 2023 by Patch Recommendation Release Schedule 2

A longer while ago I wrote a blog post about the topic that a patch (RU, OJVM, 32-bit) is not available yet – where will I find information? But I wrote it too specific. And it is even hard for me to find my older blog post. Since several of you mailed me the past weeks with a variety of questions regarding patch availability I decided to write down my thoughts – but this time in a more generic way. And I hope it is helpful.

Why are patches missing?

At first, I …

Continue reading...

March 2023 release of AutoUpgrade is available

Posted on March 1, 2023 by AutoUpgrade 12

It’s download time again. So please refresh the AutoUpgrade release you are using with the new one since the March 2023 release of AutoUpgrade is available now for download.

Where to download?

As usual, please download the newest version of AutoUpgrade via MOS Note:2485457.1 – Download AutoUpgrade.

March 2023 release of AutoUpgrade is available

 

What does this version improve?

A lot.

Really, a lot of things got improved.

You’ll find the change.log for tracking purposes at the bottom of the note. I’d wish everybody would do such a transparent change tracking as the AutoUpgrade team does. This makes …

Continue reading...

Oracle Optimizer Statistics Advisor in Oracle 19c

Posted on February 28, 2023 by Flaws and Pitfalls Optimizer Patch Recommendation 18

Christian Pfundtner pointed me to the fact that my old blog post about the Statistics Advisor from 2017 may not be up to date anymore. And he further pointed out that some of his clients still suffer from issues with the tool. Hence, let me refresh the topic with Oracle Optimizer Statistics Advisor in Oracle 19c. And thanks to Christian for the pointers.

 

Overview

At first, I won’t rewrite the entire blog post but instead focus on recent findings. Therefore, you may please want to read my previous blog post about the …

Continue reading...

ORA-13516 “CATPROC not valid” during datapatch or autoupgrade to 19.18.0

Posted on February 24, 2023 by Flaws and Pitfalls Patch Recommendation 18

I thought I could relax this week using my leftover vacation days from 2022. But this issue is triggering me since some of you mailed me already. Maybe this blog post can prevent others from being trapped by this issue: ORA-13516 “CATPROC not valid” during datapatch or autoupgrade to 19.18.0. And as a prolog, you will NOT see the below issue when you started your database in NORMAL mode for the execution of datapatch.

 

What is the symptom?

Regardless of whether you patch to Oracle Database RU 19.18.0 manually or with …

Continue reading...

Hide and Seek with RU 19.18.0

Posted on February 2, 2023 by Flaws and Pitfalls Patch Recommendation 44

One and a half weeks ago we released the Database and Grid Infrastructure Release Updates (RU) 19.18.0. You could read on the blog how to apply it, and you could read also about an alert. So far, all was more or less transparent but apparently sort of an Hide and Seek with RU 19.18.0 has happened. So let me shed some light.

Heads Up!

I am just the messenger trying to bring some light into the topic. Neither is our team responsible nor do we have any sort of control on this process. I …

Continue reading...

Suppress nasty error messages and traces during datapatch

Posted on January 31, 2023 by Flaws and Pitfalls Patch Recommendation 4

A few days ago I published my quarterly blog post in the series of Patching all my environments … And I mentioned that datapatch took a bit longer for 19.18.0 than usual. In the alert I’ve had nasty error messages or warnings. And Walter (thanks!) commented immediately with some advice.

 

What are these messages?

Actually, I saw them before already. Since I always create CUSTOM databases with a template I spotted those warnings the first time when I was wondering why DB creation took so abnormally long with Multitenant. I discovered KGL Heap …

Continue reading...

MRP3 for Oracle 19.17.0 adds an interesting surprise

Posted on January 30, 2023 by Flaws and Pitfalls Patch Recommendation 9

You may have read my previous blog posts about MRPs (Monthly Recommended Patches). And today I did a quick check with Rodrigo. We both were a bit surprised to have the MRP3 for 19.17.0 add a lot of fixes to a standard RDBMS installation. So we were investigating a bit further. As a teaser, read on to see that MRP3 for Oracle 19.17.0 adds an interesting surprise.

 

How did we find out?

The MRP3 for Oracle Database 19.17.0 got released just a week ago. You can navigate to it via MOS …

Continue reading...

Patching my environments with the January 2023 Bundle Patches

Posted on January 27, 2023 by Patch Recommendation 26

Mid-of January. It’s patching time again. So let me show you the quarterly exercise of Patching my environments with the January 2023 Bundle Patches. Let’s see this time if I will have to remove my Data Pump Bundle Patch and the 19.17.0 MRP2 at first when I patch in-place.

Patching my environments with the January 2023 Bundle Patches

Photo by karokrasinska on Unsplash

As usual, an important annotation upfront: I patch in-place due to space issues. But in reality, you please patch always out-of-place with a separate home. Please see this blog post about how to apply the RU directly when you provision a new home with OUI…

Continue reading...

Important alert for Oracle Database and GI RU 19.18.0 on Linux

Posted on January 25, 2023 by Flaws and Pitfalls Patch Recommendation 58

Some of you may have seen the alert already released yesterday. And thanks to Peter Lehmann again for alerting me. When you logon to MyOracle Support, you will find it simply in the alert section to the left. On Jan 25, 2023, this Important alert for Oracle Database and GI RU 19.18.0 on Linux has been released.

Important alert for Oracle Database and GI RU 19.18.0 on Linux

Photo by Gary Bendig on Unsplash

 

What is the situation?

Due to an issue described in MOS Note: 2923428.1 – LMON trace file with repeated entries of “Submitting asynchronized dump request” the Release Updates (RU) 19.18.0 for the Oracle Database and …

Continue reading...

Rolling back or removing all patch SQL changes

Posted on January 20, 2023 by Flaws and Pitfalls Microsoft Windows Single-/Multitenant 2

This is quite an interesting case I’ve had to scratch my head at first as well. Magnus mailed me the other day asking for a client since the PDB compatibility check errored out with a patch conflict. We discussed the topic but the most easiest workaround to me was Rolling back or removing all patch SQL changes from the PDB before unplug. And since I had to look up the command I’d rather put it on the blog in case you or I need it again one day.

 

What is the case?

I …

Continue reading...

RUs contain now all available DST patches

Posted on January 19, 2023 by Patch Recommendation Time Zone - DST 8

At first, Happy New Year everybody. There was silence on the blog for some weeks but I took an extended longer time off. Well, and once you return, there are some emails in your inbox which need some work. You’ll see several new blog posts getting published in the coming days. Back to normal, yesterday night RU 19.18.0 among other patch bundles has been released. And there’s a huge fantastic surprise in it: RUs contain now all available DST patches.

 

What’s the story?

There are some good news. We discussed this internally …

Continue reading...

Applying the MRP from December 2022 to Oracle 19c

Posted on December 21, 2022 by Patch Recommendation 16

Well, couldn’t there be a nicer pre-Christmas present than the December 2022 Monthly Recommended Patches (MRP)? You know, I’m just kidding. But since I received the first questions from customers – and before I send an email internally – I wanted to try out Applying the MRP from December 2022 to Oracle 19c.

 

Download the December MRP

Actually you need to access MOS Note: 888.1 -Primary Note for Database Proactive Patch Program since the link is not in MOS Note: 555.1 – Oracle Database 19c Important Recommended One-Off Patches even though it …

Continue reading...

Apply the Data Pump Bundle Patch – non-rolling but online?

Posted on December 13, 2022 by Data Pump Patch Recommendation 19

Yesterday I have blogged about an issue with the highly recommended Data Pump Bundle Patches. And today I would like to shed some light on how to Apply the Data Pump Bundle Patch – non-rolling but online?

 

Download the Data Pump Bundle Patch

You can download the correct Data Pump Bundle Patch from MOS Note: 2819284.1 – Data Pump Recommended Proactive Patches For 19.10 and Above. It’s just a few MB, and it is a generic patch with a separate download for the Windows platform. So far so good.

 …

Continue reading...

Data Pump Bundle Patches: You may need to download and apply again

Posted on December 12, 2022 by Data Pump Oracle Database 19c Patch Recommendation 22

The Data Pump Bundle Patches get released on top of every RU since over a year now. But a real issue with missing files got detected recently. So in case you had applied Data Pump Bundle Patches: You may need to download and apply again.

 

What is in the Data Pump Bundle Patch?

The Data Pump Bundle Patch is a convenient and very useful vehicle to apply Data Pump patches which are usually not included in a Release Update (RU). While RUs are per definitionem RAC-rolling and Standby-First, the Data Pump Bundle …

Continue reading...

A change in Oracle 12.2 and 19c with MV Refresh Stats Collection

Posted on November 23, 2022 by Best Practice Upgrade / Migration 6

It’s not easy for me to put the topic into a searchable title for this blog post. The feature or change I will write about today came in actually with Oracle Database 12.2.0.1. But since many of you will move directly from Oracle 11.2.0.4 or 12.1.0.2 to 19c, the Long Term Support release, it may affect you as well. So let me explain a change in Oracle 12.2 and 19c with MV Refresh Stats Collection.

 

A customer story

The local Support team asked me a few weeks ago whether I have heard …

Continue reading...

Applying the first MRP for Oracle 19.17.0

Posted on November 17, 2022 by Patch Recommendation 31

A few weeks ago I blogged about the fact that we retired the RURs, and instead release the MRPs (Monthly Recommended Patches). In my previous blog post about this topic you’ll find also an FAQ hopefully answering all the questions you may have (had). And now it is mid of November, so I can show you the process of applying the first MRP for Oracle 19.17.0.

 

How do you get access to the MRPs?

At the moment while I write this, you can find the MRPs only in MOS Note: 888.1 -Primary …

Continue reading...
Mike Dietrich
Oracle Senior Director of Product Manager for Database Upgrade, Migrations and Patching writing just another blog.

Opinions certainly are my own as is this page.

Archives

Categories

Upgrade @YouTube

Subscribe via Email

Join 7,330 other subscribers

Follow me on Twitter