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

Monitoring progress during upgrades

The parallel upgrade can resume once an upgrade has stopped for unexpected reasons. Before Oracle 12.2 you can restart it with the -p option specifying the phase it stopped. And since Oracle 12.2 you can only use the -R option to resume it. This blog post will give you a bit more insights in monitoring progress during upgrades.

Monitoring progress during upgrades

Monitoring progress during upgrades

I blogged about the resume options for a while ago:

But you may ask yourself: How does the tool know where to resume? And do you need …

Continue reading...

Oracle RESTART: Make sure you’ve patched your Oracle homes

Oracle RESTART: Make sure you've patched your Oracle homesThis blog post title sounds a bit weird, doesn’t it? Oracle RESTART: Make sure you’ve patched your Oracle homes. Why the heck should you patch your database homes upfront?

Oracle RESTART: Make sure you’ve patched your Oracle homes

Well, there’s an interesting issue happening. When you work with Oracle Grid Infrastructure, no matter if you operate a cluster or “just” use Oracle Restart, you’ll have to upgrade GI to Oracle 12.2 first before you can manage 12.2 databases with it. That’s not new. It’s a well understood rule.

Now guess you operate Oracle RESTART (SIHA …

Continue reading...

Oracle RESTART deprecation announcement got withdrawn

Oracle Restart Deprecation announcementgot withdrawnVery good news for all customers using Oracle RESTART:
The Oracle RESTART deprecation announcement got withdrawn.

I have blogged in the past several times about Oracle RESTART of course either regarding upgrade, downgrade and patching:

And one of the customers I work with for quite a while, Swiss Mobiliar Insurance uses Oracle RESTART for all their Oracle Database environments:

The question all customers I deal with who use Oracle RESTART: How long will Oracle support it? And will there be a successor …

Continue reading...

Restarting a failed Database Upgrade with DBUA 12.2

In my previous blog post I did showcase how to restart a failed database upgrade on the command line before Oracle Database 12c, with Oracle Database 12.1.0.x and with the new Oracle Database 12.2.0.x:

Here I’d like to show the new capability of the Database Upgrade Assistant (DBUA) to restart an upgrade, a functionality the DBUA was missing until now. Please note that you can always go back to the command line, no matter in which version you have used the DBUA.

I won’t describe an upgrade with the DBUA in this …

Continue reading...

ORAchk with new checks + Restart support


Never used or heard about ORAchk? Then it’s time to give it a try! 

ORAchk has now be released. ORAchk has so many great features, especially more than 50 new health checks, OL7 Support – and is now aware of Oracle Restart environments.

New features include:

  • Linux on System Z (RHEL 6, RHEL 7, SuSE 12)
  • Oracle Enterprise Linux 7
  • Single Instance ASM Checks
  • Upgrade Validation checks for
  • Enhanced Golden Gate Checks
  • Enterprise Manager Agent Checks
  • Enhanced Reporting to highlight checks that ORAchk cannot gain
    full visibility for
    (checks that require manual validation)
  • Improved health Score
Continue reading...

Downgrade Oracle Restart 12c – Grid Infrastructure only?

Oracle RestartCan you downgrade your Oracle Restart installation from Oracle 12c back to Oracle 11g?

Actually there’s no real direct downgrade supported for Oracle Restart. But of course there’s a way to do it.

Basically it is:

  • Deconfigure Oracle Restart in 12c
  • Configure Oracle Restart in 11g

But wait a minute. It is very important to know if you have upgraded your database already. If that is the case then first you MUST downgrade your database(s) as you can’t manage a higher version Oracle Database with a lower version Clusterware.

So first of all, please downgrade your Oracle database(s) first:…

Continue reading...