Psu patch April 2012, tales from the darkside

Introduction

This week I came across the fact that the readme files for Applying Psu patches is often a puzzle to people.  A PATCH action failed due to the fact that the –OH was NOT used, and in a Rac environment that is always something extra scary with dependencies.  So I thought let us have some clearer picture with regard to this matter. Today i had to patch Oracle Restart environment with Grid Infrastructure 112030 and ditto Rdbms.

In order to make a good reminder for myself and for the community, well here are the steps that I performed. I have added some comments where needed.

Continue reading

Missing Disk in Fra Diskgroup in ASM , and work your way back

Introduction

A single instance/Db  11gr2 under control of 11gr2 grid infrastructure with ASM as storage solution. In ASM the disks are defined as external redundancy due to  business rules ( no shooting the messenger please). I was Informed that a database  had crashed . Grid Infra structure ( nor manual actions ) were able to start the database again.  So I was asked  please go take look and fix asap . The good thing was that I was aware of maintenance in the ASM Disk group on that Tuesday September 4th. So when alarms started to go off  I had first clues (even Sherlock Holmes needs a  first clue right ?). As always the alert log was first place to check for me.  This document follows a number of steps during the analyses and the end status which was a proper database open (without reset logs). Bottom-line is give not up too fast. BUT also in this specific scenario it had been better if we had kicked the disk and started from scratch instead of trying to repair. But that being said I know that sounds wise when looking back ….

Continue reading

Installing Oracle Warehouse Builder in 11GR2

Introduction:

For a customer I have to implement  Oracle Warehouse builder on several servers. So it became an interesting session cause during exploring, well actually it was already during installing found out that there are dependencies to  other products that need to be present in the database before you can finish the job successfully. But as always Google  is your friend so i was very happy in the end to  summarise the steps and put them to a blog.

Bottom-line is that the following components need be present in your database before you can start with the Oracle  Warehouse builder:

  • Java virtual Machine
  • Olap

The remarkable thing was that during exploring i came across the  fact that if you  create your database via DBCA these components are  installed. If you are a diehard  and use the command line  /  scripts for that well then you need to do just a bit extra to be victorious. The environments in this note were set up manually.

Continue reading

The Case of a Missing or Corrupt Spfile in your Grid Infra (11.2.0.3.0)

Introduction

On a grid infra-structure (11.2.0.3.0) cluster (SRVR1Rr – 2r -3r) we got more and more tickets that the ASM instances where having fragmented memory for the shared pool. The investigation showed that there was no SPFILE present, with automatic memory management in there. So this environment clearly needed better.  Only thing found was some out of date INIT.ORA.  From history this environment had been set up as an 11gr1 RAC cluster, and some time ago it had been upgraded to 11gr2 Grid Infra.

Continue reading