77 Search results

For the term "preupgrade".

Oracle 19c preupgrade.jar and preupgrade checks

Posted on March 18, 2019 by Mike.Dietrich Oracle Database 19c 9

Oracle Database 19c is available for Exadata on-prem for quite a few weeks now. But even if you didn’t download it yet, you may want to use the new 19.2 preupgrade.jar tool to check and examine your database. For this purpose you can find the Oracle 19c preupgrade.jar and preupgrade checks available and documented on MOS.

Oracle 19c preupgrade.jar and preupgrade checks

I received several emails already from customers asking whether they can get the most recent Oracle 19c preupgrade tool without downloading the entire 19c software stack. And thanks to my team mates, the tool is available now in …

Improved preupgrade.jar for Oracle 12.2 and 18c

Posted on September 21, 2018 by Mike.Dietrich Upgrade / Migration 2

My team mates are really quick. We received an information early this week about a missing or wrong DV check in the preupgrade – and they implemented it within a day or so. The September 2018 version of the improved preupgrade.jar for Oracle 12.2 and 18c is available for download.

Improved preupgrade.jar for Oracle 12.2 and 18c

What’s new in this version:

It adds a recycle bin check when the autofixup for dictionary statistics is run
And it updates DV_AUDIT_CLEANUP to 11.2.0.4

Please find the new September versions of:

Oracle 12.2.0.1 preupgrade.jar – build 17
- There’s issue with “creating directories”

New August 2018 preupgrade.jar for upgrades to 18c and 12.2.0.1

Posted on September 4, 2018 by Mike.Dietrich Oracle Database 18c 3

My team mates worked hard to improve release the new August 2018 preupgrade.jar for upgrades to 18c and 12.2.0.1. You can download both from myOracle Support.

New August 2018 preupgrade.jar for upgrades to 18c and 12.2.0.1

As usual, MOS Note: 884522.1 gives you access to the most recent versions of the preupgrade.jar tools (and of course the previous preupgrd.sql and utlu112i.sql scripts). One of the major changes is the inclusion for a check for the XMLCONCAT synonym.

Please find the most recent versions here and exchange your current version of preupgrade.jar with the newer ones.

New August 2018 preupgrade.jar for upgrades to 18c and 12.2.0.1

MOS Note: 884522.1 –

New preupgrade.jar and changes in MOS Note:884522.1

Posted on May 7, 2018 by Mike.Dietrich Best Practice 14

We read and listen to your comments. And that’s why my team mate Byron has added a new preupgrade.jar and changes to MOS Note:884522.1. One reader commented that MOS Note:884522.1 (How to Download and Run Oracle’s Database Pre-Upgrade Utility) does not explain how to “run” the preupgrade tool even though it mentions this in the note’s title.

New preupgrade.jar and changes in MOS Note:884522.1

With MOS Note:884522.1 you can download always the most recent versions of the Oracle 18c and 12.2 preupgrade.jar tools, of the Oracle 12.1.0.2 preupgrd.sql and utluppkg.sql. And you’ll even find the last utlu112i.sql for upgrades …

List of PREUPGRADE checks executed by preupgrade.jar

Posted on April 24, 2018 by Mike.Dietrich Upgrade / Migration 6

List of PREUPGRADE checks executed by preupgrade.jar

Most of you may not care about the checks our Pre Upgrade Check tool preupgrade.jar does. But some may. Especially in cases where you plan to run a command line upgrade unattended via a script. Therefore this List of PREUPGRADE checks executed by preupgrade.jar may help you.

List of PREUPGRADE checks executed by preupgrade.jar

As a result of a joint initiative between our Upgrade Development team and the Support group dealing with upgrade-related SRs we released this MOS Note:

MOS Note: 2380601.1
Database Preupgrade tool check list

Purpose of the new MOS note is to give you a complete list …

Oracle Database 18c: A new preupgrade.jar is available

Posted on March 19, 2018 by Mike.Dietrich Best Practice 2

In case you plan to upgrade a database to Oracle Database 18c: A new preupgrade.jar is available for download from MyOracle Support (MOS).

Oracle Database 18c: A new preupgrade.jar is available

Please download it – as always – from MOS Note:884522.1.

The same MOS note will get you also the most recent versions of the preupgrade.jar for Oracle Database 12.2.0.1 upgrades. Of course you can download also all previous incarnations such as preupgrd.sql for 12.1.0.2 upgrades and even utlu112i.sql for 11g upgrades.

What’s new in preupgrade.jar for Oracle 18c upgrades?

There are a few important and good Improvements and …

preupgrade.jar January 2018 (Build 11) is available now

Posted on January 19, 2018 by Mike.Dietrich Best Practice 12

A new version of the preupgrade.jar January 2018 (Build 11) is available now.

Please download it from MOS Note:884522.1.:

MOS Note: 884522.1 – How to Download and Run Oracle’s Database Pre-Upgrade Utility

Please always download the most recent version as this one is much newer with a lot of improvements compared to the version you get with the default installation. Major changes since the first drop are:

Added load only capabilities.
Improved the interaction with OS
Added more obsolete/deprecated parameters
Improved IPC calls on Windows
Added functionality for aud$unified table partitions.
Added preupgrade and postupgrade automatic fixups
Check for

September 2017 releases of preupgrade.jar and preupgrd.sql are available

Posted on September 11, 2017 by Mike.Dietrich Upgrade / Migration 7

On a regular basis the Database Upgrade Team releases new and improved versions of the preupgrade tools via a MyOracle Support note. And it’s time again: the September 2017 releases of preupgrade.jar and preupgrd.sql are available for download.

September 2017 releases of preupgrade.jar and preupgrd.sql are available

Please ALWAYS download the most recent versions of preupgrade.jar for upgrades to Oracle Database 12.2 and preupgrd.sql (including utluppkg.sql) for Oracle Database 12.1.0.2 upgrade from MOS Note: 884522.1. The version you’ll download is way newer than the version you’ll get with the base installation.

preupgrade.jar – Rel.7 – September 2017

Please …

New version of preupgrade.jar (build 5) is available

Posted on May 31, 2017 by Mike.Dietrich Oracle Database 12.2.0.1 Uncategorized Upgrade / Migration 2

There’s a new and improved version of the preupgrade.jar (build 5 – May 2017) available for download from MyOracle Support:

MOS Note:884522.1: How to Download and Run Oracle’s Database Pre-Upgrade Utility

The same note will get you access also to the most recent builds of preupgrd.sql for upgrades to Oracle Database 12.1 and utlu112i.sql for the unlikely event you’ll have to upgrade a database to Oracle 11.2.0.4.

Please always exchange the version getting installed by default with the version we offer via MOS Note:884522.1 as the downloadable version is usually much newer and improved over the one getting deployed …

Multiple hop upgrades? Execute the matching preupgrade scripts for each hop

Posted on March 20, 2017 by Mike.Dietrich Flaws and Pitfalls Upgrade / Migration 0

We discussed an interesting upgrade case last week together with our upgrade colleagues in Support – and learned the double-hop (or triple-hop) upgrade case is not described in the documentation somewhere.

What is a multiple-hop upgrade?

Triple Jump – Willie Banks – Olympics 1988 Seoul

Actually this describes the case where somebody can’t upgrade directly and has to do several upgrades in a sequence to reach the targeted release. For example, you start of with an Oracle 10.2.0.3 database – and your targeted release is Oracle 12.2.0.1 . A direct upgrade is not possible. I would opt now for Data …

New PREUPGRADE.JAR is available – MOS 884522.1

Posted on November 24, 2016 by Mike.Dietrich Oracle Database 12.2.0.1 Upgrade / Migration 0

As promised – and thanks to everybody from the Database Upgrade Development Team – the new preupgrade.jar for Oracle Database 12.2 is available:

MOS Note:884522.1 – Download and Run Oracle’s Database Pre-Upgrade Utility

And of course the previous preupgrd.sql with the package utlupkkg.sql and the old utlu112i.sql for upgrade to Oracle 11.2.0.4 (which I wouldn’t do anymore) are available as well.

Please ALWAYS use the version downloaded from this MOS note as this version is much newer and better than the version getting shipped due to code freeze dates. And you will recognize that the new preupgrade.jar is now identical …

New AutoUpgrade version 26.6 is available

Posted on September 30, 2026 by Mike.Dietrich AutoUpgrade 24

Yes, the long-awaited new AutoUpgrade version 26.6 is available for download. Again, a fantastic job by our development team. And I know that many of you were waiting for it already since it has some really cool new features, enhancements – and of course, fixes, too.

Photo by Jason Leung on Unsplash

Download AutoUpgrade

As I described already in AutoUpgrade Patching – From Zero to Hero – Part 1: Download AutoUpgrade, you have several ways to fetch the newest version of AutoUpgrade – and when you use it to download patches, it will automatically trigger an update with the …

Upgrade to 26ai may hang due to block checking events

Posted on July 15, 2026 by Mike.Dietrich AutoUpgrade Flaws and Pitfalls Oracle AI Database 26ai Patch Recommendation 0

This issue is caused by an internal change, and we hit this now with two very large customer upgrades recently. Therefore, I would like to point to a fix, a workaround and the following RU in case you see your Upgrade to 26ai may hang due to block checking events.

Upgrade to 26ai may hang due to block checking events

Photo by Nareeta Martin on Unsplash

What would you see?

This issue can happen with cloning, PDB refreshable clones or just a copy or restore of your database for the subsequent upgrade to Oracle AI Database 26ai. It is not dependent on AutoUpgrade but since AutoUpgrade is the only …

The August 2025 version of AutoUpgrade (25.4) is available

Posted on August 5, 2025 by Mike.Dietrich AutoUpgrade 10

This time the AutoUpgrade team did magic and included so many great new features and useful enhancements into the new version of AutoUpgrade. So, please note: The August 2025 version of AutoUpgrade (25.4) is available for download. You should refresh your current versions, especially when you use it for patching, and especially if you attempt to do in an RAC (Real Application Clusters) environment. But read more below.

The August 2025 version of AutoUpgrade (25.4) is available

Photo by Possessed Photography on Unsplash

How to download it?

As usual, that’s very simple. You either download it via the well-known

MOS Note: 2485457.1 – AutoUpgrade Tool

or you fetch …

Should you attempt double-hop Oracle Database upgrades?

Posted on December 13, 2024 by Mike.Dietrich Lifetime Support Policy Oracle Database 19c Oracle Database 23ai Release Schedule 6

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 …

New AutoUpgrade Tool is available in March 2024

Posted on March 19, 2024 by Mike.Dietrich AutoUpgrade 58

It has been a longer while – but the Upgrade Dev team worked very hard. And finally, the new AutoUpgrade Tool is available in March 2024. And it brings a ton of new enhancements and features. Some of them, for instance the windows services support, were awaited by you for a long time. Still, there’s much more to talk about.

Photo by Sergey Shmidt on Unsplash

Download the newest version of AutoUpgrade

As usual, you can download it from MOS Note:2485457.1 – Download AutoUpgrade. And when you check the version, you already find some of the new …

DBUA Deprecation and future Desupport in Oracle Database 23c

Posted on June 21, 2023 by Mike.Dietrich AutoUpgrade DBUA Deprecated / Desupported 16

Daniel pointed me to Tim Hall’s blog post about deprecated and desupported features in Oracle Database 23c. And his first bullet point mentioned is the DBUA Deprecation and future Desupport in Oracle Database 23c. Since Daniel and I agree that this needs a bit more explanation, we would like to share more background information with you.

Photo by Ajeet Mestry on Unsplash

Deprecated vs Desupport?

At first, let me refresh an old topic. What does deprecated mean, and what is the difference to desupport? A long while ago I wrote this blog post about it, and nothing …

Virtual Patching – the biggest nonsense I’ve ever heard about

Posted on August 8, 2022 by Mike.Dietrich Patch Recommendation 16

It’s time for my Monday morning rant. I guess, I’m turning slowly into a grumpy old man. And today, it is about something which came on my radar some weeks ago. After understanding what it means, I declare Virtual Patching – the biggest nonsense I’ve ever heard about.

Photo by Trym Nilsen on Unsplash

Virtual Patching??

If you read this term for the first time, you may scratch your eyes at first as I did weeks ago when I read “Virtual Patching” in a brochure from a company offering Oracle services. I did ask the person …

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 …

Upgrade from 11.2.0.4 to 19c with Label Security Policies

Posted on July 6, 2022 by Mike.Dietrich Flaws and Pitfalls 5

I remember, I have a blog. Forgive me that I don’t write a lot at the moment even though I still have a long queue of “future posts to write”. It is just too busy, and I was away for almost two full weeks in June as well. But let me briefly drop information on an issue I learned about recently. It just affects your when Upgrade from 11.2.0.4 to 19c with Label Security Policies. All other readers may simply ignore this blog post.

Upgrade from 11.2.0.4 to 19c with Label Security Policies

Photo by Erik Mclean on Unsplash

What happens?

You are using Oracle Label Security, and …

Why you can’t stay on Oracle Database 11g forever

Posted on April 6, 2022 by Mike.Dietrich Release Schedule 24

Oracle Database 11g? In 2022? Yes, I know – and you know too – there are Oracle 11g databases out there in production. And blindly I’d say: Too many. Of course, we are the “upgrade guys” trying to convince you to move to Oracle Database 19c. And I bet, for each of your 11g databases there’s a valid and legit reason why they haven’t upgraded yet. But there is one often neglected technical reason Why you can’t stay on Oracle Database 11g forever. So let me explain this below.

Photo by Kristoffer Darj on Unsplash

Oracle Database 11g?

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 …

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 …

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 …

Download the newest AutoUpgrade for 19c and 21c upgrades

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

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

77 Search results

Oracle 19c preupgrade.jar and preupgrade checks

Improved preupgrade.jar for Oracle 12.2 and 18c

New August 2018 preupgrade.jar for upgrades to 18c and 12.2.0.1

New preupgrade.jar and changes in MOS Note:884522.1

List of PREUPGRADE checks executed by preupgrade.jar

Oracle Database 18c: A new preupgrade.jar is available

What’s new in preupgrade.jar for Oracle 18c upgrades?

September 2017 releases of preupgrade.jar and preupgrd.sql are available

preupgrade.jar – Rel.7 – September 2017

What is a multiple-hop upgrade?

Download AutoUpgrade

What would you see?

How to download it?

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

Download the newest version of AutoUpgrade

Deprecated vs Desupport?

Virtual Patching??

What is the intention?

What happens?

Oracle Database 11g?

Why AutoUpgrade 2.0?

How to download AutoUpgrade?

Why do you need a new version?

Upgrade-supported Releases

Download it!

What’s new?

Archives

Categories

Upgrade @YouTube

Subscribe via Email

Recent Posts