Martins Blog

Powered by
WordPress

  • Building an RPM for the Oracle database on Oracle Linux 7

    Thinking about automation a lot, especially in the context of cloud computing, I have decided to create a small series of related posts that hopefully help someone deploying environments in a fully automated way. As my colleague @fritshoogland has said many times: the only way to deploy database servers (or any other server for that…

  • Little things worth knowing: when a transient ASM disk failure cannot be fixed in time

    In the previous blog post I used libvirt and KVM in my lab environment to simulate a transient disk failure and how to recover from it. This post takes this example a step further: I am simulating another disk failure, but this time won’t pretend I can fix the issue and put it back. In…

  • Little things worth knowing: transient ASM disk failures in 12c

    For quite some time we have been treated nicely by ASM when it comes to transient disk failures. Since 11.1 (if memory serves me right), transient failures won’t cause an ASM disk to be dropped immediately. This is good, because it can potentially save a lot of time! When a disk is dropped from an…

  • Comparing workloads across databases

    Does this question sound familiar? “We are running the exact same workload in UAT as we do in production, but it behaves completely different. Can you help?” If it does, then you might find the following post useful, provided you are appropriately licensed to use this feature anyway. I have been working on AWR data…

  • Little things worth knowing: using Remote Diagnostic Agent more effectively with profiles

    RDA, or the Remote Diagnostics Agent, has been around for a little while. Over the time, and with the growing number of Oracle’s acquisitions it has become, shall we say, a little more difficult to handle. It appears to me as if every one of them will have its diagnostics handled by RDA making it…

  • OSWatcher integration in Trace File Analyzer (TFA)

    Some time ago I wrote a post about using OSWatcher for system analysis. Neil Chandler (@ChandlerDBA) rightfully pointed out that although OSWatcher on its own was all right, Tracefile Analyzer(TFA) was the way to go. TFA can include OSWatcher, but more importantly it adds a lot of value over and above what OSWatcher does. Up…

  • Preventing a SPOF with CMAN 12c

    I have already written about the use of Connection Manager 11.2 to govern access to a database. While researching this piece I have updated the original post so that it’s relevant for 12c as well. Although the idea of using Connection Manager is tempting, the obvious first question is about high availability of the process, you…

  • Tales from the field: potential reasons for PDB plug-in violations part 2

    In the first part of this little series I explained how a missing (default) tablespace in a PDB can have an impact when opening it. In this instalment I’ll add another common cause for PDBs not opening in read-write mode: different patch levels between the PDB to be plugged in and the CDB. Scenario Assume…

  • Tales from the field: potential reasons for PDB plug-in violations part 1

    Container Databases have been an area that I have researched intensively over the past years. With this post (and hopefully some others that follow) I would like to demonstrate some of the new situations the DBA might be confronted with. Please don’t use this post to give the new 12c architecture a hard time: standardised deployments…

  • Automatic Deployment of CDBs with non-default database options in 12.1.0.2

    I have written about the importance of automation in previous posts, and this one is following the same line. This time I wanted to test and document my experience with “golden database templates”. Wy? Because most DBAs will appreciate that there are more interesting things to do than to run “create database” scripts all day, so…