Downtime

Certifying an application on a specific RU-only is wrong

Posted on September 14, 2022 by Best Practice Patch Recommendation Release Schedule 15

Well, there are still 80+ comments I need to answer and reply to on the blog. So please be patient – nothing gets deleted or ignored. But it happens that a topic crosses my inbox, and I need to blog about it right now. Today, it is a case where a customer asked me for advice, and mentioned on the side that they are going to 19.6.0 in OCI. In this relation I’d like to explain why Certifying an application on a specific RU- only is wrong.

What’s the story?

At first, …

Continue reading...

Upgrade Testing with a Refreshable PDB – does this work?

Posted on May 5, 2020 by Single-/Multitenant 13

Yesterday, Daniel pinged me to discuss an upgrade testing scenario I had evaluated briefly by myself a while ago. I can’t remember why I gave up. But Daniel had some great ideas and tried already a lot in our OCI cloud. We want to use a refreshable PDB. And keep it up to date, then upgrade it. The idea of this approach: Whereas a CLONE or RELOCATE uses the initial command as the marker, a REFRESH would allow me to be way more in synch. So the question is: Upgrade Testing with a Refreshable PDB – does this work?

Upgrade Testing with a Refreshable PDB - does this work?

Photo

… Continue reading...

3 Live Seminars: Multitenant Seminar 3 Questions answered

Posted on May 3, 2020 by Workshop 0

This is the third and final QA blog post for the Seminars we did in the last week of April 2020. Thank you for your attendance. I will publish the replay recordings as soon as they are available and link them as well. For now, please find here 3 Live Seminars: Multitenant Seminar 3 Questions answered.

3 Live Seminars: Multitenant Seminar 3 Questions answered

Photo by Holger Link on Unsplash

Your Questions, our Answers for Seminar 3: Multitenant

103 We are in the process of migrating to Oracle Cloud using the xtts method for cross platform migration and we seem to be encountering an issue with it
… Continue reading...

Upgrade PDBs with RELOCATE – How does it work?

Posted on January 30, 2020 by Single-/Multitenant Upgrade / Migration 14

Today Roy and I received a question from a colleague about the RELOCATE feature in Multitenant. And I’d like to shed some light and this topic a bit more. Upgrade PDBs with RELOCATE – How does it work?

Upgrade PDBs with RELOCATE - How does it work?

Photo by Sebastian Pena Lambarri on Unsplash

RELOCATE and UPGRADE?

At first, it looks very promising to me. RELOCATE uses the HOT CLONE functionality of Multitenant but then relocates the PDB from one to another CDB. You need to fulfill a few important requirements, for instance:

  • Local Undo must be enabled in both CDBs
    • This limits the technique to at least Oracle
… Continue reading...

Save Patching Downtime with Oracle Multitenant?

Posted on December 2, 2019 by Best Practice Patch Recommendation Single-/Multitenant 8

At OOW 2019 we announced that you can have up to 3 user-created pluggable databases (PDBs) per container database (CDB) without having a Multitenant license. And in this blog post I’d like to demonstrate how you can save patching downtime with Oracle Multitenant.

The Concept

The idea this entire process settles on is very simple. When you create a fresh container database in the target (already patched!) environment, you don’t have to patch this one. You only have to relocate the PDB from the source into the target CDB. In addition, only datapatch needs to be executed. As the …

Continue reading...

Database Migration from non-CDB to PDB – The Minimal Downtime Challenge

Posted on August 13, 2019 by Minimal Downtime Single-/Multitenant 6

There are several pitfalls when you plugin a non-CDB into a CDB environment. I’d like to highlight some of them – and show you potential workarounds as well. This is part of a series of blog posts to make your migration from non-CDB to PDB a bit smoother.

Database Migration from non-CDB to PDB – The Minimal Downtime Challenge

Database Migration from non-CDB to PDB – The Minimal Downtime Challenge

When we start to look at a migration from non-CDB to PDB for an important system, regardless of migrating on-prem or to the cloud, reducing the downtime is very important. In this blog post I’d like to highlight the different aspects …

Continue reading...

The OJVM Patching Saga – and how to solve it – Part V

Posted on February 16, 2017 by JVM Patch Recommendation 5

Related Posts on
“The OJVM Patching Saga – and how to solve it“:

MOS Note released explaining patching without STARTUP UPGRADE mode

An important note regarding OJVM rolling patching has been published on MyOracle Support:

MOS Note: 2217053.1
RAC Rolling Install Process for the “Oracle JavaVM Component Database PSU” (OJVM PSU) Patches

“Beginning with the Jan2017 OJVM PSU patchset for 11.2.0.4 and

… Continue reading...

The OJVM Patching Saga – and how to solve it – Part IV

Posted on February 9, 2017 by JVM Patch Recommendation 1

Related Posts on
“The OJVM Patching Saga – and how to solve it“:

What is missing with the “Mitigation Patch?

Michael, the team lead from a large Oracle customer mailed me the other day. He wanted to disable Java on all their +600 databases by using the Mitigation Patch for OJVM. But he received a strange error when trying to enable the …

Continue reading...

The OJVM Patching Saga – and how to solve it – Part III

Posted on September 14, 2016 by JVM Patch Recommendation 3

Related Posts on
“The OJVM Patching Saga – and how to solve it“:

What is the “Mitigation Patch?

In MOS Note:1929745.1 – Oracle JavaVM Component Database Patches there’s a section called What is the Mitigation Patch. It says:
“For situations where the latest OJVM PSU cannot be installed immediately there is a “Mitigation Patch” that can be used. The “Mitigation …

Continue reading...

The OJVM Patching Saga – and how to solve it – Part II

Posted on September 6, 2016 by JVM Patch Recommendation 4

Related Posts on
“The OJVM Patching Saga – and how to solve it“:

Important Notes

… Continue reading...

The OJVM Patching Saga – and how to solve it – Part I

Posted on September 5, 2016 by JVM Patch Recommendation 20

Related Posts on
“The OJVM Patching Saga – and how to solve it“:

Who’s the Product Manager for Patching?

First of all, I’m neither a patching expert nor am I the Product Manager for Patching. There’s no such role as far as I know but there are people inside Oracle who have way more clue about this topic. There’s a group …

Continue reading...

Save Upgrade downtime: Upgrade APEX upfront

Posted on June 6, 2014 by APEX 5

See also:

Upgrade downtime credited to APEX

With almost every patch or release upgrade of the Oracle Database a new version of Oracle Application Express (APEX) will be installed. And as APEX is part of the database installation it will be upgraded as part of the component upgrades after the ORACLE SERVER component has been successfully upgraded to the new releases.

APEXBut the APEX upgrade can take a bit (several minutes or even more in some cases). Therefore it is a common advice to upgrade APEX upfront before upgrading the database as this can be done online while the …

Continue reading...
Mike Dietrich
Oracle Senior Director of Product Manager for Database Upgrade, Migrations and Patching writing just another blog.

Opinions certainly are my own as is this page.

Archives

Categories

Upgrade @YouTube

Subscribe via Email

Join 7,849 other subscribers

Follow me on Twitter