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

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

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…

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…

_rowsets_enabled – Apply patch and use the default

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 done on…

Patching does not work – Journey to the Cloud VI

What happened so far on my Journey to the Cloud? Part I – Push a Button (Dec 3, 2015) Part II – Switch On/Off and Remove (Dec 4, 2015) Part III – Patch, patch, patch (Dec 22, 2015) Part IV – Clean Up APEX (Jan 19, 2016) Part V – TDE is wonderful (Jan 28, 2016) You are here ==> Part VI – Patching does not work (Apr 18, 2016) Part VII – APEX is in CDB$ROOT again (Dec 21, 2016) Patching in the Cloud I would like to patch my Oracle DBaaS Cloud today. It was so simple a few weeks…

Switch off “_rowsets_enabled” in Oracle Database 12c

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 Jonathan’s…

Oracle PSU and BP April 2015 is available

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…