Martins Blog

Powered by
WordPress

  • How to move OCR and voting disks into ASM

    Moving OCR and voting disk into ASM is the Oracle Grid Infrastructure or 11.2 way of storing essential metadata. During new installations this is quite simple since the work is done by OUI. When upgrading to 11.2 from a previous Oracle release, things look slightly different. Note that storing OCR and voting disk on raw…

  • Compile DBD::Oracle 1.23 with Oracle 11.2 client

    This article discusses how to compile DBD::Oracle for Oracle client 11.2 x86-64 on Linux (Fedora 12 to be precise). I recommend not to mess around with your distribution’s perl, that’s why I will base it on ActivePerl 5.10 from Activestate.com. If you (and you system administrator don’t mind mangling your distribution’s perl you might skip…

  • Policy managed databases

    This is a long overdue reply to an email Mark Bobak sent to the oracle-l mailing list. The questions Mark asked were regarding policy managed databases, a new 11g Release 2 feature. Since I have been very interested in the same topic (and also partly due to the fact that I am presenting about this…

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