Martins Blog

Powered by
WordPress

  • Little things worth knowing: OSWatcher Analyser Dashboard

    I have written a few articles about Tracefile Analyzer (TFA) in the recent past. As you may recall from these posts, a more comprehensive TFA version than the one provided with the installation media is available from My Oracle Support (MOS for short). As part of this version, you get a lot of useful, additional…

  • Ansible tips’n’tricks: assessing your runtime environment

    One thing that I frequently need to do is test for a certain condition, and fail if it is not met. After all, I want to write those playbooks in a safe way. Here is an example: I need to ensure that my playbook only runs on Oracle Linux 7. How can I do this?…

  • Ansible tips’n’tricks: even more output options

    In my last post I wrote about the “debug” option to format Ansible output differently. I came across this setting simply by searching the usual developer forums for an alternative Ansible output option. Having found out about the “debug” option made me curious, especially since there wasn’t an awful lot of documentation available about additional…

  • 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…