Oracle Home Management – part 5: Oracle Home Inventory and Naming Conventions
Having the capability of managing multiple Oracle Homes is fundamental for the following reasons: Out-of-place patching: cloning and patching a new Oracle Home usually takes less downtime than stopping the DBs and patching in-place Better control of downtime windows: if the databases are consolidated on…
Oracle Home Management – part 4: Challenges and Opportunities of the New Release Model
Starting 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 bug fixes and security fixes from the…
Oracle Home Management – part 3: Strengths and limitations of Rapid Home Provisioning
In 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 Grid Infrastructure that automates home provisioning and…
Oracle Home Management – part 2: Common patching patterns
(*) 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 Martin Berger for the information Let’s see some…
Oracle Home Management – part 1: “Patch soon, patch often” vs. reality
With 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 hope to find the time to continue…
DBMS_AUDIT_MGMT.CLEAN_AUDIT_TRAIL not working on 12c? Here’s why…
It 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 nice procedure for database housekeeping (including diag…
Basic Vagrantfile for multiple groups of VMs
In case you want to prepare multiple sets of machines quickly using Vagrant, ready for different setups, this might be something for you: ## -*- mode: ruby -*- ## vi: set ft=ruby : require ‘ipaddr’ ############################### # CUSTOM CONFIGURATION START ############################### # lab_name is the…
BP and Patch 22652097: set optimizer_adaptive_statistics to FALSE explicitly or it might not work!
Update 14.03.2018: After some exchanges with Nigel Bayliss, the behaviour described here has been filed as unpublished bug 27626925: OPTIMIZER ADAPTIVE STATS DEFAULT FALSE NOT HONORED WHEN ENABLED IN OCT OR JAN BP. It will be fixed starting with April’s bundle patch. According to…