Partition-Wise Operations – New Features in 12c and 18c
This post was originally published on this sitePartition-wise operations are not something new. I do not remember when they were introduced, but at that time the release number was still a single digit. Anyway, the aim of this post is not to describe the basics,…
Oracle Unified Directory systemd unit file
This post was originally published on this siteAbout a year ago I explained in the blog post Start OUD Servers on Boot using systemd how to start Oracle Unified Directory automatically on system startup. In the meantime a lot has changed, so has my unit…
Oracle Home Management – part 4: Challenges and Opportunities of the New Release Model
This post was originally published on this siteStarting with the upcoming next release (18c), the Oracle Database will be a yearly release. (18c, 19c, etc). New yearly releases will contain only new features ready to go, and eventually some new features for performance improvements (plus…
Oracle Home Management – part 3: Strengths and limitations of Rapid Home Provisioning
This post was originally published on this siteIn the previous post I mentioned that having a central repository storing the Golden Images would be the best solution for the Oracle Home provisioning. In this context, Oracle provides Rapid Home Provisioning: a product included in Oracle…
Oracle Home Management – part 2: Common patching patterns
This post was originally published on this site (*) Multiple times in this blog post I refer to a problem with new Oracle Home installs and rollback scripts. The problem has been fixed with PSU Jan 2017, I did not notice it before, sorry. Thanks to…
Corrupting characters – How to get invalid byte values stored in strings
This post was originally published on this siteHaving worked with Database Migration Assistant for Unicode (DMU) to convert some databases from single-byte charactersets to AL32UTF8, I had problems with DMU reporting a lot of characters with invalid byte values (in this case binary values that…
Oracle Home Management – part 1: “Patch soon, patch often” vs. reality
This post was originally published on this siteWith this post, I am starting a new blog series about Oracle Database home management, provisioning, patching… Best (and worst) practices, common practices and blueprints from my point of view as consultant and, sometimes, as operational DBA. I…
DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL not working on 12c? Here’s why…
This post was originally published on this siteIt is bad to realize, after a few years, that my customer’s Audit Cleanup procedures are not working properly for every database… NOTE: The post is based on standard audit, not unified audit. My customer developed a quite…
Oracle Critical Updates – etwas Statistik – das April-Update
This post was originally published on this siteIm Januar hatte ich in einem Artikel (siehe hier oder hier) über die quartalsmäßigen Critical Patches von Oracle mit etwas Statistik betrachtet. Nicht mit der Absicht, die Firma Oracle zu verteidigen, sondern den Schlagzeilen in den IT-Gazetten („Monsterpatch“,…