DBUA

DBUA Deprecation and future Desupport in Oracle Database 23c

Daniel pointed me to Tim Hall’s blog post about deprecated and desupported features in Oracle Database 23c. And his first bullet point mentioned is the DBUA Deprecation and future Desupport in Oracle Database 23c. Since Daniel and I agree that this needs a bit more explanation, we would like to share more background information with you.

Photo by Ajeet Mestry on Unsplash

Deprecated vs Desupport?

At first, let me refresh an old topic. What does deprecated mean, and what is the difference to desupport? A long while ago I wrote this blog post about it, and nothing …

ORA-1422 and ORA-6512 from SYS.DBMS_STATS in Post Upgrade

Posted on May 4, 2021 by Mike.Dietrich Optimizer Patch Recommendation 3

Ernst Leber sent me an email today. He hit an error at a customer upgrading to Oracle 19.9.0 on Exadata with AutoUpgrade. ORA-1422 and ORA-6512 from SYS.DBMS_STATS in Post Upgrade were signaled – and he better flashed back to the Guaranteed Restore Point. He found even a MOS note but still had questions. So time to blog about it in case you hit this error sequence as well.

ORA-1422 and ORA-6512 from SYS.DBMS_STATS in Post Upgrade Phase

Photo by Kelly Sikkema on Unsplash

What happens, and when does it happen?

At first, this is not an AutoUpgrade issue. You may see the same error stack in the post upgrade …

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

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

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 …

ORA-1722 when upgrading to 19.4.0 or 19.5.0 on Windows

Posted on December 18, 2019 by Mike.Dietrich Flaws and Pitfalls 17

Oh boy – I try to avoid blogging about errors on a specific platform. But as this topic was brought to my attention now 3x in 2 weeks, I think I’ll send it out. And I hope you won’t hit this ORA-1722 when upgrading to 19.4.0 or 19.5.0 on Windows.

ORA-1722 when upgrading to 19.4.0 or 19.5.0 on Windows

What is failing?

The database upgrade only on the MS Windows platform fails when you attempt to upgrade to 19.4.0 or 19.5.0. This means, you downloaded and installed 19.3.0. And then you followed our advice and applied one of the most recent Release Update – ideally 19.5.0, the October …

Fallback Strategy: Partial Offline Backup

Posted on July 17, 2018 by Mike.Dietrich Fallback 2

Oh, I think it took us years to get rid of recommendations in MOS notes saying before this or that change you must take an offline backup. These recommendations dated back to times where not almost everybody was using RMAN for online backups. But the times have changed. Still, there are situations where the “Offline Backup” word can be mentioned. And in this blog post I will describe a Fallback Strategy: Partial Offline Backup.

Usage Scenario

This method will only protect you against failure during an upgrade.

First of all, Offline Backup sounds really brutal and old-fashioned. …

Upgrade to Oracle Database 12.2 – New MOS Notes

Posted on March 6, 2017 by Mike.Dietrich MyOracle Support Upgrade / Migration 23

Some very helpful MOS Notes got published regarding the upgrade to Oracle Database 12.2.0.1:

Furthermore check regularly for Known Issues and Alerts – currently the note has no content but exists already:

MOS Note: 2239820.1
12.2.0.1 Base Release – Availability and Known Issues

Cheers
–Mike…

Restarting a failed Database Upgrade with DBUA 12.2

Posted on January 25, 2017 by Mike.Dietrich catctl.pl DBUA Oracle Database 12.2.0.1 27

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:

Restarting a failed Database Upgrade with catctl.pl

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 …

Upgrades to Oracle Database 12.2.0.1 (and Downgrades)

Posted on November 8, 2016 by Mike.Dietrich Oracle Database 12.2.0.1 Upgrade / Migration 39

Oracle Database 12c Release 2 (12.2) is available now in the Oracle Cloud in DBCS and ECS in both NAS and EMEA zones, as well as being available on Exadata Express Cloud Service. The Oracle Database 12.2 documentation should be published later today.

Just to note down, the versions supporting direct upgrade either with catctl.pl on the command line or with DBUA are:

Oracle Database 11.2.0.3
Oracle Database 11.2.0.4
Oracle Database 12.1.0.1
Oracle Database 12.1.0.2

Direct Upgrade to Oracle Database 12.2

No direct upgrades are supported from versions below Oracle Database 11.2.0.3.

For versions older than Oracle Database 11.2.0.3 other tools such as Data Pump or …

DBUA and Read-Only Tablespaces – Things to Know II

Posted on March 30, 2016 by Mike.Dietrich DBUA Flaws and Pitfalls Oracle Database 12c 3

Related Blog Posts:

Thanks to Rodolfo Baselli commenting on a previous blog post about the DBUA and Read-Only Tablespaces I dug a bit deeper and found out that “assuming silently” does not mean “works as intended“.

But one piece after another.

Rodolfo commented that if he …

DBUA and Read-Only Tablespaces – Things to Know – I

Posted on February 3, 2016 by Mike.Dietrich DBUA Flaws and Pitfalls Oracle Database 12c 13

Related Blog Posts:

Some people prefer the manual upgrade on the command line, others prefer the graphical tool Database Upgrade Assistant (DBUA).

DBUA and Read-Only Tablespaces

The DBUA offers you an option of setting your non-Oracle tablespaces read-only during the upgrade.

DBUA Read Only 1

What the option doesn’t tell you …

No OS Authentication? datapatch will fail in every upgrade

Posted on September 29, 2015 by Mike.Dietrich Patch Recommendation 4

Thanks to Daniel from SimCorp for bringing this to my attention: Patch

Actually, command line upgrades are affected as well, if you do not use OS authentication.
Apparently, datapatch is not able to execute in non-OS authentication mode.
See MOS note 1635007.1.

Symptom:

You are doing a command line upgrade to Oracle Database 12c with catctl.pl – and you don’t use OS authentication allowing connections with “/ as sysdba” then datapatch.pl won’t be able to execute the SPU/PSU/BP related SQL commands as it will fail to connect to your database with an ORA-1017 (invalid username/password) error.

Solution:

Bug 18361221 …

DBUA displays wrong RMAN backup for restore – Oracle 12.1.0.2

Posted on September 21, 2015 by Mike.Dietrich DBUA Flaws and Pitfalls Oracle Database 12c 4

Related Blog Posts:

If you are using the Database Upgrade Assistant (DBUA) to upgrade your database to Oracle Database 12.1.0.2 be aware when you choose to potentially restore your database from a existing backup in case of an error during the upgrade.

First of all I would always stop DBUA …

DBUA 12c and “datapatch.pl” – things to know

Posted on July 20, 2015 by Mike.Dietrich DBUA Patch Recommendation 33

For clarification:
The following blog post applies to upgrades to Oracle 12.1 done by DBUA only whenever a SPU/PSU/BP is installed into the 12.1 home prior to the upgrade (which I’d highly recommend as patching before upgrade saves you headache after upgrade!).

Update [Dec 10, 2015]:
The required patch is included in 12.1.0.2BP13 but not 12.1.0.2.PSU5 (Oct 2015) – it will be included in the 12.1.0.2.PSU6 (Jan 2016) and all following PSUs.

Update:
For Oracle Database 12.2 and newer please see:
https://mikedietrichde.com/2017/05/25/dbca-execute-datapatch-oracle-database-12-2/

Two customers independently reported last week that they have doubts on DBUA’s ability to apply the required SQL …

New MOS Notes on Database Upgrades for 12c with or without Oracle Multitenant

Posted on January 13, 2015 by Mike.Dietrich MyOracle Support Oracle Database 12c Single-/Multitenant 1

Please find some new MyOracle Support (MOS) Notes about Database Upgrades to Oracle Database 12c, with or without Oracle Multitenant:

MOS Note: 1503653.1
Complete Checklist for Manual Upgrades to Oracle Database 12c Release 1 (12.1)
.
MOS Note: 1932762.1
Complete checklist for manual upgrade from 12.1.0.1 to 12.1.0.N (Full CDB Upgrade)
.
MOS Note: 1933391.1
Complete checklist for 12c R1 PDB upgrade (Upgrading single/multiple PDB)
.
MOS Note: 1932340.1
How to execute sql scripts in Multitenant environment (catcon.pl)
.
MOS Note: 1933011.1
Complete Checklist for DBUA Upgrade from 12.1.0.1 to 12.1.0.N
.

Credits for the CDB/PDB Notes go to

DBUA can ignore underscores with “keepHiddenParams”

Posted on June 16, 2014 by Mike.Dietrich DBUA 0

Important Update (Aug 17, 2019):
This option does not exist since Oracle 18c anymore due to bug 26762080. Instead you could try to use dbua -initParam (just be aware that you can’t pass on an event with this option).

——————-

The Database Upgrade Assistant (DBUA) is the graphical tool to upgrade Oracle databases. And the DBUA removes underscore parameters by default from the SPFILE when upgrading a database. If you don’t want this, there’s a way to tell it how DBUA can ignore underscores with “keepHiddenParams”.

DBUA can ignore underscores with “keepHiddenParams”

The DBUA by default will remove all …

DBUA

ORA-1422 and ORA-6512 from SYS.DBMS_STATS in Post Upgrade

What happens, and when does it happen?

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

ORA-1722 when upgrading to 19.4.0 or 19.5.0 on Windows

What is failing?

Fallback Strategy: Partial Offline Backup

Usage Scenario

Upgrade to Oracle Database 12.2 – New MOS Notes

Restarting a failed Database Upgrade with DBUA 12.2

Upgrades to Oracle Database 12.2.0.1 (and Downgrades)

DBUA and Read-Only Tablespaces – Things to Know II

But one piece after another.

DBUA and Read-Only Tablespaces – Things to Know – I

DBUA and Read-Only Tablespaces

No OS Authentication? datapatch will fail in every upgrade

Symptom:

Solution:

DBUA displays wrong RMAN backup for restore – Oracle 12.1.0.2

DBUA 12c and “datapatch.pl” – things to know

New MOS Notes on Database Upgrades for 12c with or without Oracle Multitenant

DBUA can ignore underscores with “keepHiddenParams”

DBUA can ignore underscores with “keepHiddenParams”

Archives

Categories

Upgrade @YouTube

RSS Feed for Upgrade your Database – NOW!

Subscribe via Email

Recent Posts

Follow me on Twitter