Martins Blog

Powered by
WordPress

  • Ansible tips’n’tricks: a different output option

    When running ansible scripts, occasionally you wonder why a given task has failed. I found out more than once that it’s commonly a problem with the script, not the engine ;) Finding out exactly where in the script I made the mistake can be more of a challenge. With the default ansible settings, output can…

  • Ansible tips’n’tricks: a new series

    In the past few months I have spent considerable amounts of time working on new technology (new as in “new to me”) and one of the things I have found a great interest-and more importantly-use cases with, is Ansible. Ansible is a fantastic piece of technology with decent documentation and great community support. I didn’t…

  • Creating a RAC 12.1 Data Guard Physical Standby environment (3b)

    Huh, what is this I hear you ask? Part 3b? Oracle 12.1? Well, there’s a bit of a story to this post. Back in December 2016 I started to write a series of blog posts (part 1 | part 2 | part 3 | part 4) about how I created a standby database on RAC…

  • RAC One node databases are relocated by opatchauto in 12.2 part 2

    In a previous post I shared how I found out that RAC One Node databases are relocated on-line during patching and I promised a few more tests and sharing of implications. If you aren’t familiar with RAC One Node I recommend having a look at the official documentation: The Real Application Clusters Administration and Deployment…

  • RAC One node databases are relocated by opatchauto in 12.2 part 1

    This is an interesting observation I wanted to share. I have a feeling as if there didn’t seem to be too much information out there for RAC One Node (RON) users, and I hope this helps someone thinking about patching his system. RAC-rolling patching is well documented in patch readme files, blog posts and official…

  • Little things worth knowing: Creating a RAC One Node database on the command line

    This post is going to be super short, and mostly just a note to myself as I constantly forget how to create a RAC One database on the command line. This post is for 12.2.0.1 but should be similar on 12.1 (although I didn’t test!). Provided you are licensed appropriately, this is probably the most…

  • OSWatcher, Tracefile Analyzer, and Oracle RAC 12.2

    When I started the series about Tracefile Analyzer (TFA) I promised three parts. One for single instance, another one for Oracle Restart and this one is going to be about Real Application Clusters. The previous two parts are published already, this is the final piece. The environment I am using a virtualised 2-node cluster named…

  • Hybrid Columnar Compression in 12.2 – nice new feature

    Oracle 12.2 introduced an interesting optimisation for Hybrid Columnar Compression (HCC). Until 12.2 you had to use direct path inserts into HCC compressed segments for data to be actually compressed. If you didn’t use a direct path insert you would still succeed in entering data into the segment, however your newly inserted data was not…

  • New option for configuring multipathing in Oracle Linux 7

    Teaching is and remains the best way for picking up new things :) While updating notes for a class I came across an interesting change in the way the device-mapper multipath works in Oracle Linux 7.4. In the past, everyone including me used scsi_id to get the WWID of a LUN for use with dm-multipath.…

  • You may still need gcc when patching Oracle Database 12.2

    I have previously written about changes in the Oracle 12.2 preinstall RPM and how gcc is no longer part of the dependencies list. As was pointed out to me, this shouldn’t be necessary anymore, according to the 12.2 Linux Database Installation Guide. Check the blue note for a statement indicating that gcc and gcc-c++ aren’t…