catctl.pl

CDB upgrades – explaining catctl_options

When you upgrade your entire CDB with AutoUpgrade, there is a parameter which allows you some tuning or tweaking. And I often see some misunderstanding here. Therefore, for CDB upgrades – explaining catctl_options is my focus today.

CDB upgrades - explaining catctl_options

Photo by Arthur Mazi on Unsplash

catctl_options – what it is meant for

This AutoUpgrade config file parameter allows you to set specific settings, mostly for tuning, but also to override some defaults. In the documentation you will find the whole list of options. You can set it in your AutoUpgrade config file, e.g.:

upg1.catctl_options=-T

catctl_options in CDB upgrades

Here, …

Monitoring catctl.pl progress during upgrades

Posted on April 17, 2018 by Mike.Dietrich catctl.pl 0

The parallel upgrade catctl.pl 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 catctl.pl progress during upgrades.

Monitoring catctl.pl progress during upgrades

I blogged about the resume options for catctl.pl a while ago:

Restarting a failed database upgrade with catctl.pl

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

Can I restart a failed Multitenant Upgrade as well?

Posted on May 11, 2017 by Mike.Dietrich catctl.pl Single-/Multitenant Upgrade / Migration 7

A while back I did blog about the new -R option of the parallel upgrade tool catctl.pl in Oracle Database 12.2.

Restarting a failed Database Upgrade with catctl.pl

And in case you will do a real Multitenant upgrade and fail – as it happened to me today due to “no space left on device” (no audit files could be written anymore) I tried the -R option as well based on Joe’s (our lead catctl.pl developer) recommendation:

$ $ORACLE_HOME/perl/bin/perl catctl.pl -n 6 -R -l /home/oracle/mike2 catupgrd.sql

Argument list for [catctl.pl]
Run in                c = 0
Do not run in

Upgrade to Oracle Database 12.2 and Converting it into an 12.2 PDB (plugin)

Posted on March 8, 2017 by Mike.Dietrich catctl.pl Oracle Database 12.2.0.1 Oracle Database 12c Single-/Multitenant Upgrade / Migration 18

2 customers requested a bit more explanation on how to:
Convert and Plugin an Oracle 12.1 non-CDB database into an Oracle 12.2 container database

Cool, I like that 🙂 I will do this right away and use the approach to Upgrade first, then Plugin afterwards.

Upgrading an Oracle 12.1.0.2 database to Oracle 12.2.0.1

First the preupgrade.jar must be executed – please download always the most recent version from MOS Note:884522.1 as the version we publish is usually newer including important improvements (and fixes) than the version you’ll get with the release drop. We are working on including always the …

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 29

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 …

Restarting a failed Database Upgrade with catctl.pl

Posted on January 24, 2017 by Mike.Dietrich catctl.pl Oracle Database 12.2.0.1 4

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 …

How to SET TIMING ON for parallel upgrades to 12c?

Posted on November 6, 2013 by Mike.Dietrich catctl.pl 2

Annotation:
This hack is not necessary anymore since Oracle Database 12.1.0.2 as TIMING ON is the standard as well as ECHO ON. Please don’t edit catupses.sql by yourself.

Have you asked yourself how to get timings in an Oracle Database 12c upgrade for all statements?

When you run the parallel upgrade via catctl.pl, the parallel upgrade Perl driving script in Oracle Database 12c, you may also want to get timings written in your logfile during execution. As catctl.pl does not offer an option yet the best way to achieve this is to edit the catupses.sql script in $ORACLE/rdbms/admin as this …

catctl.pl

CDB upgrades – explaining catctl_options

catctl_options – what it is meant for

catctl_options in CDB upgrades

Monitoring catctl.pl progress during upgrades

Monitoring catctl.pl progress during upgrades

Can I restart a failed Multitenant Upgrade as well?

Upgrade to Oracle Database 12.2 and Converting it into an 12.2 PDB (plugin)

Upgrading an Oracle 12.1.0.2 database to Oracle 12.2.0.1

Restarting a failed Database Upgrade with DBUA 12.2

Restarting a failed Database Upgrade with catctl.pl

What if …

Restart the Upgrade before Oracle Database 12c

How to SET TIMING ON for parallel upgrades to 12c?

Archives

Categories

Upgrade @YouTube

RSS Feed for Upgrade your Database – NOW!

Subscribe via Email

Recent Posts