Martins Blog

Powered by
WordPress

  • RAC service weirdness

    I ran into a problem starting one out of 14 services registered to my database this weekend. All of it happened after a restart of the servers following a redhat upgrade from 5.3 to 5.4. One of the servers had a file system corruption which required some extensive fsck’ing so only 2 out of 3…

  • It is indeed possible to install Oracle 11.2 on OpenSolaris

    After I set up OpenSolaris 2009.06 (see my previous posts) on my openSuSE 11.2 dom0 I was keen to set up Oracle 11.2 single instance on ZFS. ZFS is a new-ish filesystem and successor to ufs no Solaris 10. I like it a lot for simplicty and ease of use. Piet de Visser should love…

  • Build your own RAC system part V – add RDBMS home

    This article concludes my short series about how to build your own RAC system-I might explore an extended distance cluster with 11.2 soon so stay tuned for more material. As you could read in my previous posts, I have installed a cluster on 2 (now 3) nodes, with a fresh 11.2 Grid Infrastructure installation. I…

  • Server Pool experiments in RAC 11.2

    I spent Wednesday at UKOUG RAC & HA SIG and it was one of the best events I ever attended. Great  audience, and great feedback. One question I was particularly interested in was raised during my presentation, regarding server pools. I have now finally had the chance to experiment with this exciting new feature, my…

  • Check for non-successful connection attempts in listener.log

    This could become a regular question from your security team: can you find out if someone tried to mess with the listener when trying to connect? Often you see hackers target port 1521 and sending random data and/or garbage over the wire. The listener initially accepts the connection but closes it when it doesn’t receive…

  • Upgrade ASM 10.2 to 11.2 single instance

    This post describes how to upgrade an existing single instance ASM installation to the latest and greatest, Oracle 11.2. The most noteworthy change is that ASM is no longer installed using RDBMS installer but rather the Grid Infrastructure. Huh-installing CRS for single instance? That at first sounded like a bit of an overkill but Oracle…

  • OpenSolaris 2009.06 domU on opensuse 11.2 dom0

    I was curious to get started with opensolaris and quite eager to install it as a domU on a Linux dom0. There would have been little problem to do it the other way around. Actually, I could have installed opensolaris on my Toshiba R600 too! Then I tried out a number of current linux distributions,…

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