11.2.0.4

Certifying an application on a specific RU-only is wrong

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.

Certifying an application on a specific RU only is wrong

Photo by Sigurdur Fjalar Jonsson on Unsplash

What’s the story?

At first, …

Why you simply can’t upgrade from Oracle 11g or 12c to Oracle 23c

Posted on August 1, 2022 by Mike.Dietrich Release Schedule 5

It’s time for a Monday morning rant. I receive more and more questions which all start similar. “My customer is on Oracle 11g and/or 12c, and want to know whether the next long term support release …“. Now let me clarify Why you simply can’t upgrade from Oracle 11g or 12c to Oracle 23c. And why you MUST upgrade to Oracle Database 19c.

Why you simply can't upgrade from Oracle 11g or 12c to Oracle 23c

Photo by SpaceX on Unsplash

What is the intention?

After a lot of discussions across many regions, especially in JAPAC during the past weeks I realized that there is a reason for all …

Upgrade from 11.2.0.4 to 19c with Label Security Policies

Posted on July 6, 2022 by Mike.Dietrich Flaws and Pitfalls 5

I remember, I have a blog. Forgive me that I don’t write a lot at the moment even though I still have a long queue of “future posts to write”. It is just too busy, and I was away for almost two full weeks in June as well. But let me briefly drop information on an issue I learned about recently. It just affects your when Upgrade from 11.2.0.4 to 19c with Label Security Policies. All other readers may simply ignore this blog post.

Upgrade from 11.2.0.4 to 19c with Label Security Policies

Photo by Erik Mclean on Unsplash

What happens?

You are using Oracle Label Security, and …

Virtual Classroom Seminar #14: AutoUpgrade 2.0 on May 5, 2022

Posted on May 3, 2022 by Mike.Dietrich Workshop 4

If you finally want to see all the cool new features of AutoUpgrade 2.0 (the 2.0 is just a marker we use to say: We improved it significantly!), the please sign up to Virtual Classroom Seminar #14: AutoUpgrade 2.0 on May 5, 2022.

Virtual Classroom Seminar #14: AutoUpgrade 2.0 on May 5, 2022

Photo by Alex Knight on Unsplash

What are we going to talk about?

The development team invested a lot of resources to implement some of the most wanted features in AutoUpgrade. Spoiler: One feature is still missing but will be released very soon. In this Thursday’s Virtual Classroom Seminar we will talk about:

PDB and non-CDB

Why you can’t stay on Oracle Database 11g forever

Posted on April 6, 2022 by Mike.Dietrich Release Schedule 24

Oracle Database 11g? In 2022? Yes, I know – and you know too – there are Oracle 11g databases out there in production. And blindly I’d say: Too many. Of course, we are the “upgrade guys” trying to convince you to move to Oracle Database 19c. And I bet, for each of your 11g databases there’s a valid and legit reason why they haven’t upgraded yet. But there is one often neglected technical reason Why you can’t stay on Oracle Database 11g forever. So let me explain this below.

Photo by Kristoffer Darj on Unsplash

Oracle Database 11g?

Patching all my environments with the January 2022 Patch Bundles

Posted on January 20, 2022 by Mike.Dietrich Patch Recommendation 60

It’s patching time. When I checked an SR and had a quick discussion with a customer yesterday, Peter reminded me that it’s patching day. And at about 20:00h CET the new patch bundles appeared on MOS. So let me show you again Patching all my environments with the January 2022 Patch Bundles for 11.2.0.4, 12.2.0.1, 19c and 21c.

Patching all my environments with the January 2022 Patch Bundles

Photo by Mehmet Turgut Kirkgoz 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 …

No RURs for 12.2.0.1 – and Oracle 11.2.0.4 left Extended Support

Posted on January 26, 2021 by Mike.Dietrich Patch Recommendation Release Schedule 0

Last week I blogged about the quarterly patching fun when applying the Release Updates to my environments. But I completely forget to mention and explain a few things. There are No RURs for 12.2.0.1 – and Oracle 11.2.0.4 left Extended Support.

No RURs for 12.2.0.1 - and Oracle 11.2.0.4 left Extended Support

Photo by Md Mahdi on Unsplash

No Release Update Revisions for Oracle 12.2.0.1

Thanks to my friend Rodrigo Jorge who messaged me on the weekend. He goes way deeper with applying the quarterly patches and highlights the differences. And he recognized and blogged already about the fact that there are no RURs available for Oracle 12.2.0.1.

And …

Recap: Support Periods for Oracle 11.2.0.4, on-prem and in the cloud

Posted on December 17, 2020 by Mike.Dietrich Cloud Release Schedule 6

You may have recognized that I don’t update the blog as frequent as usual. But these times are very busy with plenty of conferences and many of our customers preparing for the move to 19c in the more quieter period of the year. And this is the right time to do a quick recap: Support Periods for Oracle 11.2.0.4, on-prem and in the cloud.

Recap: Support Period for Oracle 11.2.0.4, on-prem and in the cloud

Photo by Arnaud STECKLE on Unsplash – this car is a VW Karman Ghia

11.2.0.what?

Ah, well. Do you remember when Oracle Database 11.2.0.1 got released?

No worries, I’ve had to look it up by …

Does your GI RU/RUR patch level has to match your database’s?

Posted on June 11, 2020 by Mike.Dietrich ASM / RAC / GI 2

A long while ago I blogged about whether you should keep your patch versions between Grid Infrastructure and Databases Homes in synch, or not. And today, Daniel dropped me a note mentioning that this old blog post may need an update for 18c/19c. He’s right. And as I’ve had trouble finding my old blog post, I title this one a bit more obvious: Does your GI RU/RUR patch level has to match your database’s?

Does your GI RU/RUR patch level has to match your database's?

Photo by Vincent van Zalinge on Unsplash

Before Oracle Database 18c

Since Oracle 18c we move from a 5-number release schema to a 3-number one. …

Extended Support for Oracle Database 12.1.0.2 extended

Posted on December 16, 2019 by Mike.Dietrich Release Schedule 13

These are good new in case you plan to use Oracle Database 12.1.0.2 longer in production. Just last week we extended the Extended Support for Oracle Database 12.1.0.2 by one additional year.

Extended Support for Oracle Database 12.1.0.2 extended

Photo by Matthew Waring on Unsplash

Extended Support Extension for Oracle 12.1.0.2

Before, the Extended Support for Oracle 12.1.0.2 ended end of July 2021. Now you can purchase it until end of July 2022. For those of you who have it included in your contract anyway (for instance if you have a ULA or PULA), these are great news.

Please see:

MOS Note: 742060.1 – Release Schedule of

Market Driven Support for Oracle Database 11.2.0.4

Posted on October 10, 2019 by Mike.Dietrich Release Schedule 7

I know that some of you are still on Oracle 11.2.0.4. And I don’t want to argue, why. I’m pretty sure there’s a good reason that you haven’t upgraded yet. Just remember: You can upgrade directly from Oracle 11.2.0.4 to Oracle 19c. Just in case you plan to stay longer than end of 2020 on this ancient release, then you may want to read about the Market Driven Support for Oracle Database 11.2.0.4.

Market Driven Support for Oracle Database 11.2.0.4

Overview Support Periods Oracle 11g Release 2

First of all, let me give a quick overview on Oracle Database 11g Release 2 – usually …

You MUST patch 12.1.0.1 and 11.2.0.3 and older databases before June 2019

Posted on February 25, 2019 by Mike.Dietrich Flaws and Pitfalls 18

First of all, this blog post is not new. I blogged about this SCN topic a while ago already. But some of you seem to operate still older databases for various reasons. And even if you think that you are safe, double check for any older databases in your environments. You MUST patch 12.1.0.1 and 11.2.0.3 and older databases before June 23, 2019. And just to be clear: June 23, 2019 is going to happen in less than 4 months.

You MUST patch 12.1.0.1 and 11.2.0.3 and older databases before June 2019

Photo by Dimitar Donovski on Unsplash

Who is NOT affected?

If you use the following Oracle database releases …

How long can you provision database version X in the Cloud? – NEW

Posted on November 26, 2018 by Mike.Dietrich Cloud Release Schedule 0

A few weeks ago I published a blog post about provisioning dates in Oracle Cloud environments for different databases releases. As we did an important update, I rewrite today: How long can you provision database version X in the Cloud? – NEW.

What has changed since the original post?

The key point in the previous blog post was:

“And by end of this calendar year, the option to provision an Oracle 12.2.0.1 instance will go away. The same will happen in less than 1 year with Oracle 11.2.0.4 instances.”.

With “this calendar year” I pointed to end of 2018. …

Current Support Status for Oracle Database Releases

Posted on October 16, 2018 by Mike.Dietrich Release Schedule 11

Yesterday a former colleague from the UK pointed me to a very old blog post about the fact that no patches will be produced for Oracle 11.2.0.3 anymore. Which is a true fact. But it reminded me that it may be time for an overview on the current support status for Oracle database releases as of October 2018.

Current Support Status for Oracle Database Releases

First of all, the single source of truth in case you’d like to look up support dates and patching periods is MOS Note:742060.1. Please always check this note first. Our Support Lifetime …

How long can you provision database version X in the Cloud?

Posted on August 3, 2018 by Mike.Dietrich Cloud 2

That’s a question I have gotten several times already: How long can you provision database version X in the Cloud? Meaning, is there a fixed date when you’ll be unable to provision an instance containing Oracle Database 12.1.0.2 for instance?

How long can you provision database version X in the Cloud?

Please find the updated blog post here:

How long can you provision database version X in the Cloud? – NEW

–Mike…

Patching my databases with the July 2018 PSU, BP and RU

Posted on July 19, 2018 by Mike.Dietrich Patch Recommendation 38

Patching my databases with the July 2018 PSU, BP and RU As usual I download the patch bundles and apply them to our Hands-On Lab environment as quickly as possible. First of all for the simple reason that I don’t want to trap into issues which are fixed already. Second for the reason that I always tell you: YOU MUST PATCH! But if I’m saying this over and over again, then I can’t have my own environments unpatched. And at third, because I want to learn if anything is not working correctly or has changed (see below).

Of course my tiny single instance environments are not comparable to your critical production …

Where is the Jan 2017 PSU for Oracle Database 11.2.0.4?

Posted on January 30, 2017 by Mike.Dietrich Oracle Database 11g Patch Recommendation 24

Where is it?

This question reached me a week ago:
“Where is the January 2017 PSU for Oracle Database 11.2.0.4?”

“What’s the deal?” was my first thought – just go and download it from MOS.
Well, not really …

Where to download Proactive Bundle Patches, Patch Set Updates and Patch Sets?

My favorite note is:
MOS Note:1454618.1
Quick Reference to Patch Numbers for PSU, SPU(CPU), BPs and Patchsets

It gives me access to all the download links for the patch bundles I’m looking for.

But for 11.2.0.4. there’s only “NA” (not available) stated:

And a very …

Premier Support for Oracle 11.2 will end soon …
Upgrade to Oracle Database 12c now!

Posted on November 5, 2014 by Mike.Dietrich Lifetime Support Policy 26

PLEASE FIND THE UPDATES BLOG POST HERE:

Release Dates Oracle Database 12.2.0.1 on-prem – Extended Support Waiving for Oracle 11.2.0.4 / 12.1.0.2

-Mike…

New 11.2.0.4 Parameter: ENABLE_GOLDENGATE_REPLICATION

Posted on February 11, 2014 by Mike.Dietrich Oracle Database 11g Parameters 0

Just learned something new I couldn’t find actually in the doc at the first glance:

There’s a new init.ora parameter introduced in Oracle Database 11.2.0.4 named:
ENABLE_GOLDENGATE_REPLICATION

By default it is set to FALSE and the parameter got introduced because not only the external use of Oracle GoldenGate requires a valid license but also the use of the internal APIs. For example, XStream provides high performance APIs that enable client
applications to receive and send real-time data changes from an Oracle
database. Other APIs were added for encryption support, trigger
suppression, etc. None of these APIs are licensed with …

11.2.0.4

Certifying an application on a specific RU-only is wrong

What’s the story?

Why you simply can’t upgrade from Oracle 11g or 12c to Oracle 23c

What is the intention?

Upgrade from 11.2.0.4 to 19c with Label Security Policies

What happens?

Virtual Classroom Seminar #14: AutoUpgrade 2.0 on May 5, 2022

What are we going to talk about?

Why you can’t stay on Oracle Database 11g forever

Oracle Database 11g?

Patching all my environments with the January 2022 Patch Bundles

No RURs for 12.2.0.1 – and Oracle 11.2.0.4 left Extended Support

No Release Update Revisions for Oracle 12.2.0.1

Does your GI RU/RUR patch level has to match your database’s?

Before Oracle Database 18c

Extended Support for Oracle Database 12.1.0.2 extended

Extended Support Extension for Oracle 12.1.0.2

Market Driven Support for Oracle Database 11.2.0.4

Overview Support Periods Oracle 11g Release 2

You MUST patch 12.1.0.1 and 11.2.0.3 and older databases before June 2019

Who is NOT affected?

Current Support Status for Oracle Database Releases

Current Support Status for Oracle Database Releases

Patching my databases with the July 2018 PSU, BP and RU

Where is the Jan 2017 PSU for Oracle Database 11.2.0.4?

Where is it?

Where to download Proactive Bundle Patches, Patch Set Updates and Patch Sets?

Premier Support for Oracle 11.2 will end soon …
Upgrade to Oracle Database 12c now!

New 11.2.0.4 Parameter: ENABLE_GOLDENGATE_REPLICATION

Archives

Categories

Upgrade @YouTube

RSS Feed for Upgrade your Database – NOW!

Subscribe via Email

Follow me on Twitter

Recent Posts