Configure Oracle EUSM to use LDAPS
With the introduction of Oracle 18c, eusm is officially designated as an Enterprise User Security Utility. It is now officially documented of the Enterprise User Security Administrator’s Guide. Before we had to be content with the somewhat sparse MOS note 1085065.1 EUSM, Command Line Tool…
DBMS_CLOUD Package – A Reference Guide
The Appendix A of the Using Oracle Autonomous Data Warehouse Cloud guide describes the DBMS_CLOUD package. Unfortunately, it documents only a subset of the subroutines. And, for some of them, the description could also be enhanced. Therefore, while I was testing all the subroutines the…
Oracle 18c new Security Features
Today I had the opportunity to give a presentation on Oracle 18c new Security Features at the SOUG day in Baden. It was a great opportunity to discuss the security enhancements in the latest Oracle database release. This release introduces some new security features that…
Oracle Home Management – part 7: Putting all together
Last part of the blog series… let’s see how to put everything together and have a single script that creates and provisions Oracle Home golden images: Review of the points The scripts will: let create a golden image based on the current Oracle Home save…
Oracle Home Management – part 6: Simple Golden Image Blueprint
As I explained in the previous blog posts, from a manageability perspective, you should not change the patch level of a deployed Oracle Home, but rather install and patch a new Oracle Home. With the same principle, Oracle Homes deployed on different hosts should have…
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…
Social Media @trivadis