Martins Blog

Powered by
WordPress

  • OSWatcher as included in AHF 20.1.2 fails to start for single instance Oracle

    I am about to update my posts detailing the use of Tracefile Analyzer (TFA) now that Oracle has merged it into its Autonomous Health Framework (AHF) and came across an interesting observation worth blogging about upfront. After completing a fresh installation of AHF 20.1.2, the current version at the time of writing, I noticed OSWatcher…

  • Creating a new disk group for use with ASM Filter Driver on the command line in Oracle 19c

    In my previous post I shared my surprise when I learned that calling gridSetup.sh 19c for use with Oracle ASM Filter Driver (ASMFD) required me to specify the names of the native block devices. This is definitely different from installing ASM with ASMLib where you pass ASM disks as “ORCL:diskname” to the installer. Um, that’s…

  • Silent installation: Oracle Restart 19c, ASM Filter Driver, RHCK edition

    As promised in the earlier post here are my notes about installing Oracle Restart 19c on Oracle Linux 7.7 using the RedHat compatible kernel (RHCK). Please consult the ACFS/ASMFD compatibility matrix, My Oracle Support DocID 1369107.1 for the latest information about ASMFD compatibility with various kernels as well. Why am I starting the series with…

  • Oracle Restart 19c: silent installation and ASM Filter Driver

    Oracle 19c is has been getting a lot of traction recently, and I have been researching various aspects around its installation and use. One topic that came up recently was the installation of Oracle Restart 19c using ASM Filter Driver. ASM Filter Driver has been around for a little while, but I never really looked…

  • Passing complex data types to Ansible on the command line

    Earlier this year I wrote a post about passing JSON files as –extra-vars to ansible-playbook in order to simplify deployments and to make them more flexible. JSON syntax must be used to pass more complex data types to Ansible playbooks, the topic of this post. Unlike last time though I’ll pass the arguments directly to…

  • Printing all table preferences affecting dbms_stats.gather_table_stats

    Oracle 11g introduced the ability to control the behaviour of the dbms_stats package by setting preferences on the database, schema, and table level. These affect the way dbms_stats goes about doing its work. This feature has been extensively documented, I found the post by Maria Colgan exceptionally good at explaining the mechanism. I often have…

  • Ansible tips’n’tricks: defining –extra-vars as JSON

    While I’m continuing to learn more about Ansible I noticed a nifty little thing I wanted to share: it is possible to specify –extra-vars for an Ansible playbook in a JSON document in addition to the space-separated list of key=value pairs I have used so often. This can come in handy if you have many…

  • Initialising PL/SQL associative arrays in 18c and later

    I can never remember how to initialise PL/SQL associative arrays and thought I’d write a short post about it. This is primarily based on an article on Oracle’s Ask Tom site, plus a little extra detail from Steven Feuerstein. Associative arrays were previously known as index-by tables, by the way. Associative arrays before 18c Prior…

  • Vagrant tips’n’tricks: changing /etc/hosts automatically for Oracle Universal Installer

    Oracle Universal Installer, or OUI for short, doesn’t at all like it if the hostname resolves to an IP address in the 127.0.0.0/0 range. At best it complains, at worst it starts installing and configuring software only to abort and bury the real cause deep in the logs. I am a great fan of HashiCorp’s…

  • Tips’n’tricks: finding the (injected) private key pair used in Vagrant boxes

    In an earlier article I described how you could use SSH keys to log into a Vagrant box created by the Virtualbox provider. The previous post emphasised my preference for using custom Vagrant boxes and my own SSH keys. Nevertheless there are occasions when you can’t create your own Vagrant box, and you have to…