Martins Blog

Powered by
WordPress

  • Moving OCR and voting disks to block devices in CRS 10.2

    Anyone to suggest a shorter title for this: you are welcome to comment! Initially I wanted to have this in the first of today’s posts, but got side tracked. So here’s the next step in the CRS 10.2.0.5 installation: moving off the deprecated raw devices to block devices. This is something you can do with…

  • Patching CRS to 10.2.0.5

    A small blog post about patching CRS 10.2.0.1 to 10.2.0.5 instead of applying the latest PSU on top of 10.2.0.4. So it finally happened! Oracle has released the terminal patchset for 10g Release 2. Long overdue! So the task at hand today is to upgrade CRS to 10.2.0.5. Patch Download patch 8202632 to a convenient…

  • Thousands of core dumps in $OMS_HOME

    I have been asked to debug a problem with another office’s Grid Control 10.2.0.5 setup. In a nutshell users complained they could not log in, and those who were previously connected were kicked out. Hmm, so much for a briefing. When troubleshooting Grid Control it is important to remember that Oracle’s monitoring product is made…

  • tnsping segmentation fault with 10.2 client

    The tale of a very interesting problem with a segmentation fault on RHEL 5.3 64bit when invoking tnsping. I initially thought the box the client was installed on (a development virtual machine) was seriously ill but it turned out to be something else altogether. Here is the initial problem. One of the developers contacted me…

  • PRKP-1061, CRS-2518 and CRS-0219 with 10.2 RDBMS and 11.2 CRS

    Couldn’t find a better title for this, but hopefully makes it easier to locate the problem when using your favourite search engine. I tried to manage my 10.2.0.4.1 3 node RAC database “QA” for which I upgraded Grid Infrastructure to 11.2.0.1. The problem arose when I tried to disable the 10g database, and then when…

  • Compiling PHP 5.3.2 for Oracle 11.2 and Apache 2.2.3

    httpd,apache,oci8,php5

  • Updates on my knowledge base

    A productive day today, and also the right time to advertise my knowledge base on http://www.the-playground.de/ . I learned about a few things, as I am testing database resident connection pooling with Oracle and CGI-bin (anyone remember mod_cgi :). Want to get PHP up and running against my four node RAC cluster as well. SSH…

  • Change SCAN post installation

    A quick note to myself on how to change the SCAN from /etc/hosts to DNS. I have set up a small DNS server for a local interface on my dom0 to help me resolve problems around TAF and session failover in general. This is a test/dev/playground cluster-you should have never been in this situation with…

  • ORA-604 when starting the database

    Interesting scenario this morning with a development database. There is no specific monitoring in place for development systems so a user phoned us up stating that the database was inaccessible. The last lines in the alert.log showed a problem with a datafile not readable: Wed Apr 28 10:18:08 2010 Errors in file /u01/app/oracle/admin/devone/bdump/devone_pmon_3416.trc: ORA-00376: file…

  • Huge Pages and Linux-Real World example

    A common situation for many DBAs: all over sudden you are tasked to look at a database, and you are told you inherit it. Of course, a lot of problems exist with it, and you are supposed to fix them all. A few weeks ago this happened to me. The system is a Sun 4660…