Martins Blog

Powered by
WordPress

  • Installing Virtualbox Guest Additions for Oracle Linux 8.2

    Since I can never remember how to install Virtualbox Guest Additions I thought I’d write it down. Maybe it’ll save you a few minutes; I know it will save me a lot of time ;) Update 230914 this procedure still works with Oracle Linux 8.8 guests. For this post I used the latest versions at…

  • Copying a SQL Plan Baseline from one database to another

    Hopefully this post saves you a few minutes looking the procedure up. I know it’ll save me some time ;) In this rather lengthy article I’d like to cover how I copied a SQL Plan Baseline from one database to another. If you find this procedure useful, please ensure your system is appropriately licensed for…

  • SQLDeveloper’s “mystats.sql” equivalent

    It just occurred to me that I haven’t blogged about SQLDeveloper yet, something I really need to change ;) This post covers SQLDeveloper 19.4, and although I don’t know exactly when the feature you are reading about was added I doubt it was in the latest release. A little bit of background first Sometimes the…

  • Silent installation: Oracle Restart 19c, ASM Filter Driver, UEK 5+ edition

    As promised in an earlier post here are my notes about installing Oracle Restart with ASM Filter Driver (ASMFD) 19c on Oracle Linux 7 using UEK 5. Updates 210812: I successfully used the same approach for Oracle Linux 7.9/UEK 6 260713: Oracle ASM Filter Driver (ASMFD) is desupported on both Linux and Oracle Solaris beginning…

  • Versioning for your local Vagrant boxes: handling updates

    In my last post I summarised how to enable versioning for Vagrant box outside Vagrant’s cloud. In this part I’d like to share how to update a box. My environment The environment hasn’t changed compared to the first post. In summary I’m using Ubuntu 20.04 LTS Virtualbox 6.1.6 Vagrant 2.2.7 Updating a box Let’s assume…

  • Versioning for your local Vagrant boxes: adding a new box

    I have been using Vagrant for quite some time now can’t tell you how much of a productivity boost it has been. All the VMs I have on my laptop are either powered by Vagrant, or feed into the Vagrant workflow. One thing I haven’t worked out though is how to use versioning outside of…

  • Fresh install: Autonomous Health Framework for single instance Oracle 19c

    I have been deploying Tracefile Anlyzer (TFA) to every system I’m looking after, whenever possible. Going back in the history of this weblog I created quite a few posts about how you can do so, too. When writing these posts back in 2018, TFA was available on its own. In the meantime TFA has been…

  • 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. Update 260713:…

  • 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. Update 260713: Oracle ASM Filter Driver (ASMFD)…