Online Statistics Gathering for ETL – Part 1
Online Statistics Gathering has been introduced in 12c and is a very handy feature for ETL and batch jobs developers. However the devil is in the detail. There are some points to remember. Let’s take a closer look. Introduction If you are not familiar with…
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…
New version of set_exadata_passwords.sh
A new version of set_exadata_passwords.sh is available on GitHub. With new options and a bugfix for infiniband switches.The new version is now able to change the password only on one kind of component i.e. db nodes. I wrote about a problem with chpasswd on infiniband…
chpasswd not working after upgrade
After the upgrade of a infiniband switch from version 2.1.5-1 to 2.2.6-2 my script set_exadata_passwords.sh was not working anymore. It can’t change the password of the infiniband switches because the command chpasswd threw the following error: In the blog I’ll explain why it’s not working,…
New version of check_options.sh
A new version of check_options.sh is available on GitHub. Unified Audit is now detected by the new version. It depends on kzaiang.o if it’s on and kzanang.o if off. For a more detailed description what the script does, please have a look here.
Oracle Enterprise Manager Audit
Why you should read this blog post? You need to take care of the Audit function from OEM CC even if you don’t want to use it. It’s enabled by default and needs to be managed! Housekeeping for audit Per default the audit function of…