AutoUpgrade

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.

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

Photo by Stefano Ferretti on Unsplash

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

March 2023 release of AutoUpgrade is available

Posted on March 1, 2023 by Mike.Dietrich 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.

March 2023 release of AutoUpgrade is available

Photo by Mario von Rotz on Unsplash

Where to download?

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

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 …

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

Posted on February 24, 2023 by Mike.Dietrich 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.

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

Photo by Greg Rosenke on Unsplash

What is the symptom?

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

Patching my environments with the January 2023 Bundle Patches

Posted on January 27, 2023 by Mike.Dietrich 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…

Oracle Cloud World 2022 – Database Upgrade and Patching Labs

Posted on September 28, 2022 by Mike.Dietrich OOW 2

Oh … it’s just a few weeks left until Oracle Cloud World 2022 will start on Oct 17, 2022 in Las Vegas. If you have some final doubts whether you should go or not, let me tell you that it’s like Oracle Open World just under a different name. And in a different place. But with the same cool people and many great talks. Take the chance to meet the developers, their managers and the product managers behind the features you daily use – or miss. We’ll be there – and this is YOUR chance now to sign up for …

Intel uses AutoUpgrade to upgrade from Oracle 11.2.0.4 to 19c

Posted on September 27, 2022 by Mike.Dietrich Customer Success 14

Funny, I was traveling recently with RAC PM Anil Nair – but he forgot to tell me that this cool story has been published just a few days before we took of for YATRA 2022 to India: Intel uses AutoUpgrade to upgrade from Oracle 11.2.0.4 to 19c. I know that Anil is simply so busy – and my surprise was huge.

Intel uses AutoUpgrade to upgrade from Oracle 11.2.0.4 to 19c

Photo by Daniel Pantu on Unsplash

What’s the story?

Gagan Singh, Enterprise Architect at Intel, shared it with me last week. The goal was to upgrade from Oracle 11.2.0.4 to Oracle 19c with the least amount of downtime …

DOAG Conference 2022 is next week already

Posted on September 13, 2022 by Mike.Dietrich Conference 6

I’m scared – time flies so quickly. Yesterday evening I returned from vacation, and this morning I spoke to Daniel and we both realized: There is only one week to go since DOAG Conference 2022 is next week already. Yes, in September 2022. Not as usually in November – September it will be this year. And we hope to see you there next week in my hometown, Nürnberg for another great DOAG conference.

DOAG Conference 2022 is next week already

Tuesday

Tuesday will be a theme day this year – and we’ll have two talks there. We? Yes, Daniel and I will do all sessions together this …

Why you simply can’t upgrade from Oracle 11g or 12c to Oracle 23c

Posted on August 1, 2022 by Mike.Dietrich Release Schedule 5

It’s time for a Monday morning rant. I receive more and more questions which all start similar. “My customer is on Oracle 11g and/or 12c, and want to know whether the next long term support release …“. Now let me clarify Why you simply can’t upgrade from Oracle 11g or 12c to Oracle 23c. And why you MUST upgrade to Oracle Database 19c.

Why you simply can't upgrade from Oracle 11g or 12c to Oracle 23c

Photo by SpaceX on Unsplash

What is the intention?

After a lot of discussions across many regions, especially in JAPAC during the past weeks I realized that there is a reason for all …

A new version of AutoUpgrade has been released

Posted on May 16, 2022 by Mike.Dietrich AutoUpgrade 27

Yes, we did it again. A new version of AutoUpgrade has been released. With important fixes.

A new version of AutoUpgrade has been released

Download the May 2022 version

So it is time to update your AutoUpgrade and download the most recent version.

MOS Note: 2485457.1 – AutoUpgrade Tool

Changes / Fixes / Enhancements

As usual, we document the changes and fixes as well as the enhancements in the change log you’ll find in MOS.

At first, this is the new build:

build.version 22.3.220503
build.date 2022/05/03 11:55:20 -0400
build.hash 9e84e228
build.hash_date 2022/05/03 11:37:00 -0400
build.supported_target_versions 12.2,18,19,21
build.type production
20 bug fixes since v22.2 release
Tag: V22.3
Description:

Virtual Classroom Seminar #14: AutoUpgrade 2.0 on May 5, 2022

Posted on May 3, 2022 by Mike.Dietrich Workshop 4

If you finally want to see all the cool new features of AutoUpgrade 2.0 (the 2.0 is just a marker we use to say: We improved it significantly!), the please sign up to Virtual Classroom Seminar #14: AutoUpgrade 2.0 on May 5, 2022.

Virtual Classroom Seminar #14: AutoUpgrade 2.0 on May 5, 2022

Photo by Alex Knight on Unsplash

What are we going to talk about?

The development team invested a lot of resources to implement some of the most wanted features in AutoUpgrade. Spoiler: One feature is still missing but will be released very soon. In this Thursday’s Virtual Classroom Seminar we will talk about:

PDB and non-CDB

AutoUpgrade 2.0 has been released – and got reuploaded

Posted on March 25, 2022 by Mike.Dietrich AutoUpgrade 40

Many of you have used AutoUpgrade for your database upgrades already. Just a few days ago I received some almost enthusiastic comments which made me very very happy. And if you thought it can’t get any better, no worries: AutoUpgrade 2.0 has been released – and got reuploaded.

AutoUpgrade 2.0 has been released - and got reuploaded

Photo by Graham Pengelly on Unsplash

Why AutoUpgrade 2.0?

As you know, we don’t do marketing but just talk tech. But you may have also recognized that we slowed down in our agile release cycle for AutoUpgrade. The simple reason for this long period of silence was that we’ve had a …

New AutoUpgrade version 20211115 (Nov 2021) available for download

Posted on November 17, 2021 by Mike.Dietrich AutoUpgrade 20

Yesterday at DOAG conference I announced it already in our Upgrade and Migration Round Table – and just a few hours later my team mates made the New AutoUpgrade version 20211115 (Nov 2021) available for download.

New AutoUpgrade version 20211115 (Nov 2021) available for download

Photo by Tobias Rademacher on Unsplash

How to download AutoUpgrade?

Always download the most recent version of AutoUpgrade via MOS Note: 2485457.1 – AutoUpgrade Tool.

Just click on this link in the MOS Note: AutoUpgrade Nov 2021

Why do you need a new version?

A good number of issues being logged to us via blogs, tweets, SRs and eMails can be solved with the current …

Upgrading a PDB with JVM may result in ORA-7445 joevm_invokevirtual

Posted on September 29, 2021 by Mike.Dietrich Flaws and Pitfalls JVM 3

As you know, this blog is also my brain dump about Oracle topics. Since this one happened yesterday, mostly at night with the help of my team mates and the Java team, I’d like to write it down into this blog post: Upgrading a PDB with Java may result in ORA-7445 joevm_invokevirtual() as it is still fresh and may affect you as well. If you don’t have PDBs, if you don’t have Java (or JVM) in it or if you upgraded already to Oracle Database 19c, you can stop reading now.

Upgrading a PDB with Java may result in ORA-7445 joevm_invokevirtual

Photo by Fahmi Fakhrudin on Unsplash

What

Which releases allow you to upgrade to Oracle Database 21c?

Posted on August 31, 2021 by Mike.Dietrich Oracle Database 21c 2

As I wrote before, the release you should upgrade to is clearly Oracle Database 19c. Unless you need to use one of the new features in Oracle 21c. But as you have seen in the past, some of them get backported to 19c as well. Still, in case you can’t resists or you love upgrades as much as we do, the question may be: Which releases allow you to upgrade to Oracle Database 21c?

Upgrade-supported Releases

The Database Upgrade Guide for Oracle 21c is your best friend here. Right at the beginning in the first chapter you will find this …

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 2

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 …

Upgrading a non-CDB to Oracle Database 21c with AutoUpgrade

Posted on August 24, 2021 by Mike.Dietrich AutoUpgrade Oracle Database 21c Upgrade / Migration 9

Yesterday I wrote about the installation of Oracle Database 21c on Linux. But today it is time for Upgrading to Oracle Database 21c with AutoUpgrade.

Photo by Arjun MJ on Unsplash

AutoUpgrade

You may have heard it already from us and other colleagues, but we can’t repeat it often enough: There is only one recommended tool to upgrade your databases – and this is AutoUpgrade.

In my 21c home, I’m checking the deployed version of AutoUpgrade at first:

[CDB3] oracle@hol:/u01/app/oracle/product/21/rdbms/admin
$ java -jar autoupgrade.jar -version
build.hash 57ab246
build.version 21.1.3
build.date 2021/04/21 13:32:13
build.max_target_version 21
build.supported_target_versions 12.2,18,19,21
build.type production

Now please …

New version of AutoUpgrade (21.2) is available for download

Posted on July 22, 2021 by Mike.Dietrich AutoUpgrade 13

As we often tell you, our Upgrade Development team is working hard to ensure an agile release cycle for AutoUpgrade. And the New version of AutoUpgrade (21.2) is available for download.

New version of AutoUpgrade (21.2) is available for download

Photo by Aziz Acharki on Unsplash

How to download?

As usual, you can (and should) always download the most recent version of AutoUpgrade from this MOS Note: 2485457.1. Usually the tool gets refreshed every 6-8 weeks. And the version you will download is guaranteed newer than the one you could get on disk.

New version of AutoUpgrade (21.2) is available for download

The fact the tool has a 21c versioning does not affect 19c upgrades. There …

aioug Webinar Series July 2021: Database Upgrade and Migrations

Posted on June 28, 2021 by Mike.Dietrich Workshop 0

Many people on the northern hemisphere will escape during July into the summer holidays. But we won’t. Instead, thanks to Sai Penumuru, we will give seven webinars for the aioug. And we are looking forward to talk to you soon at the aioug Webinar Series July 2021: Database Upgrade and Migrations.

aioug Webinar Series July 2021: Database Upgrade and Migrations

When will it happen?

This morning I looked into my calendar. And I realized: Wow, July 2021 is just a few days away. Roy will start with the first session on Friday, July 2. And then myself, Rodrigo, Daniel, Fred and Bill will …

AutoUpgrade may run into a timeout when GI is lower than 19.10.0

Posted on June 21, 2021 by Mike.Dietrich ASM / RAC / GI Patch Recommendation 9

The other day I received a question from a colleague about the risk of having GI and database both not being on the same RU. And a long while ago I blogged about it. We recommend that you keep it in synch. But you don’t have to. At the same time I received a wish from Ernst Leber to post something on the blog he and his colleague had trouble with when upgrading to 19c in a RAC environment. AutoUpgrade hung. But he titled his email with “not an AutoUpgrade problem!”. Still I agree, it is worth to write …

Upgrade to Oracle 19c on Exadata with AutoUpgrade

Posted on June 16, 2021 by Mike.Dietrich Exadata / ODA Oracle Database 19c 23

This will be a short but very important blog post for those of you with Exadata systems. Then you should Upgrade to Oracle 19c on Exadata with AutoUpgrade.

Upgrade to Oracle 19c on Exadata with AutoUpgrade

Photo by Lindsay Henwood on Unsplash

Why is this important?

Until a week ago, the database upgrade MyOracle Support (MOS) note showed the process using the DBUA. And we had plenty of customers asking us why AutoUpgrade isn’t mentioned there. Our team worked already with some of you, and we knew that AutoUpgrade works perfectly fine and takes over some manual actions.

But our MAA team wanted a perfect solution. They …

Unplug / Plug / Upgrade with AutoUpgrade

Posted on June 7, 2021 by Mike.Dietrich Single-/Multitenant 21

When we launched AutoUpgrade, it could upgrade non-CDBs and CDBs with all PDBs. Soon after, it learned to upgrade a non-CDB and plug it into an existing CDB as a new PDB. And then, as next step, we added Unplug / Plug / Upgrade with AutoUpgrade. In this case you have a PDB (or hopefully more than one), and you’d like to upgrade one or many PDBs by moving them to a new CDB with a higher database version.

Unplug / Plug / Upgrade with AutoUpgrade

Photo by Kelly Sikkema on Unsplash

Test Setup

As test setup I use our Hands-On Lab.

I will …

ORA-1422 and ORA-6512 from SYS.DBMS_STATS in Post Upgrade

Posted on May 4, 2021 by Mike.Dietrich Optimizer Patch Recommendation 3

Ernst Leber sent me an email today. He hit an error at a customer upgrading to Oracle 19.9.0 on Exadata with AutoUpgrade. ORA-1422 and ORA-6512 from SYS.DBMS_STATS in Post Upgrade were signaled – and he better flashed back to the Guaranteed Restore Point. He found even a MOS note but still had questions. So time to blog about it in case you hit this error sequence as well.

ORA-1422 and ORA-6512 from SYS.DBMS_STATS in Post Upgrade Phase

Photo by Kelly Sikkema on Unsplash

What happens, and when does it happen?

At first, this is not an AutoUpgrade issue. You may see the same error stack in the post upgrade …

Where are AutoUpgrade error codes documented?

Posted on April 12, 2021 by Mike.Dietrich AutoUpgrade 2

I know, I didn’t blog for a while due to seminar preparations and holidays. But as I’m going through the open comments on the blog trying to answer them, I came across a question regarding the strange UPG error codes, AutoUpgrade is printing sometimes. And of course, where are AutoUpgrade error codes documented?

Where are AutoUpgrade error codes documented?

Photo by Patrick Tomasso on Unsplash

The UPG errors

Once AutoUpgrade hits an error condition, it prints an error code such as UPG-1400 or UPG-1303. And often, this error code is not very meaningful. In the comments section, somebody asked where to fine more information about these …

Virtual Classroom Series – Episode 2: Database Upgrade on Feb 18

Posted on February 16, 2021 by Mike.Dietrich Workshop 11

If you haven’t signed up, there are less than 48 hours left to sign up now to our Virtual Classroom Series – Episode 2: Database Upgrade on Feb 18. We’ll cover everything you need to know for a smooth and successful database upgrade to Oracle 19c.

Virtual Classroom Series - Episode 2: Database Upgrade on Feb 18

What’s the topic this time?

Upgrades.

What else? Haha!

No worries. We have a lot of fresh content and a full agenda. Our focus is to equip you with everything you need to know about upgrades – to make your next upgrade(s) the smoothest upgrade experience ever. We will cover mostly AutoUpgrade but …

Download the newest AutoUpgrade for 19c and 21c upgrades

Posted on December 16, 2020 by Mike.Dietrich AutoUpgrade Oracle Database 19c Oracle Database 21c 35

It’s out now and available since yesterday: AutoUpgrade 21c. Download the newest AutoUpgrade for 19c and 21c upgrades with many new features and improvements.

Photo by Jordan McGee on Unsplash

Download it!

This is the current version of AutoUpgrade:

build.hash 8ee6880
build.version 21.1.1
build.date 2020/12/14 14:41:34
build.max_target_version 21
build.supported_target_versions 12.2,18,19,21
build.type production
48 bug fixes since v21.0.0 release
Tag: v21.1.1
Description: This is the release for 21.1.1 MOS only

As usual, download it please from:

MOS Note: 2485457.1 – AutoUpgrade Tool

What’s new?

Non-CDB to PDB Upgrades
- AutoUpgrade can upgrade and convert a non-CDB to a PDB in a new

AutoUpgrade

What do I need?

Where to download?

What does this version improve?

What is the symptom?

What’s the story?

Tuesday

What is the intention?

Download the May 2022 version

Changes / Fixes / Enhancements

What are we going to talk about?

Why AutoUpgrade 2.0?

How to download AutoUpgrade?

Why do you need a new version?

What

Upgrade-supported Releases

What’s the problem?

AutoUpgrade

How to download?

When will it happen?

Why is this important?

Test Setup

What happens, and when does it happen?

The UPG errors

What’s the topic this time?

Download it!

What’s new?

Archives

Categories

Upgrade @YouTube

Subscribe via Email

Follow me on Twitter

Recent Posts