preupgrade.jar

OJVM and the Mitigation Patch – Things to know in 2020

Posted on March 31, 2020 by Mike.Dietrich JVM 10

Today my headline sounds a bit like “Little Red Riding Hood and the Big Bad Wolf” – but there is a reason why I’d like to write about about OJVM and the Mitigation Patch – Things to know in 2020. We are working with a customer right now where preupgrade.jar gave a warning about the existence of the Mitigation patch in an 11.2.0.4 home – despite the fact that JAVAVM is not configured in this database. And this looked strange to us.

Photo by Šárka Jonášová on Unsplash

Mitigation Patch?

A quick search on my blog shows me that …

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 –

Oracle Database 18.3.0 Upgrade on premises

Posted on July 26, 2018 by Mike.Dietrich Upgrade / Migration 2

As Oracle Database 18c is now available on Linux on premises, I blogged about the installation already. And the next logical step is the Oracle Database 18.3.0 Upgrade on premises. In this case I will show an upgrade on the command line from Oracle 11.2.0.4 to Oracle 18.3.0. A DBUA upgrade will follow in a separate blog post later.

Oracle Database 18.3.0 Upgrade on premises

Before you can start with the upgrade, you may download the software first, and then install it:

If …

Upgrade Oracle 12.2.0.1 to Oracle Database 18c on-premises

Posted on June 18, 2018 by Mike.Dietrich Upgrade / Migration 6

Upgrade Oracle 12.2.0.1 to Oracle Database 18c on-premises I’m currently refreshing our Hands-On Lab and will exchange Oracle 12.2.0.1 with Oracle 18.2.0. This blog post series is about how to Upgrade to Oracle 12.2.0.1 to Oracle Database 18c on-premises. There are other blog posts available you may use by yourself if you plan to refresh the lab by yourself until we uploaded a newer version. And it’s actually a good exercise.

For Multitenant upgrades from Oracle 12.1.0.2 to Oracle 12.2.0.1 you may read this:

Upgrade Everything

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 …

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 …

preupgrade.jar

OJVM and the Mitigation Patch – Things to know in 2020

Mitigation Patch?

Improved preupgrade.jar for Oracle 12.2 and 18c

Improved preupgrade.jar for Oracle 12.2 and 18c

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

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

Oracle Database 18.3.0 Upgrade on premises

Oracle Database 18.3.0 Upgrade on premises

Upgrade Oracle 12.2.0.1 to Oracle Database 18c on-premises

New preupgrade.jar and changes in MOS Note:884522.1

New preupgrade.jar and changes in MOS Note:884522.1

List of PREUPGRADE checks executed by preupgrade.jar

List of PREUPGRADE checks executed by preupgrade.jar

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

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

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

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

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

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

preupgrade.jar – Rel.7 – September 2017

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

New PREUPGRADE.JAR is available – MOS 884522.1

Archives

Categories

Upgrade @YouTube

RSS Feed for Upgrade your Database – NOW!

Subscribe via Email

Recent Posts

Follow me on Twitter