AutoUpgrade

AutoUpgrade: Refresh Status Information automatically

I have heard and received this question several times. And I always pointed people to the status logs in AutoUpgrade’s logging directory. But I wasn’t aware how simple the monitoring can be. Kudos to my colleague Meir Burmanov from Oracle Israel for explaining me today how you can simply monitor AutoUpgrade: Refresh Status Information automatically.

Like it – and it’s very simple

This won’t be a long blog post. And maybe there are even more fancier ways to do the monitoring. But for me it does the job. And it is super simple. …

Continue reading...

Upgrade Seminars 2020 – Recap and Videos on-demand

Thank you for participating in our 4 Database Upgrade to Oracle 19c seminars in the past two weeks. There were over 800 questions during the seminars – and it was a good idea that we prerecorded them. This way, I could answer your questions as it was a more convenient time for me than for Roy. We enjoyed it a lot – and from the feedback I read, most of you enjoyed it, too. Now please read about Upgrade Seminars 2020 – Recap and Videos on-demand below.

The Slides

I uploaded all 4 decks …

Continue reading...

Upgrade Seminars 1 and 2 – A quick recap, slides download and more

Thank you for participating in the first two seminars. Roy and I did already the “Release and Patching Strategy” webinar on Tuesday, June 23. And today  “AutoUpgrade to Oracle 19c”. So it time for Upgrade Seminars 1 and 2 – A quick recap, slides download and more.

Upgrade Seminars 1 and 2 - A quick recap, slides download and more

Photo by v2osk on Unsplash

Slides Download

I uploaded the slides already to https://mikedietrichde.com/slides/#WEB2020. Of course, I will upload the other slide decks as well to the same location.

Seminar Recordings

As soon as the recordings page has been completed, we will send out an email. And I will post the links …

Continue reading...

Upgrade to Oracle Database 19c – Virtual Classroom Series

Roy and I delivered a similar seminar already for the Australia and New Zealand region. And now it is time at a more convenient time zone setting for EMEA and India. So if you are not tired of web seminars yet, please sign up for our Upgrade to Oracle Database 19c – Virtual Classroom Series.

Upgrade to Oracle Database 19c - Virtual Classroom Series

Photo by Bima Rahmanda on Unsplash

4 Web Seminars – Going far beyond upgrades

The idea for this series of 4 web seminars is to cover not only the database upgrade itself. You will get much more than technical upgrade information. And we will …

Continue reading...

AutoUpgrade in trouble when you are short on RAM

Actually I blog about this topic for the simple reason that currently you won’t find helpful information in MyOracle Support. And I’ve seen this issue now twice in a row at Enterprise customers. You may see AutoUpgrade in trouble when you are short on RAM. During one of the restarts AutoUpgrade initiates you may get an ORA-600.

AutoUpgrade in trouble when you are short on RAM

Photo by Vadim Sadovski on Unsplash

What you may see

At first, the alert.log – and this is the strange pattern here – does not give you any indication about this ORA-600. You will find it only in the logs written by autoupgrade.jar:…

Continue reading...

AutoUpgrade and Plug In to a CDB – with a single command (and video)

I have to confess, this feature is out and available for quite a while. But only unofficially. AutoUpgrade can upgrade and plug in a non-CDB into a CDB. But it lacked flexibility. And we didn’t test it a lot. Hence, you could find it documented in our Hands-On Lab instructions. And we did this exercise with you already in our sold-out labs at OOW 2019 as well. But since a week and a bit, it is officially supported: AutoUpgrade and Plug In to a CDB – with a single command (and video).

AutoUpgrade and Plug In to a CDB - with a single command (and video)

Photo by William Daigneault on Unsplash

Create

Continue reading...

4+1 Seminars: Upgrade, Migrate, Consolidate to 19c – not only for Australia

Actually this weekend Roy and I would have flown from Australia to New Zealand. We planned at least 5 seminars. And we’ll do them in person as soon as conditions allow. If you are not tired yet of all these seminars offered to you, then we have the right offering for you.

And not only for those of you based in Australia and New Zealand. Singapore, Japan, Korea and other countries in this part of the globe. Roy and I will run for 4+1 Seminars: Upgrade, Migrate, Consolidate to 19c – not only for

Continue reading...

3 Live Seminars: Upgrade and Performance Seminar 2 Questions answered

Thanks a lot to all of you who participated also in our second seminar. Below you find now 3 Live Seminars: Upgrade and Performance Seminar 2 Questions answered.

3 Live Seminars: Upgrade and Performance Seminar 2 Questions answered

Photo by Karl Lee on Unsplash

Your Questions, our Answers for Seminar 2: Upgrade and Performance

I this blog post I answer all questions from the second seminar about AutoUpgrade to Oracle 19c and Performance Stability. Please find the links to the other QAs for Seminar 1 (Release Strategy, Patching and Cool Features) and Seminar 3 (Migration to Multitenant) below in the Links section of this blog post.

39 We need
Continue reading...

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

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 …

Continue reading...

Troubleshooting, Restoring and Restarting AutoUpgrade

What if … something goes wrong during your database upgrade with AutoUpgrade? Of course, this never happens. But just in case, no worries – one of the really big advantages of AutoUpgrade (and the command line upgrade with “dbupgrade” as well) is its resumability and restartablity. But in this blog post I would like to cover a bit more. I will show you more details on Troubleshooting, Restoring and Restarting AutoUpgrade.

Troubleshooting, Restoring and Restarting AutoUpgrade

Photo by Mark Boss on Unsplash

And as often, the cause for this blog post is an email from Hervé Schweitzer, the CTO of dbi-services. Hervé told …

Continue reading...

Oracle Database Upgrade – Quick Start Guide available

If you don’t deal with databases upgrades every day but just want to see a short and good overview about how to do a successful database upgrade, then this is for you. A few days ago we’ve made the Oracle Database Upgrade – Quick Start Guide available for download.

Oracle Database Upgrade - Quick Start Guide available

Photo by Daniel Leone on Unsplash

Why a Quick Start Guide?

If database upgrades are your daily topic, you won’t need our quick start guide. But if you need a short overview about the right steps to approach an upgrade, this guide is for you. Thanks to my PM colleague,

Continue reading...

AutoUpgrade – New Version with RAC Database Upgrade Support

Thanks to all our customers who participated in our evaluation test for RAC upgrade support with the AutoUpgrade Tool. And my colleagues worked hard to deliver the new version as quickly as possible. Just to make sure: This is not an April’s fools blog post. Since 2 days, you can download AutoUpgrade – New Version with RAC Database Upgrade Support.

AutoUpgrade - New Version with RAC Database Upgrade Support

Picture by: Jason Yuen on Unsplash

Where to download it?

As usual, you can download the newest version – in this case 19.8 aka 20200327 from MOS Note: 2485457.1:

You simply copy the new version into your 19c (or …

Continue reading...

OJVM and the Mitigation Patch – Things to know in 2020

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.

OJVM and the Mitigation Patch - Things to know

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

Mitigation Patch?

A quick search on my blog shows me that …

Continue reading...

AutoUpgrade and the COMPATIBLE parameter

Several times I’ve got asked by customers if AutoUpgrade does change the COMPATIBLE parameter. So let me explain what happens to COMPATIBLE when you upgrade. And give you also some hints about AutoUpgrade and the COMPATIBLE parameter.

AutoUpgrade and the COMPATIBLE parameter

Photo by Ivana Cajina on Unsplash

Does AutoUpgrade change COMPATIBLE?

No. Clearly, AutoUpgrade does not change the COMPATIBLE parameter for several reasons. At first, we recommend to not change the COMPATIBLE parameter right after the upgrade if you can afford another downtime soon after. By keeping COMPATIBLE on the previous (before upgrade) value, you have the choice to revert back to the previous …

Continue reading...

Do you need to license Java for AutoUpgrade?

Actually this question came up internally. I did have no doubt that you don’t have to license Java in order to use AutoUpgrade. But a colleague had such doubts. So let’s clarify: Do you need to license Java for AutoUpgrade?

Do you need to license Java for AutoUpgrade?

Photo by nousnou iwasaki on Unsplash

Or phrased in a different way: “Since Java 8 requires a Java subscription now. Does autoupgrade come with a license?

Do you?

Of course, No!

But where do the doubts come from? Actually this link here does not list the “Oracle Database” as a product. But there is this MOS Note

Continue reading...

Canada rocks – and is really cold in winter

Last week I’ve had one of those travel weeks where I accumulate many working hours already by flying and having layovers and delays at lovely airports. Plus of course, I work in addition and deliver full-day workshops. And see customers. Still, I won’t complain as I like my job a lot. Especially meeting with customers and discussing various upgrade and migration topics can be really challenging sometimes. And I can confess, Canada rocks – and is really cold in winter. Seriously …

Canada rocks - and is really cold in winter

One of these weeks …

When you travel to Canada in winter, especially in a January, you can …

Continue reading...

January 2020 AutoUpgrade is available for download

All of you upgrading your databases with AutoUpgrade or planning to do so can now download the newest version of our AutoUpgrade tool. We are offering the 20191220 version. If you ask yourself why we release the December version in January 2020, there’s a simple answer. We do extensive system testing with it before releasing it to the public.

January 2020 AutoUpgrade is available for download

Photo by pixel | visuals – Patrick Humm on Unsplash

Download 20191220 AutoUpgrade

You can always download the newest and some previous versions of the AutoUpgrade tool via this note:

January 2020 AutoUpgrade is available for download

At the bottom of the …

Continue reading...

AutoUpgrade Tips: Running two (or more) sessions in parallel

Our intention with the AutoUpgrade as the single tool to upgrade your databases was initially: You have one big config file for your databases. And you will use this file to upgrade your databases unattended. Ideally you run an “analyze” at first, then you schedule a “deploy” for overnight or the next weekend or whenever it is convenient for you. But sometimes people have different needs. In this particular case several people asked whether you can run multiple AutoUpgrade tools in parallel on the same server. Hence, I’d like to explain the first of more AutoUpgrade …

Continue reading...

AutoUpgrade may fail when patch ID column is NULL

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 …

Continue reading...

DOAG 2019 – Recap and a personal complaint

Nürnberg and München are just 175 km away from each other, a bit more than 1 hour by train. Still I felt a post-conference blues already when I boarded the ICE train yesterday to head back to the south. It was an awesome conference – again. Except for one thing which I will write about below. So here’s my report on DOAG 2019 – Recap and a personal complaint.

DOAG 2019 - Recap and a personal complaint

Photo by Philippe Mignot on Unsplash

DOAG 2019 – What an agenda

I knew it before already. But my VP, Roy Swonger, visited DOAG Conference in Nürnberg for the first time. …

Continue reading...

The September 2019 AutoUpgrade – and the AutoUpgrade Video

My team mates work really hard. And I’m really proud on all of them. We try to fix upcoming issues or requirements with the new AutoUpgrade tool as quickly as possible and still maintain very high quality standards. And here it is, the September 2019 AutoUpgrade – and the AutoUpgrade video as a bonus in addition. Just in case you haven’t seen it in action and can’t join us at OOW 2019.

The September 2019 AutoUpgrade - and the AutoUpgrade Video

Download the September 2019 AutoUpgrade Tool

You can simply download the tool from MOS Note: 2485457.1 – AutoUpgrade Tool.

MOS Note: 2485457.1 – AutoUpgrade Tool:

Watch the AutoUpgrade Video

I just uploaded …

Continue reading...

AutoUpgrade and Data Guard, RAC, Restart and non-CDB to PDB

I need to bring this blog post forward about AutoUpgrade and Data Guard, RAC, Restart and non-CDB to PDB. Initially I planned to write this a bit later. But some of you had questions or were wondering why AutoUpgrade hasn’t done certain tasks. Hence, I’d like to clarify what AutoUpgrade can do, what it can’t and what you’ll have to do at the moment.

I refer to the AutoUpgrade tool as of July 2019. In later versions, one or the other restriction may be lifted. I will blog about it then as well.

AutoUpgrade and Data Guard, RAC, Restart and non-CDB to PDB

AutoUpgrade – Step-by-step

  1. The new AutoUpgrade
Continue reading...

Please download the new July 2019 (20190715) AutoUpgrade

Since last night, the new version of the AutoUpgrade utility is available. Please download the new July 2019 (20190715) AutoUpgrade and exchange your previous version in your destination $ORACLE_HOME/rdbms/admin with this one.

Download

Please download the tool from: MOS Note: 2485457.1 – AutoUpgrade Tool

When you copied the new tool, call it for a version check to make sure you are using the most recent one:

$ java -jar $OH19/rdbms/admin/autoupgrade.jar -version
build.version 20190715
build.date 2019/07/15 12:45:48

Please notice that the tool allows you to upgrade to Oracle 12.2.0.1 and Oracle 18c as well:

 

Please download the new July 2019 (20190715) AutoUpgrade

The listed releases are the minimum …

Continue reading...

AutoUpgrade: Where do you find all the logfiles?

AutoUpgrade: Where do you find all the logfiles?In the previous blog posts you could read about how to create the configuration file, adjust it and tweak the init parameters for the AutoUpgrade tool. And then I described the different modes of it. In this blog post I’d like to give you some insights into AutoUpgrade: Where do you find all the logfiles?

AutoUpgrade: Where do you find all the logfiles?

AutoUpgrade – Step-by-step

  1. The new AutoUpgrade Utility – Download, documentation and supported versions
  2. Create and adjust the config file for AutoUpgrade
  3. Config file for AutoUpgrade – Advanced options
  4. Config file for AutoUpgrade – Tweaking init parameters
  5. AutoUpgrade: ANALYZE, FIXUPS, UPGRADE and DEPLOY modes
  6. AutoUpgrade:
Continue reading...