Datapatch

Important Recommended Patches for Oracle Database 19c

Posted on February 23, 2021 by Mike.Dietrich Patch Recommendation 18

It took a while – but now you can find a new MyOracle Support (MOS) Note with a list of Important Recommended Patches for Oracle Database 19c. It is actually a must-read, regardless whether you are upgrading or migration to 19c, or in case you are already on 19c.

Photo by Ani Kolleshi on Unsplash

What do you get?

Please check MOS Note: 2720807.1 – Oracle Database 19c Important Recommended One-off Patches. It gives you a list of important fixes for Oracle Database 19c. In the initial version of the note you could select for each available Release …

Patching all my environments with the January 2021 Patch Bundles

Posted on January 20, 2021 by Mike.Dietrich Patch Recommendation 40

Groundhog day on the upgrade blog. It’s time for my quaterly Patching all my environments with the January 2021 Patch Bundles blog post. And still no RAC and ASM. Sorry for that … too many virtual events and other tasks since months unfortunately.

Photo by Bofu Shaw 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.

Security Alert January 2021

Find …

Patching all my environments with the October 2020 Patch Bundles

Posted on October 22, 2020 by Mike.Dietrich Patch Recommendation 25

I have to confess: Time didn’t allow to rearrange my lab yet to have GI and ASM. Hence, this will be another blog post about Patching all my environments with the October 2020 Patch Bundles with only non-RAC patching. But it is in the works …

Patching all my environments with the October 2020 Patch Bundles

Photo by Olga Guryanova on Unsplash

Security Alert

Upgrade fails with ORA-20001 during datapatch run

Posted on July 31, 2020 by Mike.Dietrich AutoUpgrade Oracle Database 19c Patch Recommendation Upgrade / Migration 23

I encountered this issue now multiple times in my own environment. And I searched MOS and tried different things. But I couldn’t solve it yet. My Upgrade fails with ORA-20001 during datapatch run – and I’d like to show you how to bring the upgrade to an successful end.

Upgrade fails with ORA-20001 during datapatch run

Photo by chuttersnap on Unsplash

It all starts with an upgrade

In my lab environment I upgrade two databases often in parallel. An 11.2.0.4 database and a 12.2.0.1. The 11.2.0.4 upgrades always flawless. But the 12.2.0.1 occasionally fails. This is the screen AutoUpgrade is showing me – but this is not …

datapatch and OPatch documentation and MOS note

Posted on July 17, 2020 by Mike.Dietrich Patch Recommendation 2

Did you ever ask yourself whether there is documentation available for OPatch and for datapatch? It is not easy to find. And you won’t find it under “Database” in the Oracle Bookshelf. So today I would like to guide you in this short blog post to the datapatch and OPatch documentation and MOS note.

datapatch and OPatch documentation and MOS note

Photo by Mike Erskine on Unsplash

OPatch? Datapatch?

Just to recap: You use OPatch (or opatchauto) to apply the binaries to an Oracle installation. As a result, you change the second or the third number of the release from Oracle 19.5.0 to Oracle 19.8.0. But …

Patching all my environments with the July 2020 Patch Bundles

Posted on July 15, 2020 by Mike.Dietrich Patch Recommendation 26

Quarterly routine: When the new security alert get published, then it is patching time again. I’ll show you as usual how Patching all my environments with the July 2020 Patch Bundles works. And I heard your comments – in the next round in October, I will do this for GI and OJVM most likely, too. If not earlier …

Patching all my environments with the July 2020 Patch Bundles

Photo by Piron Guillaume on Unsplash

And just 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.

Security Alert July 2020

This is the Security Alert for …

Do you need STARTUP UPGRADE for OJVM?

Posted on January 23, 2020 by Mike.Dietrich JVM Patch Recommendation 10

Actually I carry around this topic with me since the October 2019 workshop in Dubai. We’ve had one of these OJVM Patching discussions I’d like to escape usually. Anyhow, during this session, it dawned me that the STARTUP UPGRADE requirement in the OJVM readme may be not correct anymore. So the question will be: Do you need STARTUP UPGRADE for OJVM?

Photo by Nik Shuliahin on Unsplash

A little bit of history

You will find a good amount of blog posts about OJVM here. OJVM stands for Oracle Java Virtual Machine. It is a very powerful thing and allows you …

Patching all my environments with the Oct 2019 Patch Bundles

Posted on October 17, 2019 by Mike.Dietrich Patch Recommendation 20

Yesterday I blogged about the Oct 2019 Patch Bundles being available for download. And while I wrote this blog post, I downloaded all of them for my environments. Here I’d like to share with you the most simple path to apply them. As I have no cluster or ASM, I don’t have to patch Grid Infrastructure. And I don’t even have OJVM in any of my databases right now. Due to space constraints in my lab environment I will apply the patches in-place. You shouldn’t do this but instead use always a new home you patch. This allows you …

OPatch … oh OPatch … why is datapatch so stubborn?

Posted on December 15, 2018 by Mike.Dietrich Patch Recommendation 14

Well, it is Friday night – and I’d rather should sleep or do something cool people tend to do on Friday night’s. But I try to verify a strange issue with DBMS_OPTIM_BUNDLE and the October 2018 Update for Oracle 12.2.0.1. I’m patching. Can you think of anything better on a Friday night than patching?

OPatch ... oh OPatch ... why is datapatch so stubborn?

Of course I know that I’m not alone. I know at least two customers I work with right now who do some maintenance jobs tonight as well. And I’m struggling with OPatch … oh OPatch … why is datapatch so stubborn?

My test setup

I have …

Do you have to execute “datapatch” when you create a new database?

Posted on April 19, 2018 by Mike.Dietrich Patch Recommendation 30

Do you have to execute "datapatch" when you create a new database? Thanks to Connor McDonald (Mr. AskTom) I learned today that one topic is not clear from our patches readmes: Do you have to execute “datapatch” when you create a new database? And it’s true. It does not get explained in the readme anywhere.

Do you have to execute “datapatch” when you create a new database?

If you never applied an Oracle patch bundles you may ask now: What is “datapatch” doing. And the answer is very simple. When you apply a patch bundle usually the patch does not include only binary files but also …

Does DBCA execute “datapatch” in Oracle 12.2?

Posted on May 25, 2017 by Mike.Dietrich DBCA Oracle Database 12.2.0.1 3

Does the Database Configuration Assistant (DBCA) execute “datapatch -verbose” in Oracle 12.2 when you create a new database?

Does DBCA in Oracle 12.2 execute datapatch when you create new database? I was curious if this misbehavior from the previous release has been fixed. Good news: It got fixed with Oracle Database 12.2.0.1. The DBCA does execute “datapatch -verbose” automatically now when you create a new database. In the previous release this did not happen – you had to execute it manually after creating a new database.

DBCA 12c and “datapatch.pl” – things to know

Quick Test Scenario

I …

DBA_REGISTRY_HISTORY vs DBA_REGISTRY_SQLPATCH

Posted on November 30, 2016 by Mike.Dietrich Flaws and Pitfalls Patch Recommendation 9

At the DOAG Conference in November in Nürnberg in November 2016 a customer asked me right after my talk about “Upgrade to Oracle Database 12.2. – Live and Uncensored” why the DBA_REGISTRY_HISTORY does not get updated when he applies a Bundle Patch and follows all instructions including the “./datapatch -verbose” call.

I was wondering as well and asked him to open an SR. Which he did. And he received the message from Support that it is not supposed to appear in Oracle 12c anymore this way but only in DBA_REGISTRY_SQLPATCH. Now I dug a bit deeper …

Oracle Database BP April16 applied successfully

Posted on April 21, 2016 by Mike.Dietrich Patch Recommendation 13

Usually I don’t post twice a day but as my post scriptum for the previous blog post got longer and longer I decided to write an entry about it – maybe simply because I feel soooo happy that my patch application succeeded flawless.

For many of you the following steps may look very boring as you have done this many times. But I use the blog also to brain-dump information for myself 😉 And for those who’d like to play with it, I summarized the steps fitting exactly into our Hands-On-Lab environment.

Download

I downloaded the following patches:

Database Proactive

No OS Authentication? datapatch will fail in every upgrade

Posted on September 29, 2015 by Mike.Dietrich Patch Recommendation 4

Thanks to Daniel from SimCorp for bringing this to my attention: Patch

Actually, command line upgrades are affected as well, if you do not use OS authentication.
Apparently, datapatch is not able to execute in non-OS authentication mode.
See MOS note 1635007.1.

Symptom:

You are doing a command line upgrade to Oracle Database 12c with catctl.pl – and you don’t use OS authentication allowing connections with “/ as sysdba” then datapatch.pl won’t be able to execute the SPU/PSU/BP related SQL commands as it will fail to connect to your database with an ORA-1017 (invalid username/password) error.

Solution:

Bug 18361221 …

Don’t get puzzled by “sqlpatch” messages during Upgrade

Posted on September 10, 2015 by Mike.Dietrich Oracle Database 12c Patch Recommendation Upgrade / Migration 0

During my last Hands-On-Labs in Uruguay and Argentina I’ve had several people wondering about these messages below when running the command line upgrade with catctl.pl:

catctl.pl - sqlpatch

This (and another) message breaks the nicely structured format of the catctl.pl output. And as it ends with an “err” extension it looks to many people as if the upgrade had gotten an error,

But please don’t feel disturbed. It’s just messages from sqlpatch invocation – and the “err” extension is just pointing to an error file in case something has gone wrong.

In a future release such messages …

DBCA 12c and “datapatch.pl” – things to know

Posted on August 17, 2015 by Mike.Dietrich DBCA Flaws and Pitfalls Oracle Database 12c Patch Recommendation 26

A few weeks ago I did blog about the DBUA (Database Upgrade Assistant) not executing ‘datapatch’ (i.e. not applying the SQL changes involved with a SPU/PSU/BP) automatically:

DBUA 12c and “datapatch.pl” – things to know

For DBUA, please note that this behavior DOES NOT APPLY to command line upgrades done with catctl.pl – as you can see from this somewhat disturbing messages during the upgrade in phase 65 and phase 69 (which are not errors but just informational messages for datapatch’s execution):

Datapatch phases command line upgrade catctl.pl

But afterwards I have learned that things are worse.
The same behavior is true when you create

Grid Infrastructure Management Repository (GIMR) – Datapatch?

Posted on August 5, 2015 by Mike.Dietrich ASM / RAC / GI Patch Recommendation 0

I have blogged about the Grid Infrastructure Management Repository (GIMR) a while back:

Grid Infrastructure Management Repository (GIMR) database now mandatory in Oracle GI 12.1.0.2

And Markus Michalewicz, our Director of Product Management, Oracle Real Application Clusters (RAC), has published a very interesting and helpful insight article about GIMR on July 30, 2015. Read it here:
https://www.linkedin.com/pulse/how-handle-oracle-gimr-markus-michalewicz

Since Oracle Database 12.1.0.2 the GIMR database will be created by default – and it is a single tenant database having a CDB$ROOT and one active PDB.

Recently the question came up if – in the likely event of applying a PSU …

PSU1 and PSU2: Datapatch Issues coverd in MOS Note

Posted on March 5, 2014 by Mike.Dietrich Patch Recommendation 2

You may have read a posting dis-recommending PSU1 and PSU2 for Oracle Multitenant 12.1.0.1 especially in RAC/GI environments earlier this week. Actually following a lot of internal discussions I will post some advice and clarification later this week.

Now I have an useful update:
Datapatch Issues are covered within a separate MOS Note making it easier to keep track and find workarounds for known issues.
Please see MOS Note:1609718.1 Datapatch Known Issues

-Mike…

Datapatch

Patching all my environments with the January 2021 Patch Bundles

Security Alert January 2021

Patching all my environments with the October 2020 Patch Bundles

Security Alert

Upgrade fails with ORA-20001 during datapatch run

It all starts with an upgrade

datapatch and OPatch documentation and MOS note

OPatch? Datapatch?

Patching all my environments with the July 2020 Patch Bundles

Security Alert July 2020

Do you need STARTUP UPGRADE for OJVM?

A little bit of history

Patching all my environments with the Oct 2019 Patch Bundles

OPatch … oh OPatch … why is datapatch so stubborn?

My test setup

Do you have to execute “datapatch” when you create a new database?

Do you have to execute “datapatch” when you create a new database?

Does DBCA execute “datapatch” in Oracle 12.2?

Does the Database Configuration Assistant (DBCA) execute “datapatch -verbose” in Oracle 12.2 when you create a new database?

Quick Test Scenario

DBA_REGISTRY_HISTORY vs DBA_REGISTRY_SQLPATCH

Oracle Database BP April16 applied successfully

Download

No OS Authentication? datapatch will fail in every upgrade

Symptom:

Solution:

Don’t get puzzled by “sqlpatch” messages during Upgrade

DBCA 12c and “datapatch.pl” – things to know

Grid Infrastructure Management Repository (GIMR) – Datapatch?

PSU1 and PSU2: Datapatch Issues coverd in MOS Note

Archives

Categories

Upgrade @YouTube

RSS Feed for Upgrade your Database – NOW!

Subscribe via Email

Recent Posts