Download

Data Pump Bundle Patch for Oracle Database 23ai

While I blogged in the past already several times about how important the Data Pump Bundle Patch for all kinds of migrations is, a question was in my inbox this morning: Is there a separate note for the Data Pump Bundle Patch for Oracle Database 23ai?

Data Pump Bundle Patch for Oracle Database 23ai

Photo by kazuend on Unsplash

Download the Data Pump Bundle Patch for Oracle 23ai

We shared an intro about the Data Pump Bundle Patch in our Virtual Classroom Seminar #13 a long while ago. And talked about it in our Oracle Cloud World and User Group talks in more detail.

In brief, you …

AutoUpgrade 24.8 has been released adding MS Windows patching support

Posted on November 26, 2024 by Mike.Dietrich AutoUpgrade 8

Our developers are amazing. And you may have felt this the past months. In September for OCW2024 we released AutoUpgrade 24.6 with the new patching ability, in October we then released 24.7 improving it significantly and fixing issues based on the first tests, and now in November 2024 AutoUpgrade 24.8 has been released adding MS Windows patching support. Of course, there’s more in AutoUpgrade.

AutoUpgrade 24.8 has been released adding MS Windows patching support

Photo by Tadas Sar on Unsplash

How to download AutoUpgrade 24.8

Not only can you download the newest AutoUpgrade and its previous versions from MOS Note:2485457.1 – Download AutoUpgrade but as I wrote a …

Download AutoUpgrade directly from oracle.com

Posted on November 21, 2024 by Mike.Dietrich AutoUpgrade 4

We were promising this for a long while, and thanks to Bill’s persistence and hard work we finally can offer you something which will make your DBA life easier: The ability to Download AutoUpgrade directly from oracle.com.

Download AutoUpgrade directly from oracle.com

Photo by John Rodenn Castillo on Unsplash

What does this mean?

You know that you can download a new version of AutoUpgrade from My Oracle Support via MOS Note:2485457.1 – Download AutoUpgrade. This was the case since day 1, and even before we released AutoUpgrade together with Oracle Database 19c about 5.5 years ago. We used the note already in the …

AutoUpgrade’s Patching: The feature you waited for

Posted on October 28, 2024 by Mike.Dietrich AutoUpgrade Patch Recommendation 49

Over the almost past 6 years since we unleashed it, AutoUpgrade changed Oracle Database upgrades significantly. But we’ve been asked so many times about one missing feature. And now it is available. Still in V.1, not feature complete (yet). And we know that you have wishes and desires. Stay with us, it’s going to improve rapidly. So, let us kick off AutoUpgrade’s Patching: The feature you waited for.

AutoUpgrade's Patching: The feature you waited for

Photo by Ashim D’Silva on Unsplash

Wait a bit … AutoUpgrade Patching??

Yes, you are right. AutoUpgrade can patch your database from home A to home B for a longer …

A new version 24.1.0 of CPAT is available

Posted on April 9, 2024 by Mike.Dietrich CPAT 0

No worries, this blog won’t become a “new version” announcement blog. But after two weeks of relaxing Easter holidays I just start cleaning up my inbox and flushing out blog posts as soon as time allows. One thing I need to share with you is that a new version 24.1.0 of CPAT is available for download. CPAT? You may not have read about CPAT on my blog yet. But this will change in the future since the CPAT development is now part of our small team as well. And we get happily tied into more and more Autonomous Database (ADB) …

September 2023 version of AutoUpgrade is available

Posted on September 29, 2023 by Mike.Dietrich AutoUpgrade 13

It’s time again – and the new September 2023 version of AutoUpgrade is available for download to you.

Photo by Spenser Sembrat on Unsplash

Where to download it?

As usual, the MOS Note: 2485457.1 offers you access to the new release, and to the previous versions of the tool as well. This new version will show the following version information:

java -jar autoupgrade.jar -version

build.version 23.4.230921
build.date 2023/09/21 14:43:05 -0400
build.hash 165be072
build.hash_date 2023/09/21 13:05:52 -0400
build.supported_target_versions 12.2,18,19,21
build.type production
build.label (HEAD, tag: v23.4, origin/stable_devel, stable_devel)

This version will be also included in the Jan 2024 RU, 19.22.0, but not …

Oracle Database 19c on Arm platform is available

Posted on July 5, 2023 by Mike.Dietrich Oracle Database 19c Release Schedule 18

I knew it would come – but we couldn’t tell you. And there were some rumors for a longer time. Anyhow, last week at the end of June 2023 Oracle Database 19c on Arm platform is available for download and in the Oracle Cloud. In case you wonder why I write “Arm” – I learned last week that the writing has been changed a while ago from ARM to Arm.

Oracle Database 19c on Arm platform is available

Where can you download it?

It is available for download already.

Oracle Database 19c(19.19) for Linux Arm (aarch64)
- https://www.oracle.com/database/technologies/oracle-database-software-downloads.html#19c
19c Client(19.19) and Instant Client 19c(19.19) for Linux on Arm (aarch64)

June 2023 version of AutoUpgrade is available

Posted on July 3, 2023 by Mike.Dietrich AutoUpgrade 2

It’s time to exchange your AutoUpgrade tools with the most recent one when you plan to do upgrades or use it for patching already. The June 2023 version of AutoUpgrade is available for download from MOS Note:2485457.1. And in case you are still using DBUA for unknown reasons, please read this blog post, too.

June 2023 version of AutoUpgrade is available

Photo by Jason Hudson 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?

New Features

BUG-34010941 – Incorparated the Health check package to identify database dictionary inconsistencies

Oracle Database 23c Free Developer Release is available

Posted on April 4, 2023 by Mike.Dietrich Oracle Database 23ai 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:

Release 8

And my colleague Gerald Venzl

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

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

Photo by Vasily Koloda on Unsplash

Why are patches missing?

At first, I …

Oracle Optimizer Statistics Advisor in Oracle 19c

Posted on February 28, 2023 by Mike.Dietrich Flaws and Pitfalls Optimizer Patch Recommendation 22

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.

Oracle Optimizer Statistics Advisor in Oracle 19c

Photo by Tobias Keller on Unsplash

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 …

Hide and Seek with RU 19.18.0

Posted on February 2, 2023 by Mike.Dietrich Flaws and Pitfalls Patch Recommendation 46

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.

Photo by Braydon Anderson on Unsplash

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 …

Patching my environments with the January 2023 Bundle Patches

Posted on January 27, 2023 by Mike.Dietrich Patch Recommendation 30

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…

Important alert for Oracle Database and GI RU 19.18.0 on Linux

Posted on January 25, 2023 by Mike.Dietrich Flaws and Pitfalls Patch Recommendation 59

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 …

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

Posted on December 12, 2022 by Mike.Dietrich Data Pump Oracle Database 19c Patch Recommendation 46

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.

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

Photo by Khamkéo Vilaysing on Unsplash

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 …

Patching News: RURs are gone – long live MRPs

Posted on October 26, 2022 by Mike.Dietrich Patch Recommendation Release Schedule 26

Sorry for the headline using TLAs (three letter acronyms). But I was tempted – and those of you being interested in Oracle Database patching my quickly realize that there are some Patching News: RURs are gone – long live MRPs.

Photo by Hu Chen on Unsplash

RURs are gone?

Andy Mendelsohn announced the MRPs (Monthly Recommended Patches) in October at DOAG Conference in Nuernberg already. Due to Oracle Cloud World bussiness, I’ve had no time to write about it yet. And the introduction of the MRPs means that we won’t produce RURs anymore after a transition grace period.…

Oracle Cloud World 2022 – Recap and Slides

Posted on October 25, 2022 by Mike.Dietrich OOW 4

This was a wonderful but very strenuous week, no doubt. Oracle Cloud World (OCW) 2022 happened in Las Vegas. New name, new city. And even though many agreed to prefer San Francisco with an Oracle Open World instead having such an event in Sin City, there were a lot of great things happening. So let me start my personal summary here, the Oracle Cloud World 2022 – Recap and Slides.

Oracle Cloud World 2022 - Recap and Slides

Our labs and talks

It was amazing to see you all in our 4 sessions, 4 labs and 2 lightning talks. Since the registration process was a bit …

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:

Oracle Database 12.2.0.1 – End of Support and Patch Bundles

Posted on April 26, 2022 by Mike.Dietrich Release Schedule 1

This will be a short blog post but since I received a number of messages yesterday after I published my usual Patching all my environments with the April 2022 Patch Bundles blog post I need to clarify a few things regarding Oracle Database 12.2.0.1 – End of Support and Patch Bundles.

Oracle Database 12.2.0.1 - End of Support and Patch Bundles

Photo by Samuel Scrimshaw on Unsplash

Premier Support for Oracle 12.2.0.1

If you remember this, the Premier Support period for Oracle 12.2.0.1 ended on November 30, 2020.

Limited Error Correction Support for Oracle 12.2.0.1

Since many of you were still on Oracle 12.2.0.1 when the end of Premier Support …

Patching all my environments with the April 2022 Patch Bundles

Posted on April 25, 2022 by Mike.Dietrich Patch Recommendation 37

Easter time is patching time. And since I was hiking and biking every day the last week up in the Northern Italian mountains, this blog post is coming with a slight delay. But better late than never. Time to show you my usual exercise, this time Patching all my environments with the April 2022 Patch Bundles.

Patching all my environments with the April 2022 Patch Bundles

Photo by National Cancer Institute 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 …

AutoUpgrade 2.0 has been released – and got reuploaded

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

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 …

Virtual Classroom Seminar 13 Data Pump – Slides, Video and QA

Posted on March 8, 2022 by Mike.Dietrich Video / Viewlet Workshop 4

Thanks a lot to everybody who tuned in last week to our Virtual Classroom Seminar #13: Data Pump Extreme – Deep Dive with Development. We’ve had almost 600 attendees, and many of you stayed for the two full hours. And let me tell you that this is just awesome since there are enough people who think that a session has to be just 30 minutes or less. And of course, no it is time to share: Virtual Classroom Seminar 13 Data Pump – Slides, Video and QA.

Virtual Classroom Seminar 13 Data Pump - Slides, Video and QA

Photo by Pim Chu on Unsplash

The slides

As usual, you can …

Patching all my environments with the January 2022 Patch Bundles

Posted on January 20, 2022 by Mike.Dietrich Patch Recommendation 60

It’s patching time. When I checked an SR and had a quick discussion with a customer yesterday, Peter reminded me that it’s patching day. And at about 20:00h CET the new patch bundles appeared on MOS. So let me show you again Patching all my environments with the January 2022 Patch Bundles for 11.2.0.4, 12.2.0.1, 19c and 21c.

Patching all my environments with the January 2022 Patch Bundles

Photo by Mehmet Turgut Kirkgoz on Unsplash

Patching all my environments with the October 2021 Patch Bundles

Posted on December 16, 2021 by Mike.Dietrich Patch Recommendation 20

My calendar has no error or NLS conversion issue – I was just way to busy the past two months with seminars. But today a colleague asked me whether my 21.4 install reports a 21.3 Build Label in the trace files. And this reminded me that I should now finally apply the patch bundles from October 2021 to our Hands-On Lab environment. So again, another blog post about Patching all my environments with the October 2021 Patch Bundles.

Patching all my environments with the October 2021 Patch Bundles

Photo by NCI on Unsplash

As usual, an important annotation upfront: I patch in-place due to space issues. But in reality, you …

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 …

Download

Download the Data Pump Bundle Patch for Oracle 23ai

How to download AutoUpgrade 24.8

What does this mean?

Wait a bit … AutoUpgrade Patching??

Where to download it?

Where can you download it?

Where to download?

What does this version improve?

New Features

Where can you download it?

Why are patches missing?

Overview

Heads Up!

What is the situation?

What is in the Data Pump Bundle Patch?

RURs are gone?

Our labs and talks

Download the May 2022 version

Changes / Fixes / Enhancements

Premier Support for Oracle 12.2.0.1

Limited Error Correction Support for Oracle 12.2.0.1

Why AutoUpgrade 2.0?

The slides

How to download AutoUpgrade?

Why do you need a new version?

Archives

Categories

Upgrade @YouTube

Subscribe via Email

Recent Posts