Oracle Patching RU & RURs

-

More Information about RU and RUR patches for Oracle 12.2



What is an RU?
An RU is a Release Update. And there’s not much difference except for the name to an Proactive Bundle Patch.
In addition there are RURs: Release Update Revisions.
Those are very similar to Patch Set Updates containing less changes.

You may have read my previous blog posts from the past years: I strongly favor RUs (formerly known as Proactive Bundle Patches) over RURs (formerly known as PSUs) for many reasons:


First of all, these are the most important MOS notes to have a look at:


A few important things upfront:
  • For Oracle Database 12.2.0.1 there’s no change in release numbering
  • No RUs and RURs for Oracle Database 12.1.0.2 and Oracle Database 11.2.0.4 but still – as before – SPUs, PSUs and BPs
  • RU patches right now are more or less the same as Proactive Bundle Patches (BPs)
  • RUR patches right now are more or less the same as Patch Set Updates (PSUs)
  • Quarterly schedules stay as before
  • Interim (one-off) patches still exist
  • In July 2017 we are releasing a Database RU, a Grid Infrastructure RU, and an OJVM RU.
  • There are no PSUs or Bundle Patches for the 12.2.0.1 release
  • The first RUR for Oracle Database 12.2.0.1 is planned for October 2017
  • In October 2017 at the usual quarterly release date the 2nd RU for Oracle Database 12.2.0.1 is planned to get released
  • In January 2018 at the usual quarterly release date the 3rd RU and the 2nd RUR should be released for Oracle Database 12.2.0.1.
  • The plan is to release only two RURs per RU


Should we take the PSUs or the BPs? RURs or RUs?
PSUs are Patch Set Updates,
BPs are (sometimes called: Proactive) Bundle Patches.
RUs are Release Upgrades which replace the BPs in Oracle Database 12.2.0.1,
RURs are Release Upgrade Revisions which DON’T replace the PSUs in Oracle Database 12.2.0.1.. And this is important – Revisions are different from PSUs.

And the answer is very simple:
  • If you have an Oracle Engineered System: Take the Bundle Patches for Engineered Systems
  • In all other cases:
    • If you are on Oracle Database 12.2.0.1 or newer: Take the Upgrades (RU)
    • If you are on Oracle Database 12.1.0.x: Take the Bundle Patches (BP)
    • If you are on Oracle Database 11.2.0.4: Take the Patch Set Updates (PSU)
    • If you are on a release below Oracle Database 11.2.0.4: Upgrade!





Oracle Database - Overview of Database Patch Delivery Methods - 12.1.0.2 and older (Doc ID 1962125.1)

Comments

Post a Comment

Popular posts from this blog

SQL SERVER – Event ID 107- Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database.

-
SQL SERVER – Event ID 107- Report Server Windows Service cannot connect to the report server database. Error with Report Server One of my clients reported an error which is the subject of the blog. In the event viewer they were seeing below error:     Event Type: Error Event Source: Report Server Windows Service (MSSQLSERVER) Event Category: Management Event ID: 107 Computer: SQLSERVER Description: Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database The error is generic because it doesn’t tell the exact error which is causing a connectivity error. My immediate question was that, are there any more errors? So, I asked them to look at Reporting Service Log file. Report Server Windows Service (MSSQLSERVER) cannot connect to the report server database. The application domain WindowsService_17 failed to initialize. Error: Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerDatabaseUnavailableException: The report se
Read more

SQL Server Builds Information

-
Image
Very Useful information about SQL Server Builds .  It is nicely presented in the blog . Please see  below for our reference . Microsoft SQL Server Version List What version of SQL Server do I have? This unofficial build chart lists all of the known Service Packs ( SP ), Cumulative Updates ( CU ), patches, hotfixes and other builds of MS SQL Server 2017, 2016, 2014, 2012, 2008 R2, 2008, 2005, 2000, 7.0, 6.5 and 6.0 that have been released. Useful articles: How to identify your SQL Server version and edition SQL Server Internal Database Versions Microsoft SQL Server Support Lifecycle Microsoft SQL Server Home Microsoft SQL Server Developer Center Microsoft TechNet: Microsoft SQL Server Microsoft Knowledge Base Sqlservr.exe versions   Quick summary:   RTM (no SP ) SP1 SP2 SP3 SP4   SQL Server 2017      codename vNext 14.0.1000.169 *new           SQL Server 2016 13.0.1601.5 13.0.4001.0 or 13.1.4001.0 13.0.5026.0 or 13.2.5026.0   S
Read more

Using DBCA silent install and disabling automatic memory management

-
Image
Avoid issue [DBT-11211] /app/oracle/product/12.2.0/dbhome_1/bin=> dbca -silent -createDatabase -templateName db_kp_template.dbt -gdbname dgtest1 -sid dgtest1 -responseFile NO_VALUE -characterSet AL32UTF8 -memoryPercentage 20 -emConfiguration NONE [FATAL] [DBT-11211] The Automatic Memory Management option is not allowed when the total physical memory is greater than 4GB.    CAUSE: The current total physical memory is 11GB. Solution : disable automatic memory management with in the response file and you will be fine :) .  /app/oracle/product/12.2.0/dbhome_1/assistants/dbca/templates=> dbca -silent -createDatabase -templateName db_kp_template.dbt -gdbname dgtest1 -sid dgtest1 -responseFile NO_VALUE -characterSet AL32UTF8 -automaticMemoryManagement FALSE -memoryPercentage 20 -emConfiguration NONE Enter SYS user password: Enter SYSTEM user password: [WARNING] [DBT-06208] The 'SYS' password entered does not conform to the Oracle recommended standards.    CAUS
Read more