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 …

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 …

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 …

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 …

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 …

New Slides – and a discussion about Dictionary Statistics

Posted on April 3, 2012 by Mike.Dietrich DBUA Optimizer 5

First of all we have just upoaded a new version of the Upgrade and Migration Workshop slides with some added information. So please feel free to download them from here.The slides have one new interesting information which lead to a discussion I’ve had in the past days with a very large customer regarding their upgrades – and internally on the mailing list targeting an EBS database upgrade from Oracle 10.2 to Oracle 11.2.

Why are we creating dictionary statistics during upgrade?

I’d believe this forced dictionary statistics creation got introduced with the desupport of the Rule Based Optimizer in …

DBUA

Restarting a failed Database Upgrade with DBUA 12.2

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

DBUA displays wrong RMAN backup for restore – Oracle 12.1.0.2

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

DBUA can ignore underscores with “keepHiddenParams”

DBUA can ignore underscores with “keepHiddenParams”

New Slides – and a discussion about Dictionary Statistics

Archives

Categories

Upgrade @YouTube

RSS Feed for Upgrade your Database – NOW!

Subscribe via Email

Recent Posts

Follow me on Twitter