Rerun

ORA-2380 profile ORA_STIG_PROFILE does not exist during upgrade to 26ai

Let us start the week with something I wanted to put on the blog for a long time since I have seen some customers being trapped by this in their 26ai upgrade attempts. If you are not upgrading now, you may ignore this blog post safely. But if you are in the process, please check out what you can do to prevent the ORA-2380 profile ORA_STIG_PROFILE does not exist during upgrade to 26ai.

ORA-2380 profile ORA_STIG_PROFILE does not exist during upgrade to 26ai

What’s the problem?

When you attempt an upgrade to Oracle AI Database 26ai, you may get this error sequence in case the ORA_STIG_PROFILE is missing:

06:22:43 
… 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...

Restarting a failed Database Upgrade with catctl.pl

What if …

What if a database upgrade fails in between? First of all you should have enabled one of the common protections for issues happening during an upgrade:

  • Guaranteed Restore Point to Flashback Database
  • Restore an RMAN Online Backup
  • Restore a partial Offline Backup

See our slide’s Fallback section for further details.

But actually there are ways to restart the upgrade without the need to fallback in case of a non-destructive incident such as running out of archivelog space.

Restart the Upgrade before Oracle Database 12c

Before Oracle Database 12c the most simple way to restart an upgrade was …

Continue reading...