AutoUpgrade

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

AutoUpgrade: ANALYZE, FIXUPS, UPGRADE and DEPLOY modes

AutoUpgrade: ANALYZE, FIXUPS, UPGRADE and DEPLOY modes

Photo by Debby Hudson on Unsplash

In the previous blog posts I explained mainly how to create, alter and tweak the configuration file for the AutoUpgrade tool. By now you should have your config file set up and adjusted for your environment(s). Let me go a step further and explain the different processing modes of AutoUpgrade: ANALYZE, FIXUPS, UPGRADE and DEPLOY modes. Then you’ll have a precise idea what the tool is actually doing, and how it operates.

AutoUpgrade – Step-by-step

  1. The new AutoUpgrade Utility – Download, documentation and supported versions
  2. Create and adjust the config file for
Continue reading...

Config file for AutoUpgrade – Tweaking init parameters

In the previous blog posts I explained how to generate a sample config file for the AutoUpgrade tool and how to adjust it. Then I gave you an overview about the most important Advanced Options you may want or need to deal with when using the utility. And in the below blog post I would like to show you have you need to edit the Config file for AutoUpgrade – Tweaking init parameters is an important topic.

This is the forth post of a series of blog posts regarding the new AutoUpgrade tool. Please find all the other available …

Continue reading...

Config file for AutoUpgrade 19c – Advanced options

Config file for AutoUpgrade 19c – Advanced optionsIn the previous blog post I explained how to create a config file for the AutoUpgrde utility. And now I’d like to show how you can use some important advanced options to have the AutoUpgrade utility do or skip specific tasks. Read about how you can tweak the config file for AutoUpgrade 19c – Advanced options.

I will describe only the most important advanced parameters which I think can be very useful in your environments. Of course, there are many more as you can see in the Database Upgrade Guide.

AutoUpgrade – Step-by-step

  1. The new AutoUpgrade Utility – Download,
Continue reading...

A new version (June 2019) of the AutoUpgrade is available for download

My team mates worked very hard – and many customers did the same. Thanks for all your feedbacks. We tried to help and assist everybody where possible. And here it is. A new version (June 2019) of the AutoUpgrade is available for download.

A new version of the AutoUpgrade is available for download

Download the new AutoUpgrade

Please download the newest version 20190620 of the AutoUpograde from:

and replace your current version with the new one (20190620..

The new version has 51 additional fixes. At the end of MOS Note: you’ll find a list of bugs fixed on X64_190620 update file.

Where

Continue reading...

Create and adjust the config file for AutoUpgrade 19c

Create and adjust the config file for AutoUpgrade 19cThis is the first of a series of blog post explaining the new AutoUpgrade utility step-by-step. You’ll find the tool and overview information in The New AutoUpgrade Utility in Oracle 19c

In this blog post here I will explain and demonstrate how you can create a sample config file and adjust it for a standard database upgrade.

You will see how to add additional options and change default settings. Furthermore, I will showcase how to change, adjust and tweak init.ora parameters during or after upgrade in the upcoming blog posts.

AutoUpgrade – Step-by-step

  1. The new AutoUpgrade Utility – Download,
Continue reading...

The new AutoUpgrade utility in Oracle 19c

The new AutoUpgrade utility in Oracle 19cOracle Database 19c on premises is available – and one of the key features is the new AutoUpgrade utility. In the following days I will publish several blog posts explaining and showcasing the new AutoUpgrade.

What is the AutoUpgrade?

The Oracle Database AutoUpgrade utility is a new tiny little command line tool which allows you to upgrade your databases in an unattended way. I call it the Hands-Free Upgrade. TThe new AutoUpgrade utility in Oracle 19che idea of the tool is to run the prechecks against multiple databases, fix 99% of the potential issues, set a restore point in case something goes wrong …

Continue reading...

Collaborate 2019 – San Antonio, TX – Upgrade Talks and Labs

Collaborate 2019 - San Antonio, TX - Upgrade Talks and Labs

I have to be careful when posting something today. But this is actually not an April’s fool joke. Collaborate Conference is less than a week away. And for me this means: I’m going to Texas for the first time ever. And I hope to see you at Collaborate 2019 – San Antonio, TX – Upgrade Talks and Labs.

Texas?

Collaborate 2019 - San Antonio, TX - Upgrade Talks and LabsWell, stereotypes are great. I live in Bavaria but I’m actually from its Northern part called Franconia. Which belongs geographically to Bavaria but is different. But when you look from any other part of Germany towards its South, …

Continue reading...

DOAG Conference 2018 in Nuernberg – Upgrade and AutoUpgrade talk

DOAG Conference 2018 in Nuernberg - Upgrade and AutoUpgrade talkWell, how do I realize it is November already? When I receive my conference pass for DOAG conference. And actually when the first snow falls right on time when I plan to hit the road. Lovely! If you are coming to DOAG Conference 2018 in Nuernberg – Upgrade and AutoUpgrade talk is the one you should see.

You can’t find “AutoUpgrade” in the official description? Yeah, true. I added this after the Oracle Open World presentation to get you a sense about where upgrade is going to. And beyond … 🙂

DOAG Conference 2018 in Nuernberg – Upgrade

Continue reading...

OOW2018: The new AutoUpgrade for the Oracle Database

As I wrote the other day, OOW 2018 is not too far away anymore. And if you’d like to see something really new, something which can really really ease your database upgrades in the near future, then you may visit our first talk right on Monday morning at OOW2018: The new AutoUpgrade for the Oracle Database.

OOW2018: The new AutoUpgrade for the Oracle Database

What is this talk all about?

First of all, let me emphasize that we don’t do marketing. We would like to introduce you to a brand new tool we’ll currently have in beta operation at selected customers. And which we’ll release in the …

Continue reading...