Why is the October Patch Bundle from July?

Strange blog headline, isn’t it? Intentionally. Peter Lehmann mailed me a question – and asked more or less: Why is the October Patch Bundle from July? Sounds strange? It is strange … Strange notation Peter wanted to download the most recent patch bundle for Grid Infrastructure from October. And he found patch 28507693: But he was wondering about the headline having the date of October 18, 2018 together with JUL 2018. How does this make sense?? Flashback When you flash back to the day when we introduced “Updates” (RU) and “Revisions” (RUR) you may remember that we release quarterly “Updates”…

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…

Video: The New Database Release and Patching Model

The last Office Hours I’ve run about the New Release and Patching Model didn’t go very well technically. I’ve had screen/display issues. And Steven Feuerstein tried to save the best parts – but despite Steven’s awesome work neither him nor I did really like the result. So I decided that it may be better to record a Video: The New Database Release and Patching Model again (which I actually planned for quite a while already anyway. Video: The New Database Release and Patching Model The video is based on the slide deck you’ll find in the Slides download section of…

When you patch, please use UPDATES – and not REVISIONS

I can just repeat what I’m saying not for almost a year: When you patch, please use UPDATES – and not REVISIONS. Updates (or Release Updates – short: RU) and Revisions (or Release Update Revisions – short: RUR) are patch bundles for the Oracle Database since Oracle 12.2.0.1. There are no PSUs (Patch Set Updates) anymore. And Revisions are not the same as PSUs. When you patch, please use UPDATES – and not REVISIONS One of the reasons why we recommend Updates, and not Revisions, simply is: Updates keep you more current whereas Revisions will let you miss a lot…

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 SQL changes, for instance a new…

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,…

Oracle Database RU and RUR Recommendations and Facts

Well … another post about RU and RUR patches. But after having multiple discussions personally, via web conferences, in conference calls and of course on Twitter I think some clarifications may be helpful. Below you’ll find Oracle Database RU and RUR recommendations and facts. At least some of them … Oracle Database RU and RUR Recommendations and Facts First of all, you will find more information in several blog posts about RU (Release Update) and RUR (Release Update Revision) patches: PSU or BP? Patch Set Update or Bundle Patch? RUR or RU? (May 12, 2017) More Information about RU and…

Differences between PSU / BP and RU / RUR

Since Oracle Database 12.2.0.1 we change our patching model as well, switching from Patch Set Updates (PSU) and Proactive Bundle Patches (BP) to Release Updates (RU) and Release Update Revisions (RUR). But what are actually the differences between PSU / BP and RU / RUR patch bundles? Is there any or is it just a renaming of well known patch bundles? No change on MS Windows First of all, let me say that there won’t be any changes on the Windows platform. If your preferred operating system is MS Windows then stop reading here. On Windows you’ll see exactly the…

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…

October 2017 RU, RUR, BP and PSU are available

It’s October 17, 2017. And the October 2017 RU, RUR, BP and PSU are available for download. The most important links Find the most important information here: Landing page for Security Alerts and Third Party Bulletins Critical Patch Update – October 2017 Oracle Database Server, versions 11.2.0.4, 12.1.0.2, 12.2.0.1 The Risk Matrix Find the Risk Matrix here: Database RU, RUR, BP and PSU – October 2017 To access the RU, RUR, BP and PSU for the Oracle Database Server you will have to logon to MyOracle Support: MOS Note: 2296870.1 Patch Set Update and Critical Patch Update October 2017 Availability…

Download Assistant for RUs, RURs, BPs, PSUs, Patch Sets and Releases

How often did I launch a search in MyOracle Support (MOS) for a specific Bundle Patch or Patch Set Update. And usually the MOS search results don’t get me what I’m looking for no matter how clever I search. But there was relief. A MOS Note combined all PSUs and BPs and much more into table format including the links. But what if there would be a Download Assistant for RUs, RURs, BPs, PSUs, Patch Sets and Releases? I did blog about the previous magic note a while back: Where is the Jan 2017 PSU for Oracle Database 11.2.0.4? But…

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…

My thoughts about the new Oracle Database Release Schedule

Changes to a well-known release model mean a lot. I will give you some of my thoughts about the new Oracle Database release schedule. What are we changing? In my own words we basically rename the patch sets and name them what they were since years: Full releases. This means, Oracle Database 12.2.0.2 will be Oracle 18. And Oracle 12.2.0.3 will be Oracle 19. And so on. Therefore there won’t be any Oracle 12.2.0.2 anymore – and obviously no Oracle 13.1 followed by Oracle 13.2. In addition we change from Proactive Bundle Patches (BP) to Release Updates (RU) and from…

News about the new Oracle Database Release Schedule

There are news about the new Oracle Database release schedule. Oracle updated MOS Note 742060.1 containing release information recently. A few weeks ago we changed from PSUs and BPs to RURs (Release Update Revisions) and RUs (Release Updates) beginning with Oracle Database 12.2. And now MOS Note 742060.1 – Release Schedule of Current Database Releases is updated as well. News about the new Oracle Database Release Schedule From MOS Note 742060.1 – Release Schedule of Current Database Releases: Release 12.2: New releases will be annual and the version will be the last two digits of the release year. The release…

Applying 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 Then I unzipped…

More Information about RU and RUR patches for Oracle 12.2

The first RU (Release Update) for Oracle Database 12.2.0.1 has been released. And Oracle Support provides some very helpful documents to explain the implication of the new RU (Release Update) and RUR (Release Update Revision) patches. More Information about RU and RUR patches for Oracle 12.2 First of all, these are the most important MOS notes to have a look at: MOS Note:742060.1 – Release Schedule for Current Database Releases (updated Aug 3, 2017 ) MOS Note: 2285040.1 – Release Update and Release Update Revisions for Database Proactive Patch Program MOS Note: 2275525.1 – FAQ for RU and RUR (not…

The first RU for Oracle Database 12.2.0.1 is available

The first RU (Release Update) for Oracle 12.2.0.1 is available Just in case the port you are looking for is not available right now please see the ETA dates in the link below. Details of the July 2017 Critical Patch Advisory Find the General Information about the July 2017 Critical Patch Advisory here: http://www.oracle.com/technetwork/security-advisory/cpujul2017-3236622.html Find the Risk Matrix for the July 2017 Critical Patch Advisory here: http://www.oracle.com/technetwork/security-advisory/cpujul2017verbose-3236625.html#DB The details about the Database are included in this document: MOS Note: 2261562.1 – Patch Set Update and Critical Patch Update July 2017 Availability Document Please find the “Missing patches” in section 2.2…