Martins Blog

Powered by
WordPress

  • Little things worth knowing: the latest public-yum-ol7.repo configuration file enables an upgrade to UEK R5

    For a little while now I have been using Ansible for all installation/configuration tasks I do in the lab. I can’t really be bothered to do these things by typing commands anymore: once you get the hang of Ansible, you can develop an urge to automate everything. As part of my playbook installing the Oracle database…

  • Little things worth knowing: parallel Data Pump export in table mode

    I haven’t used Data Pump in a little while but recently needed to do a bit of work involving this very useful utility to export a single table. I know that it is possible to export data in parallel using expdp, but I can’t recall the syntax for doing so off the top of my…

  • Installing Ansible on Oracle Linux 7 for test and development use

    There are a few alternative ways of installing Ansible on Linux, and the install guide for Ansible does a great job in explaining them all in detail.  There is a potentially easier way to get to a current Ansible version if you are using Oracle Linux 7, but it comes with a very important limitation.…

  • Bootstrapping a VM image in Oracle Cloud Infrastructure using cloud-init

    At the time of writing Oracle’s Cloud Infrastructure as a Service (IaaS) offers 2 ways to connect block storage to virtual machines: paravirtualised and via iSCSI. There are important differences between the two so please read the documentation to understand all the implications. I need all the performance I can get with my systems so…

  • Enhanced “validate” commands in Oracle’s Data Guard Broker 18c

    If you are using an Oracle Database Enterprise Edition chances are that there is at least one environment in your estate making use of Data Guard. And if you are using Data Guard, why not use the broker? I have been using Data Guard broker for a long time now, and it has definitely improved…

  • Log in to Ubuntu VMs in Oracle Cloud Infrastructure

    When I learned that Oracle was providing Ubuntu images in Oracle Cloud Infrastructure (OCI) I was a bit surprised at first. After all, Oracle provides a great Enterprise Linux distribution in the form of Oracle Linux. As a Ubuntu fan I do of course appreciate the addition of Ubuntu to the list of supported distributions.…

  • Terraforming the Oracle Cloud: choosing and using an image family

    For a few times now I have presented about “cloud deployments done the cloud way”, sharing lessons learned in the changing world I find myself in. It’s a lot of fun and so far I have been far too busy to blog about things I learned by trial and error. Working with Terraform turned out…

  • Ansible tips’n’tricks: executing related tasks together

    I have recently written an ansible playbook to apply one-off patches to an Oracle Home. While doing this, I hit a little snag that needed ironing out. Before continuing this post, it’s worth pointing out that I’m on: $ ansible –version ansible 2.6.5 And it’s Ansible on Fedora. Most likely the wrong way to do…

  • Using colplot to visualise performance data

    Back in 2011 I wrote a blog post about colplot but at that time focused on running the plot engine backed by a web server. However some people might not want to take this approach, and thinking about security it might not be the best idea in the world anyway. A port that isn’t opened can’t…

  • Running orachk as part of TFA with support tools bundle

    I have previously written a number of posts about OSWatcher integration in Tracefile Analyzer (TFA) w/support tools bundle (available from My Oracle Support Document ID 1513912.1). Thus far I have neglected another useful tool available to administrators in the same package: orachk. UPDATE This post covers an old version of the stack. At the time…