Powered by
WordPress
  • Summer Seminars

    I am doing a couple of one day seminars with Oracle University, currently planned for Austria and Switzerland. They go by the title “Grid Intrastructure and Database High Availability Deep Dive”, and can be accessed via these links. Switzerland Austria To save you from having to get the abstract, I copied it from the Oracle…

  • Copying the password file for RAC databases

    This post is inspired by a recent thread on the oracle-l mailing list. In post “11g RAC orapw file issue- RAC nodes not updated” the fact that the password file is local to the instance has been brought up. In fact, all users with the SYSOPER or SYSDBA role granted are stored in the password…

  • Troubleshooting Grid Infrastructure startup

    This has been an interesting story today when one of my blades decided to reboot after an EXT3 journal error. The hard facts first: Oracle Linux 5.5 with kernel 2.6.18-194.11.4.0.1.el5 Oracle 11.2.0.2 RAC Bonded NICs for private and public networks. Private bondn device defined on a VLAN BL685-G6 with 128G RAM First I noticed the…

  • DBCA failing to create RAC databases

    This is a weird problem I ran in today. As part of an automation project the code deploys RAC One databases across a cluster, depending on the capacity available of the node. These are 128G RAM BL685c G6 currently but will be upgraded to G7 later. Now, my problem was that after the weekend we…

  • Cluster callouts to create blackouts in EM

    Finally I got around to providing a useful example for a cluster callout script. It is actually on the verge of taking too long-remember that scripts in the $GRID_HOME/racg/usrco/ directory should execute quickly. Before deploying this, you should definitely ensure that the script executes quickly enough-the “time” utility can help you with this. Nevertheless this…

  • Presenting at Miracle Open World 2011

    Just a really quick post about my appearance at Miracle Open World 2011 in Denmark next month: http://www.mow2011.dk/ I strongly recommend you to have a look at the agenda and speakers, there are lots of fellow Oak Table members sharing their knowledge-quite an incredible lineup and a great honour for me to be there.

  • Automatic log gathering for Grid Control 11.1

    Still debugging the OMS problem (it occasionally hangs and has to be restarted) I wrote a small shell script to help me gather all required logs for Oracle support. These are the logs I need for the SR, Niall Litchfield has written a recent blog post about other useful log locations. The script is basic,…

  • Quis custodiet ipsos custodies-Nagios monitoring for Grid Control

    I have a strange problem with my Grid Control 11.10.1.2 Management Server in a Solaris 10 zone. When restarted, the OMS will serve requests fine for about 2 to 4 hours and then “hang”. Checking the Admin Server console I can see that there are stuck threads. The same information is also recorded in the…

  • GC 11.1 and Monitoring Templates

    Throughout the last 2 weeks I have been working (or better: tried to work) with Grid Control 11.1 as the central monitoring and deployment solution for my current project. The plan is to use EMGC 11.1 in conjunction with an 8 node cluster to automatically deploy RAC One Node databases. Please don’t ask about RAC…

  • Using wget and proxy to download patches from MOS

    This is a rather quick note, but can be quite useful in certain situations. I currently look after a system which is quite difficult to jump on. That means before I get to do a “sudo su – oracle” I need to get to a jump-off box, ssh to 2 other machines and then log…