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

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 obvious as we…

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…

July 2018 Update, Revision, BP and PSU

Hurray, it’s patching day! I know, YOU did look forward to July 17, 2018 as it is patching day again. Last night we released the following Patches: July 2018 Update, Revision, BP and PSU. July 2018 Update, Revision, BP and PSU First of all, I’m doing the usual check for the alert and the risk matrix to see whether there’s are really important security patches included. For the risk matrix you’ll have to scrooooooooooolllll down quite a bit as the list of products is strictly alphabetically ordered: Critical Patch Update – July 2018 – Patch Advisory Risk Matrix for Oracle…

ORAWORLD Mag: Oracle Database Patching – Tips & Tricks

Thanks to DOAG and the ORAWORLD Magazine, my article is released in the current September 2018 ORAWORLD Mag: Oracle Database Patching – Tips & Tricks ORAWORLD Mag: Oracle Database Patching – Tips & Tricks You’ll find my article about Database Patching – Tips & Tricks on page 28ff in the September 2018 issue if the ORAWORLD magazine. Please download it from here. And of course, you will find other issues on the website of the ORAWORLD Magazine: http://www.oraworld.org/home/ Further Information Why should you use the most recent version of OPatch? When you patch, please use UPDATES – and not REVISIONS…

Patching to Oracle 18.2.0 in the Oracle Cloud (OCI Classic)

I was quite surprised when I spotted the Update (RU) Oracle 18.2.0 mid of April in my OCI Classic (DBCS, DBaaS) account. Of course I was thrilled immediately and started the patching to Oracle 18.2.0 in the Oracle Cloud (OCI Classic). Patching to Oracle 18.2.0 in the Oracle Cloud (OCI Classic) The April 2018 Updates (and Bundle Patches and Patch Set Updates for Oracle releases below 12.2) got released on April 17, 2018. You can read more here on how I applied all of them to my Oracle 11.2.0.4, 12.1.0.2 and 12.2.0.1 databases. But I was positively surprised when I…

January 2018 Database RU and RUR got released

It’s patching time again. The January 2018 Database RU and RUR got released. And of course other patch bundles as well. And of course not only for the database but for many other products as well. I try to summarize below the most important information and links. January 2018 Database RU and RUR got released First of all always have a look at the Critical Patch Alert and the Risk Matrix: Critical Patch Update – January 2018 Risk Matrix for Oracle Database Then you’ll see that there are three fixes included for vulnerabilities which may be remotely exploitable without authentication,…

DOAG 2017 Conference – Upgrade Talks and More

It’s November. November is DOAG time. Time really flies. And the German Oracle User Group Conference till kick off in a bit more than a week from now on. For me it’s like visiting a huge event where I know so many people: it’s almost like a friends& family meetup. Only strange thing: we all get older … 😉 I’m really looking forward to DOAG 2017 Conference from Nov 21-24, 2017. And if you are not a German native speaker, don’t worry at all. Many talks get simultaneously translated into English. The translators are amazingly good. It’s worth to visit….

Are OJVM patches included in the Oracle 12.2 RU / RUR?

I have received this question multiple times in the past days, especially when I presented at the Slovenian Oracle User Group Conference about the new Release and Patching Mode but also via emaill: Are OJVM patches included in the Oracle 12.2 RU / RUR? Let me clarify this in the below blog post. Are OJVM patches included in the Oracle 12.2 RU / RUR? At first I did check MOS Note: 1929745.1 – Oracle Recommended Patches — “Oracle JavaVM Component Database PSU and RU” (OJVM PSU and OJVM RU) Patches.But besides having RU mentioned in the Note’s title and one…

How to patch the Oracle Instant Client?

That’s an interesting question a customer raised the other day: How to patch the Oracle Instant Client? I silently assumed that there’s a new release of the Oracle Instant Client every quarter or at least when we deliver fixes which apply to the client as well. Hm … What is the Oracle Instant Client? First of all, the Oracle Instant Client is a pretty cool thing. It gets distributed via OTN as a simple download. You deploy it to your client machine, you set LD_LIBRARY_PATH (or PATH on Windows) and add a tnsnames file if necessary, you may add SQL*Plus…

Use the correct download to patch APEX from 5.1.0 to 5.1.1

When you plan to upgrade Oracle Application Express (APEX) from version 5.1.0 to 5.1.1 please be aware to download a patch from MOS instead the 5.1.1 version from OTN. The text on the OTN page is a bit misleading – and a customer I work with downloaded the wrong version which led to a failed upgrade – even though the scripts seem to be made for this patch upgrade. Even though the page says “This is a cumulative patch set for Application Express 5.1.0” the page offers you a full install and not the patch for an existing APEX 5.1.0…

Keep your patch versions between Grid Infrastructure and Databases Homes in synch

I’ve had some interesting discussions with Anil Nair, our RAC Product Manager and a customer in the past days. The customer was looking for a definite statement that they can have a higher version of Patch Set Updates (PSUs) or Proactive Bundle Patches (BPs) in the Database homes than in the Grid Infrastructure home managing the resources. Can you have different PSU/BP versions between Database and GI homes? Yes, you can have a higher version PSU or BP in the Database home than in the Grid Infrastructure home managing the resources. This is implicitly documented in MOS Note 337737.1 – Oracle…

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

Related Posts on “The OJVM Patching Saga – and how to solve it“: Part I – The OJVM Basics Part II – Important Notes and Information Part III – The Mitigation Patch Part IV – What you may have missed Part V – MOS Note explaining “Conditional Rolling Install”  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 for 12.1.0.2,…

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

Related Posts on “The OJVM Patching Saga – and how to solve it“: Part I – The OJVM Basics Part II – Important Notes and Information Part III – The Mitigation Patch Part IV – What you may have missed Part V – MOS Note explaining “Conditional Rolling Install”  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 mitigation patch…

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

Related Posts on “The OJVM Patching Saga – and how to solve it“: Part I – The OJVM Basics Part II – Important Notes and Information Part III – The Mitigation Patch Part IV – What you may have missed Part V – MOS Note explaining “Conditional Rolling Install”  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 Patch” is an interim…

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

Related Posts on “The OJVM Patching Saga – and how to solve it“: Part I – The OJVM Basics Part II – Important Notes and Information Part III – The Mitigation Patch Part IV – What you may have missed Part V – MOS Note explaining “Conditional Rolling Install”  Important Notes MOS Note: 1929745.1 – Oracle JavaVM Component Database Patches MOS Note: 1940702.1 – Database JVM Vulnerabilities FAQ MOS Note: 2165212.1 – What to do if the Database JAVAVM Component becomes INVALID After installing an OJVM Patch? This Note contains a pretty detailed removal procedure for JAVAVM as well –…

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

Related Posts on “The OJVM Patching Saga – and how to solve it“: Part I – The OJVM Basics Part II – Important Notes and Information Part III – The Mitigation Patch Part IV – What you may have missed Part V – MOS Note explaining “Conditional Rolling Install”  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 inside Oracle’s development…

Patching Best Practices – 38min Video

 Ever asked yourself about Database Patching Best Practices? I know that not always everything works that simple and easy. See the blog post by Pieter Van Puymbroeck from Exitas in Belgium about some findings when applying the April 2015 PSU to an Exadata or by myself about my experiences when applying the GI PSU from Jan 2015. But this 38 min video may give you a good overview about the best and recommended techniques at first hand by Eleanor Meritt and David Price, both from the Sustaining Engineering organization that issues bug fixes, patches and patchset updates for the Oracle Database,…

Grid Infrastructure PSU Jan 2015 – Am I too intolerant?

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 Oracle Restart…

Best Practices for Patching — learn more at OOW!

Although upgrade and patching are truly two very different processes, they both fall into the same general category of planned maintenance and are often associated with each other. So, it seems relevant to point out yet another important talk at OpenWorld in San Francisco: Database Patching Best Practices II [CON7748] Tuesday, Sep 30, 5:00 PM – 5:45 PM – Moscone South – 104 Building on a highly popular session from Oracle OpenWorld 2013, this session further explores ways to help you maintain and patch your database systems most efficiently. Learn about patch testing best practices, techniques for minimizing downtimes, how to…