67 Search results

For the term "preupgrade".

Oracle 19c preupgrade.jar and preupgrade checks

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

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 …

Download the newest AutoUpgrade for 19c and 21c upgrades

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

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

Fixed Objects Stats Gathering Fails – what do you do now?

Posted on November 16, 2020 by Mike.Dietrich Flaws and Pitfalls 0

A few days ago I blogged about what you could do when Fixed Objects Stats Gathering is slow in an upgrade process. You can skip the preupgrade gathering, and the postupgrade gathering does not happen anymore since the October 2020 version of AutoUpgrade. Still, I came across another issue the other day: Fixed Objects Stats Gathering Fails – what do you do now?

Fixed Objects Stats Gathering Fails - what do you do now?

Photo by Spencer Imbrock on Unsplash

What happened?

Actually this is connected to the Fixed Objects Stats Gathering is slow in an upgrade case. The customer encountered an incredible long runtime. And the support engineer …

Patching all my environments with the October 2020 Patch Bundles

Posted on October 22, 2020 by Mike.Dietrich Patch Recommendation 23

I have to confess: Time didn’t allow to rearrange my lab yet to have GI and ASM. Hence, this will be another blog post about Patching all my environments with the October 2020 Patch Bundles with only non-RAC patching. But it is in the works …

Patching all my environments with the October 2020 Patch Bundles

Photo by Olga Guryanova 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.

Security Alert

When Fixed Object Stats Gathering takes very long during upgrade …

Posted on October 20, 2020 by Mike.Dietrich Auditing AutoUpgrade Flaws and Pitfalls 4

Over the past days I exchanged several emails with a very important customer regarding Fixed Objects Stats gathering in relation to database upgrade. The customer found out that it takes very long in their environment – over an hour to be precise. Relaxing on the weekend helped me a bit. And this morning, it dawned me that I’ve had two similar cases before already. Plus I didn’t blog about it yet. Now it’s time to tell you a little but about Unified Auditing and the situation when Fixed Object Stats Gathering takes very long during upgrade …

When Fixed Object Stats Gathering takes very long during upgrade ...

Photo by Ayse

Oracle AutoUpgrade between two servers

Posted on August 3, 2020 by Mike.Dietrich AutoUpgrade 18

I try to catch up with missing AutoUpgrade posts. And I should have written this one a while earlier ideally. Just yesterday a colleague asked me about it. So it’s time now to describe how to use Oracle AutoUpgrade between two servers.

Photo by Alex Motoc on Unsplash

Documentation

The Oracle Database 19c Upgrade Guide has this section about the scenario:

AutoUpgrade with Source and Target Database Homes on Different Servers

And you see that it consists of 5 steps:

Run the -mode analyze step on source server
Run the -mode fixups step on source server
Shutdown and

AutoUpgrade with Transparent Data Encryption (TDE)

Posted on July 30, 2020 by Mike.Dietrich AutoUpgrade TDE - Transparent Database Encryption 4

I knew, one fine day I will have to dig into TDE. Resistance is futile. There were so many questions regarding AutoUpgrade with Transparent Data Encryption (TDE) in the past weeks and months. And the team is still working hard on a solution to make the non-CDB to PDB plugin flawless and automated for such cases. But I won’t cover the latter in this post here. I will solely focus on the database upgrade itself.

AutoUpgrade with Transparent Data Encryption (TDE)

Photo by Jason Dent on Unsplash

TDE?

Almost everybody of you reading this blog post may have more knowledge of Transparent Data Encryption than I. …

How to skip a Fixup in AutoUpgrade

Posted on July 22, 2020 by Mike.Dietrich AutoUpgrade 7

In this blog post I’d like to demonstrate how to skip a fixup in AutoUpgrade. This can be very useful in cases where you know that an issue may happen. Recently we saw several cases with unexpected long runtime for the gathering of fixed objects stats.

Photo by Warren Wong on Unsplash

Analyze Mode

During the analyze phase, AutoUpgrade creates a <SID>_checklist.cfg file. You will find it in your job’s prechecks subdirectory, e.g.

/home/oracle/logs/DB12/100/prechecks

My SID is DB12, and 100 is the job number.

This is how the db12_checklist.cfg looks in my example:

[SID]          [DB12]
==========================================
[container]          [DB12]

3 Live Seminars: Multitenant Seminar 3 Questions answered

Posted on May 3, 2020 by Mike.Dietrich Workshop 0

This is the third and final QA blog post for the Seminars we did in the last week of April 2020. Thank you for your attendance. I will publish the replay recordings as soon as they are available and link them as well. For now, please find here 3 Live Seminars: Multitenant Seminar 3 Questions answered.

3 Live Seminars: Multitenant Seminar 3 Questions answered

Photo by Holger Link on Unsplash

Your Questions, our Answers for Seminar 3: Multitenant

103	We are in the process of migrating to Oracle Cloud using the xtts method for cross platform migration and we seem to be encountering an issue with it

JDK patching happens with every RU since January 2020

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

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”. …

Upgrade: What if your time zone in source is newer than in target?

Posted on April 9, 2020 by Mike.Dietrich Time Zone - DST 11

Sometimes there is just a simple question at the beginning. Like Daniel and I discussed this morning. Does AutoUpgrade check if the time zone file in source is higher than in target? While we discussed this, I downloaded the patches already to try it out. And in addition, I could double-check whether the time zone patches for 19c are now RU-independent finally. But the question remains for Upgrade: What if your time zone in source is newer than in target?

Upgrade: What if your time zone in source is newer than in target?

Photo by Srikanta H. U on Unsplash

My intention wasn’t initially to write a longer blog post. But read below …

OJVM and the Mitigation Patch – Things to know in 2020

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

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 …

How long will my database upgrade take? Revisited …

Posted on March 17, 2020 by Mike.Dietrich Best Practice 6

I received this question twice within a few days. And I remember that a tiny little while ago I wrote something on the blog about it. But as this “while” is 11 years ago, I came to conclusion to refresh this topic – and write something about How long will my database upgrade take? Revisited …

How long will my database upgrade take? Revisited ...

Photo by Aron Visuals on Unsplash

Is there a query?

At first, before I go into details, an important fact upfront: There is neither any query nor any tool giving you a rough estimate or precise figure of how long your upgrade will …

Upgrade Testing – Online Clone a PDB to 19c

Posted on March 6, 2020 by Mike.Dietrich Single-/Multitenant Upgrade / Migration 18

In the past I wrote some articles about cloning PDBs to new environments. And I added a post about RELOCATE as well. But I realized that I have no specific blog post about a very typical scenario: Upgrade Testing – Online Clone a PDB to 19c.

Upgrade Testing - Online Clone a PDB to Oracle 19c

Photo by Jørgen Håland on Unsplash

My Setup

I have an Oracle 12.2.0.1 CDB with a PDB, and another Oracle 19.6.0 CDB. I will hot clone the PDB from 12.2.0.1 to the higher version CDB, and then upgrade the PDB.

Upgrade Testing - Online Clone a PDB to Oracle 19c

The motivation to do it this way is to allow testing for the application …

AutoUpgrade may fail when patch ID column is NULL

Posted on November 25, 2019 by Mike.Dietrich AutoUpgrade 23

Monday morning – it’s time to write a new blog post. And actually I will set priorities based on what you reported to me in the past week. This way it may prevent others from hitting the same pitfall. The AutoUpgrade may fail when patch ID column is NULL in REGISTRY$HISTORY.

AutoUpgrade may fail when patch ID column is NULL

Photo by Etienne Boulanger on Unsplash

What is happening?

You start a database upgrade with autoupgrade. But the initial check will fail with a message like this:

AutoUpgrade tool launched with default options
There was an error initializing the patching information for entry upg2

The AutoUpgrade won’t kick …

67 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 it!

What’s new?

What happened?

Security Alert

Documentation

TDE?

Analyze Mode

Your Questions, our Answers for Seminar 3: Multitenant

JDK who?

Mitigation Patch?

Is there a query?

My Setup

What is happening?

Archives

Categories

Upcoming Events

Upgrade @YouTube

Subscribe via Email

Follow me on Twitter

Recent Posts