Martins Blog

Powered by
WordPress

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

  • OSWatcher, Tracefile Analyzer, and Oracle Restart 12.2

    You are about to read the second part of this mini-series on TFA and Oracle 12.2. In the previous article I wrote about TFA and Oracle 12.2 single instance. In this short article I am going to have a look at TFA in a 12.2 Oracle Restart environment before rounding it up with an investigation…

  • OSWatcher, Tracefile Analyzer, and Oracle 12.2 single instance

    I have previously written about TFA, OSWatcher et all for Oracle 12.1. Since then, a lot of things have happened and I had an update for 12.2 on my to-do list for far too long. Experience teaches me that references to support notes and official documentation get out of date rather quickly, so as always,…

  • Little things worth knowing: redo transport in Data Guard 12.2 part 2

    In the first part of this article I looked at a number of views and some netstat output to show how redo is transported from the primary database to its standby systems. The long story short is that TT02 (“async ORL multi”) was found sending redo to CDB3 asynchronously whilest NSS2 (“sync”) transferred redo to…