19.11.0

UNDO_RETENTION not inherited to PDBs anymore since 19.9.0

Posted on July 12, 2021 by Mike.Dietrich Behavior Change 15

Behavior changes introduced via a bug fix may not be something you like a lot. And thanks to Sreedhar from one of our most important customers I learned on the weekend: UNDO_RETENTION not inherited to PDBs anymore since 19.9.0.

UNDO_RETENTION not inherited to PDBs anymore since 19.9.0

Photo by Ben Wicks on Unsplash

What is happening before 19.9.0?

Until Oracle 19.8.0 you could change the UNDO_RETENTION in the CDB$ROOT, and it applied to all PDBs automatically. You may or may not have cared. But there are cases when you’d like to change an undo related parameter in the CDB$ROOT without its propagation into all PDBs.

This behavior …

AutoUpgrade may run into a timeout when GI is lower than 19.10.0

Posted on June 21, 2021 by Mike.Dietrich ASM / RAC / GI Patch Recommendation 9

The other day I received a question from a colleague about the risk of having GI and database both not being on the same RU. And a long while ago I blogged about it. We recommend that you keep it in synch. But you don’t have to. At the same time I received a wish from Ernst Leber to post something on the blog he and his colleague had trouble with when upgrading to 19c in a RAC environment. AutoUpgrade hung. But he titled his email with “not an AutoUpgrade problem!”. Still I agree, it is worth to write …

New parameters and features in Oracle Database 19.11.0

Posted on April 26, 2021 by Mike.Dietrich Behavior Change Patch Recommendation 6

As usual, as soon as I apply the newest RU, I do also a quick check for New parameters and defaults in Oracle Database 19.11.0.

New parameters and features in Oracle Database 19.11.0

Photo by Roma Kaiuk on Unsplash

New Parameters in Oracle 19.11.0

Based on customer feedback, there is one really big improvement since this RU release. Not only new features but also parameter changes get listed. You will find them in the 19c New Features Guide.

In this RU you will find only 1 new parameter:

drcp_dedicated_opt
The description says “Turn on/off dedicated optimization for DRCP” – and the default is “YES

Oracle 19c Installation with 19.11.0 RU, OJVM and some other fixes

Posted on April 22, 2021 by Mike.Dietrich Installation Oracle Database 19c Patch Recommendation 40

In an previous blog post we showed how to install and patch in one single action. And as I use this technique all the time when I setup new homes, would like to show you an Oracle 19c Installation with 19.11.0 RU, OJVM and some other fixes. The purpose of this blog post is mainly to demonstrate again how you can install and patch in one action. But also to help you avoiding a pitfall when you apply the OJVM RU from April 2021.

Oracle 19c Installation with 19.11.0 RU, OJVM and some other fixes

Photo by Sammy Williams on Unsplash

What do we need?

At first, let us …

Patching all my environments with the April 2021 Patch Bundles

Posted on April 21, 2021 by Mike.Dietrich Patch Recommendation 62

Oh well, time flies. And it is April 2021, and hence I will start Patching all my environments with the April 2021 Patch Bundles. In my case, this will be 19.11.0 and 12.2.0.1 Release Updates. But there will be an additional blog post for the OJVM bundle, too.

Photo by Piron Guillaume on Unsplash

As usual, an important annotation upfront: I patch in-place due to space issues. But in reality, you please patch always out-of-place with a separate home. Please see this blog post about how to apply the RU directly when you provision a new home with OUI…

ORA-12638 on Windows only from Oracle 19.10.0 onwards

Posted on March 10, 2021 by Mike.Dietrich Behavior Change Flaws and Pitfalls Oracle Database 19c 42

You like unexpected changes and surprises, don’t you? And especially those which aren’t in the patch notes or the docs. I blogged about such changes a few weeks ago. And thanks to the people reading this blog, I learned now about another change with Oracle 19.10.0 on the Windows platform. You may receive now an ORA-12638 on Windows only from Oracle 19.10.0 onwards.

ORA-12638 on Windows only from Oracle 19.10.0 onward

Photo by Fanny Rascle on Unsplash

What has been changed?

So at first, thanks to Ernst and Marcus for bringing this to my attention. This is an issue which happens on MS Windows only.

When you …

19.11.0

UNDO_RETENTION not inherited to PDBs anymore since 19.9.0

What is happening before 19.9.0?

AutoUpgrade may run into a timeout when GI is lower than 19.10.0

New parameters and features in Oracle Database 19.11.0

New Parameters in Oracle 19.11.0

Oracle 19c Installation with 19.11.0 RU, OJVM and some other fixes

What do we need?

Patching all my environments with the April 2021 Patch Bundles

ORA-12638 on Windows only from Oracle 19.10.0 onwards

What has been changed?

Archives

Categories

Upgrade @YouTube

RSS Feed for Upgrade your Database – NOW!

Subscribe via Email

Follow me on Twitter

Recent Posts