Parallel Upgrade

Virtual Classroom: Database Upgrade Internals – and so much more

Register here!

for Feb 10, 2021 – 10:00h CET

Virtual Classroom Web Seminar No.8:

Database Upgrade Internals – and so much more

Do you want to speed up your database upgrades? Did you ever ask yourself what AutoUpgrade does in the background? And do you want to know what all the logfiles are meant for? Or how you monitor 20 database upgrades with one simple call? In this webinar, we’ll not only cover database upgrade internals—we want to deliver real insights. We’ve invited Frederick Alvaraz from the AutoUpgrade development team to join us and share his expertise.

In addition, …

Continue reading...

OOW2014 – Upgrade in a Multitenant Environment

On Sept 30, 2014 at Oracle OpenWorld, Joseph Errede gave his excellent talk about all the tech details in catctl.pl focusing on what happens when you upgrade a multitenant environment. The presentation is very technical explaining many of the switches of catctl.pl. If you’d like to get the slides please find them either in the Slides Download Center to the right or directly via this link:

–Mike…

Continue reading...

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

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 …

Continue reading...