Martins Blog

Powered by
WordPress

  • Upgrade Clusterware 10.2 to 11.2

    This post is about upgrading Oracle Clusterware 10.2.0.4 on Oracle Enterprise Linux 5.4 x86-64. The setup is as follows: 3 node RAC system, hostnames: racupgrade1, racupgrade2, racupgrade3 Oracle Clusterware 10.2.0.4 with CRS bundle patch 4-(patch 8436582) Oracle ASM 10.2.0.4.1, i.e. PSU 10.2.0.4.1 (patch 8576156) Oracle RDBMS 10.2.0.4.1 Additionally I patched OPatch and applied one off…

  • Xen-based virtualisation with opensuse 11.2

    I recently upgraded my laptop’s opensuse 11.1 installation to 11.2, mainly because it has updated xen to version 3.4 which makes it one of the most modern distributions with xen support available. I did some research first about which linux distribution would best suit my needs. When I came across a post which said that…

  • Hide SQL query in spool file

    This is a common problem I have: I need to generate a SQL script to be called from another SQL script in SQLplus. Best example: export user names, using this command for example: select ‘alter user ‘ || username || ‘ identified by values ”’ || password || ”’;’ from dba_users; To avoid the usually…

  • Installation of Fedora 12 x86-64 on Dell Optiplex 760

    These office PCs are actually quite nice-not powerfull but neither the opposite with a Core 2 Duo processor and in my case 4 GB of memory. I think they might be able to take on more memory which could come in handy later. The machines come with an on-board graphics and sound device and almost…

  • My first contact with the log miner

    I have never really played with log miner, but used it many times implicitly for streams. The need to get to grips with it arose when a developer created unrecoverable operations (i.e. something non-logging) in a QA system. I don’t want them to run the same in production so I had to find out who…

  • Restore table statistics

    UPDATE 230306 this post was originally written in December 2009. The examples have been verified & updated for Oracle 21.7.0, however there are most likely additional changes that have happened in the meantime that aren’t properly reflected here. Introduction The need to restore table statistics can be a common task for production DBAs. Let’s assume…

  • Recreate the standby controlfile when using ASM

    This is in reply to some work I was supposed to carry out over the weekend on a DR database. It could have been really simple, but it turned out it wasn’t. As part of a major migration I moved a 2TB database from OCFS to ASM, which worked really nicely with a Data Guard…

  • Explain plan doesn’t peek at variables

    I was trying to experiment with the 11g SQL Plan Management feature when stumbing across this. You will most likely go “ohh-of course it doesn’t” but I didn’t know it for sure until now. It’s another reason the expected explain plan differs from the actual explain plan, as discussed on the oracle-l mailing list recently.…

  • UKOUG Conference-session review part 3

    The final installment of this series deals with Tom Kyte’s top 10 features in 11.2 and Wolfgang Breitling’s “seeding statistics”. Tom Kyte – Top 10 new 11.2 features 1) dbms_parallel_execution: I was a little late so didn’t get the essence of this. Seems to automatically do what Tom described as “poor man’s parallelism” in his…

  • Let there be multipathing (when there wasn’t before)

    One of the projects I was working on recently couldn’t be finished as it should have been due to a lack of switch ports in the SAN. The QA database servers therefore only had single pathing to the storage whereas the production kit (thank god!) had multipathing enabled and configured correctly. UPDATE 221219: this document…