Patch Recommendation

MRP3 for Oracle 19.17.0 adds an interesting surprise

You may have read my previous blog posts about MRPs (Monthly Recommended Patches). And today I did a quick check with Rodrigo. We both were a bit surprised to have the MRP3 for 19.17.0 add a lot of fixes to a standard RDBMS installation. So we were investigating a bit further. As a teaser, read on to see that MRP3 for Oracle 19.17.0 adds an interesting surprise.

MRP3 for Oracle 19.17.0 adds an interesting surprise

Photo by David Brooke Martin on Unsplash

How did we find out?

The MRP3 for Oracle Database 19.17.0 got released just a week ago. You can navigate to it via MOS …

Oracle Security Alerts for July 2019 got published

Posted on July 16, 2019 by Mike.Dietrich Patch Recommendation 14

It’s patching day. And I’m already downloading the patch bundles for all my installations (11.2.0.4, 12.1.0.2, 12.2.0.1, 18c and 19c). The Oracle Security Alerts for July 2019 got published today.

Oracle Security Alerts for July 2019 got published

Patch Advisory and Risk Matrix

You can find the July 2019 Patch Advisory here. I checked the risk matrix for the database. It contains 8 new fixes for the database server. Please pay attention that 3 of the vulnerabilities may be exploitable from a client without an Oracle Database server being installed. The highest score is 9.8.

Please check the risk matrix by yourself:

Special characters show junk in CLOB columns after upgrade to Oracle 12.2.0.1 with JDBC

Posted on July 13, 2018 by Mike.Dietrich Patch Recommendation 8

Thanks to my support colleague Roland Graeff who told me about this issue at a customer today. And I consider this a pretty serious issue. It can happen that Special characters show junk in CLOB columns after upgrade to Oracle 12.2.0.1. with JDBC.

This is as bad as it sounds. Roland told me about a case where the application showed weird characters instead of German umlauts (ä, ö, ü, Ä, Ö, Ü) after an upgrade from Oracle Database 12.1.0.2 to 12.2.0.1.

Special characters show junk in CLOB columns after upgrade to Oracle 12.2.0.1 with JDBC

Roland explained to me that …

Differences between PSU / BP and RU / RUR

Posted on October 24, 2017 by Mike.Dietrich Patch Recommendation 26

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 …

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

Posted on October 13, 2017 by Mike.Dietrich Patch Recommendation 7

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

_rowsets_enabled – Apply patch and use the default

Posted on October 11, 2016 by Mike.Dietrich Flaws and Pitfalls Optimizer Oracle Database 12c Parameters Patch Recommendation 2

I while back I blogged about issues with “rowsets“, a new Oracle 12c feature which unfortunately had two known wrong result (WQR) bugs:

Switch off “_rowsets_enabled” in Oracle Database 12c

UPDATE: _rowsets_enabled in Oracle Database 12c

What does “rowsets” actually mean?

I’d like to thank Sankar, our Development manager for providing this explanation which sheds some light on how important this feature actually is:

“Rowsets is a SQL execution performance enhancement introduced in Oracle RDBMS release 12.1 and further extended in a future release of the Oracle Database.

Prior to 12.1, data processing in the SQL layer were

Patching does not work – Journey to the Cloud VI

Posted on April 18, 2016 by Mike.Dietrich Cloud Patch Recommendation 0

What happened so far on my Journey to the Cloud?

Patching in the Cloud

I would like to patch my Oracle DBaaS Cloud today. It was so simple a …

Switch off “_rowsets_enabled” in Oracle Database 12c

Posted on November 10, 2015 by Mike.Dietrich Flaws and Pitfalls Optimizer Oracle Database 12c Parameters 2

Please find a recent update here:

UPDATE: _rowsets_enabled in Oracle Database 12c

and more important:

_rowsets_enabled – Apply patch and use the default

Twitter is a good thing. I get alerted on things I haven’t seen before. And sometimes some things are more than interesting.

This one is actually proven by Jonathan Lewis – and you can read all the details in Jonathan’s blog post here:

https://jonathanlewis.wordpress.com/2015/11/09/wrong-results/

There seems to be a realistic chance to get wrong query results displayed (regardless of using SQL*Plus or a JDBC or any other client – see the comment by Stefan Koehler below …

Oracle PSU and BP April 2015 is available

Posted on April 20, 2015 by Mike.Dietrich Patch Recommendation 0

As of April 14, 2015:

The April 2015 PSU/BP is available!

Here’s the most important information:

OTN – General Critical Patch Update Advisory
MOS Note:1967243.1
PSU and CPU April 2015 Availability Document
MOS Note:1967534.1
PSU and CPU April 2015 Database Known Issues
MOS Note:1962125.1
Oracle Database – Overview of Database Patch Delivery Methods
.
VERY IMPORTANT
Please see also MOS Note:1967539.1 Oracle Quarterly Database Patch 12.1.0.2.7 Known Issues
Thanks to Pieter who had very unfunny issues when trying to apply the April PSU to a customer’s GI with Oct 2014 PSU in the home already …

“Apparently when we want

Patch Recommendation

MRP3 for Oracle 19.17.0 adds an interesting surprise

How did we find out?

Oracle Security Alerts for July 2019 got published

Patch Advisory and Risk Matrix

Special characters show junk in CLOB columns after upgrade to Oracle 12.2.0.1 with JDBC

Special characters show junk in CLOB columns after upgrade to Oracle 12.2.0.1 with JDBC

Differences between PSU / BP and RU / RUR

No change on MS Windows

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

_rowsets_enabled – Apply patch and use the default

What does “rowsets” actually mean?

Patching does not work – Journey to the Cloud VI

What happened so far on my Journey to the Cloud?

Patching in the Cloud

Switch off “_rowsets_enabled” in Oracle Database 12c

Oracle PSU and BP April 2015 is available

Archives

Categories

Upgrade @YouTube

RSS Feed for Upgrade your Database – NOW!

Subscribe via Email

Recent Posts