Martins Blog

Powered by
WordPress

  • Data Guard transport lag in OEM 12c

    I have come across this phenomenon a couple of times now so I thought it was worth writing up. Consider a scenario where you get an alert because your standby database has an apply lag. The alert is generated by OEM and when you log in and check-it has indeed an apply lag. Even worse,…

  • Massive tablespace fragmentation on LMT with ASSM

    I have been asked to investigate another interesting problem worth writing about. It’s worth mentioning here because it deals with a problem I believed to have long since been solved: tablespace fragmentation. However, in this case it was a locally managed tablespace (LMT) with Automatic Segment Space Management (ASSM) enabled. It should be difficult to…

  • Applying GI PSU 12.1.0.1.2 in the lab

    In my previous posts about the first RAC Grid Infrastructure Patchset I document a few issues I encountered that were worth noting. But where things work as advertised I am more than happy to document it too. In a way, the January 2014 GI PSU works as you’d hope it would (at least in my…

  • Applying PSU 12.1.0.1.1 to Oracle Restart

    I was actually hoping I had already written enough about applying the PSU for 12.1.0.1.0 but today I tried to apply the patch to my Oracle Restart home in my lab VM and guess what-it wasn’t as automatic as I thought. I must have performed the classic copy & paste error and applied the patch…

  • HCC error on Exadata after partitioning maintenance

    Recently I have been asked to investigate the following error on an Exadata system. ORA-64307: hybrid columnar compression is not supported for tablespaces on this storage type Well, that’s simple I thought! Must be (d)NFS mounted storage, right? Everyone knows that you can have HCC on Exadata (and a few other storage products). So I…

  • Interesting post-install steps for Oct 2013 12.1.0.1.1 PSU

    I have already written about RAC/Grid Infrastructure related patching of 12.1.0.1.0 to 12.1.0.1.1, aka the October 2013 PSU for the database. This post is a follow-up for pure RDBMS-only installations. I initially thought it wasn’t worth blogging about it (and hence the lag between the posts) but I came across an interesting post-apply step that…

  • SQLPlus and white space in the output

    I finally managed to work around My Most Annoying Problem (TM) with SQLPlus in my career. SQLPlus will mess up my output when I am copying/posting something in wordpress or elsewhere. Here’s an example to show you what I mean. The output in SQLPlus in my terminal window is all nice and pretty (it’s a print…

  • Playing with Application Continuity in RAC 12c

    One of the more interesting features in Oracle 12c RAC is application continuity. Why do I believe it is? Because it relieves developers from having to think about retrying connections and catch SQLExceptions in the code. I already thought that Fast Application Notification and Fast Connect Failover (FCF) are great, _but_ they required the developer…

  • Be aware of these environment variables in .bashrc et al.

    This is a quick post about one of my pet peeves-statically setting environment variables in .bashrc or other shell’s equivalents. I have been bitten by this a number of times. Sometimes it’s my own code, as in this story. Background Many installation instructions about Oracle version x tell you to add variables to your shell…

  • Upgrading to Oracle Linux 6.5

    This is a very short post to demonstrate how to upgrade to Oracle Linux 6.5. My lab system was reasonably current, Oracle Linux 6.4 with some security patches (but not all). The upgrade to 6.5 (or “latest”) is very simple, and since Oracle announced they had beefed up connectivity it’s a real joy. Instead of 450kb/s…