Martins Blog

Powered by
WordPress

  • Incrementally gathering statistics in 10g

    One of the cool new features of the Oracle 11g database is that you can copy statistics and incrementally gather global stats for rlt (really large tables). I wanted to do some testing around these features in 10.2.0.4 but ran into a number of problems. So this is the story…. I have decided to split…

  • RAC SIG June 2010

    Good morning all! Just wanted to put up a quick note about the upcoming UKOUG RAC SIG in June. This is going to be a really good event showing some of the most prominent members of the Oracle community: Harald Van Breederode Joel Goodman Julian Dyke From an infrastructure point of view Simon Haslam is…

  • The difference between a direct grant and a role in PL/SQL

    This is a quick post about beginning Oracle PL/SQL development. Long story short, there is a difference between invoker rights and definer rights in the way they respect role grants: definer rights PL/SQL blocks are the default, and none of the role grants you have are available code blocks defined with invoker rights however do…

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