version

AutoUpgrade Patching – From Zero to Hero – Part 1: Download AutoUpgrade

I was traveling the past two weeks, and I met a lot of customers who still “enjoy” navigating through MOS and searching for the right patches to download. This blog post series will give you ultimate relief, and it will ease your life as DBAs and sysadmins. You must patch more frequently – and this is the key solution for everyone. Let’s get us started with AutoUpgrade Patching – From Zero to Hero – Part 1: Download AutoUpgrade today.

AutoUpgrade Patching - From Zero to Hero - Part 1

Download the newest version of AutoUpgrade

Our first task is simple. You will find autoupgrade.jar in your ?/rdbms/admin directory since Oracle …

Should you attempt double-hop Oracle Database upgrades?

A long while ago I wrote a blog post about multiple-hop upgrades. And just recently I received many questions about whether one could skip Oracle Database 19c, and rather move into Oracle Database 23ai directly. So, the ask is: Should you attempt double-hop Oracle Database upgrades?

Should you attempt double-hop Oracle Database upgrades?

Photo by Nik on Unsplash

What is a double-hop or multiple-hop upgrade?

Let me clarify the self-invented term here at first. In every Oracle database release we define the minimum database version you can directly upgrade from. With “upgrade” we refer to using the scripts or tools such as AutoUpgrade. Please …

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 19.10.0 and Blockchain Tables and COMPATIBLE

Posted on February 18, 2021 by Mike.Dietrich Behavior Change Oracle Database 19c Parameters Patch Recommendation 4

Many of you recognized that we delivered a new feature with Oracle Database 19.10.0, the January 2021 Release Upgrade. So I’d like to put a few interesting things together from the upgrade and migration perspective regarding Oracle Database 19.10.0 and Blockchain Tables and COMPATIBLE.

Oracle Database 19.10.0 and Blockchain Tables and COMPATIBLE

Photo by Daniel von Appen on Unsplash

What are Blockchain Tables?

At first, I don’t want to repeat what other people have blogged and written about already. You may just go through the blog posts of Connor McDonald and Tim Hall and others to learn more about this cool feature.

Connor McDonald about “Blockchain

JDK patching happens with every RU since January 2020

Posted on April 22, 2020 by Mike.Dietrich Patch Recommendation 29

A while ago, a customer asked me whether he needs to apply JDK patches separately. He discovered that the JDK in the $ORACLE_HOME is quite outdated. But there was no clear answer available. And the MOS Note he pointed me to, seemed to be quite incomplete. But times have changed. And JDK patching happens with every RU since January 2020.

Photo by David Billings on Unsplash

JDK who?

JDK stands for Java Development Toolkit. As the Wikipedia article explains, “the JDK includes a private JVM and a few other resources to finish the development of a Java Application”. …

Minimum Supported Version for Database Upgrades

Posted on January 11, 2018 by Mike.Dietrich General Upgrade / Migration 6

This question comes up very often: What is the minimum supported version for database upgrades? Or a question I received today: “I have an Oracle 10.2.0.4 database, can I upgrade directly to Oracle 11.2.0.4?”

Usually I have to dig into my old slides from the past to give a definite answer. And of course, the Database Upgrade Guide of each version has the same information somewhere as well. Therefore I’d like to summarize the releases supported for direct database upgrades since Oracle 11.2.0.4 below.

Upgrade?

When I speak about database upgrades, I mean you’ll use either the command line …

Is your APEX version certified with your Database release?

Posted on May 2, 2017 by Mike.Dietrich APEX 18

+++ Blog post updated on Oct 2, 2019 +++ New additions marked in Red +++

+++ Blog post updated on Aug 3, 2021 +++ New additions marked in Blue +++

+++ Blog post updated on Apr 10, 2025 +++ Updated some stuff and changed order in Pink +++

Last week I’ve had an interesting discussion with a customer about the certification of APEX and Oracle Database 12.2.0.1.

I did a bit of research and emailing – and thanks to the APEX team – this is the source of truth for APEX certifications.

Is your APEX version certified with your Database release?

Minimum Database version for APEX

PLEASE NOTE: The …

version

AutoUpgrade Patching – From Zero to Hero – Part 1: Download AutoUpgrade

Download the newest version of AutoUpgrade

Should you attempt double-hop Oracle Database upgrades?

What is a double-hop or multiple-hop upgrade?

September 2023 version of AutoUpgrade is available

Where to download it?

Oracle Database 19.10.0 and Blockchain Tables and COMPATIBLE

What are Blockchain Tables?

JDK patching happens with every RU since January 2020

JDK who?

Minimum Supported Version for Database Upgrades

Upgrade?

Is your APEX version certified with your Database release?

Minimum Database version for APEX

Archives

Categories

Upgrade @YouTube

RSS Feed for Upgrade your Database – NOW!

Subscribe via Email

Recent Posts