opatch

July 2018 Update, Revision, BPs, PSUs – delays and other issues

Posted on July 20, 2018 by Mike.Dietrich Patch Recommendation 7

This is a Friday morning blog post. And actually I had no intention to write it. I don’t mean it offensive. But yesterday I received an interesting email from Frits Hoogland from Enkitec/Accenture. Frits asked me about the July RUR and some unlogic things on MOS. Once I had answered his email, the next question came in. Hence, I thought I need to write something about our July 2018 Update, Revision, BPs, PSUs – delays and other issues.

From being on stage at last year’s DOAG Conference for a “Patching Forum” I know that things aren’t as …

Patching Oracle Database 18.1.0 to 18.2.0 on premises

Posted on June 21, 2018 by Mike.Dietrich Patch Recommendation 5

In this part of my blog post series about upgrading from Oracle 12.2.0.1 to Oracle 18c I’d like to demonstrate patching Oracle Database 18.1.0 to 18.2.0 on premises.

A while ago I showed also how to patch from Oracle 18.1.0 to 18.2.0 in the Oracle Cloud.

Find the related blog posts here:

Patching Oracle Database 18.1.0 to 18.2.0 on premises

Before I can start patching to the Release Update Oracle 18.2.0 I need to download the patch …

Why should you use the most recent version of OPatch?

Posted on May 14, 2018 by Mike.Dietrich Patch Recommendation 0

Opatch. A tool nobody really loves but everybody has to use (at least those of you who patch or aren’t in our cloud deployment). Opatch gets distributed via MOS. And you often can apply patches with an older version of OPatch. So why should you use the most recent version of OPatch?

Why should you use the most recent version of OPatch?

First of all, you have a base installation of Opatch in your $ORACLE_HOMEs:

[CDB2] oracle@localhost:/u01/app/oracle/product/12.2.0.1
$ ls OPatch
auto           jlib        opatchauto.cmd  operr.bat         scripts
config         jre         opatch.bat      operr_readme.txt  version.txt
datapatch      modules     opatch_env.sh   oplan
datapatch.bat  ocm         opatch.pl       oracle_common
docs

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

Posted on April 23, 2018 by Mike.Dietrich Patch Recommendation 29

Patching is fun, isn’t it? And you may have heard already that the April 2018 patch bundles got released on April 17, 2018. And I thought I share a little bit of fun with you with a quick guide to patching my databases with the April 2018 PSU, BP and RU. For this exercise I use our Hands-On Lab with Oracle 11.2.0.4, Oracle 12.1.0.2 and Oracle 12.2.0.1 installed.

Prerequisites for patching my databases with the April 2018 PSU, BP and RU

First of all, in my VBox environment, I shutdown the databases for each release before patching them – …

Applying the first RU for Oracle Database 12.2.0.1

Posted on July 20, 2017 by Mike.Dietrich Patch Recommendation 4

Appying the first RU for Oracle Database 12.2.0.1 The first RU (Release Update) for Oracle 12.2 is available on most platforms since July 18, 2017. And of course I started applying the first RU for Oracle Database 12.2.0.1 as soon as it got released.

See: https://mikedietrichde.com/2017/07/19/first-ru-oracle-12-2-0-1-available/

Download the RU 12.2.0.1.170718 for Linux

First of all I downloaded the Database RU 12.2.0.1.170718 Patch 26123830 for Linux from MyOracle Support. To my absolute surprise it was very small compared to previous Proactive Bundle Patches such as the April 2017 one. It has just 40 MB in size (no typo!).

Applying the first RU for Oracle Database 12.2.0.1

Download the first RU (Release Update) July 2017 for Oracle

Can I apply a BP on top of a PSU? Or vice versa? PART 2

Posted on October 4, 2016 by Mike.Dietrich Patch Recommendation 4

I thought I won’t blog about this again:

Can I apply a BP on top of a PSU? Or vice versa?

But then a colleague of mine raised this simple question:

“I have a customer that would like to change from patching using PSU to patching using Bundle Patch. I am
wondering what happens if my home has had several PSUs installed. Before applying a BP, would I need to rollback one by one all the PSUs that have been installed in reverse order (tedious) OR only the latest PSU (good)?”

Unfortunately the “simple” solution is hidden deep down in …

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

Grid Infrastructure PSU Jan 2015 – Am I too intolerant?

Posted on February 18, 2015 by Mike.Dietrich ASM / RAC / GI Patch Recommendation 6

Germans are not only known for being precise and timely – but sometimes also for being too direct. Well, Roy could tell you stories … and I always honor his politeness 🙂

Enough about stereotypes. I work with a customer at the moment on their 12c upgrades. And I did recommend the most recent PSU (Patch Set Updates) for their Grid Infrastructure environments running Oracle Restart. Same of course for the database homes but this blog post will just name some findings I’ve had the other night when trying to apply the January 2015 GI PSU to my …

opatch

July 2018 Update, Revision, BPs, PSUs – delays and other issues

Patching Oracle Database 18.1.0 to 18.2.0 on premises

Patching Oracle Database 18.1.0 to 18.2.0 on premises

Why should you use the most recent version of OPatch?

Why should you use the most recent version of OPatch?

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

Prerequisites for patching my databases with the April 2018 PSU, BP and RU

Applying the first RU for Oracle Database 12.2.0.1

Download the RU 12.2.0.1.170718 for Linux

Can I apply a BP on top of a PSU? Or vice versa? PART 2

Oracle Database BP April16 applied successfully

Download

Grid Infrastructure PSU Jan 2015 – Am I too intolerant?

Archives

Categories

Upgrade @YouTube

RSS Feed for Upgrade your Database – NOW!

Subscribe via Email

Follow me on Twitter

Recent Posts