Martins Blog

Powered by
WordPress

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

  • Co-authoring Pro Oracle RAC 11g on Linux

    I am very happy to announce that I have the great honor to co-author the new edition of the successful Pro Oracle Database 10g RAC on Linux: Installation, Administration, and Performance. The first edition, Pro Oracle RAC 10g on Linux was my main reference when installing, configuration and maintaining RAC on Linux (my preferred platform).…

  • Installing RAC 11.2 on ocfs2 part I

    This post may not be relevant to the majority of people out there but I didn’t find a lot of useful documentation out there regarding RAC 11.2 on OCFS2 installations. And also I am in desparate need of my own test environment! Oracle Cluster File System version 2 is a promising cluster file system on…

  • Watch those environment variables

    One of my colleagues was about to install another ORACLE_HOME to our 3 node production cluster, with limited time available to him, as always on Saturdays. To make matters worse, OUI wouldn’t play ball and complain that the ORACLE_HOME location selected isn’t sharable. Pardon me? None of the file systems on the cluster are actually…