Monitoring Oracle 10g RAC with Quest Spotlight on RAC - Part I
January 24, 2006
You have heard the hype around a particular technology. It's cool and everyone wants a piece of it. Then it's the post-hype era for a technology where it is getting serious attention from the Big Players and eventually its commoditization. Breakthrough technologies, like Oracle RAC or Server Partitioning (fondly known as Virtualization), will eventually be commonplace. Therefore, it is time for your DBA to monitor several oracle RACs. The scenario could range from a RAC farm, as massive as 36-Node Oracle RAC, to a 2-Node Oracle RAC. Being confronted with questions like these is very normal to a curious DBA:
As you can see, the list is endless. You have migrated to a heavy duty Oracle RAC and you see performance drop. Unfortunately, you cannot see exactly what might be going wrong.
Introducing Spotlight on RAC (SoRAC)
It is time to say hello to SoRAC (Spotlight on RAC by Quest Software) which is well out of beta phase and very soon to be GA. I had the pleasure of participating in the beta program and was rather pleased with the results (even though it was still in beta phase).
SoRAC provides detailed diagnostic information by drilling down individual instances and merging the appropriate calculations into one interface called "SoRAC Homepage." And it's all live!
Overview of Spotlight on Oracle RAC
What is this tool capable of?
It provides three classes of functionality to a RAC DBA.
What Platform does it support?
The initial release will still provide support to a RACs running on Unix/Linux based systems such as RHEL/Solaris. There is theoretical support for a typical 36-node cluster but formally, you monitor a 16-node cluster with ease.
You will, however, need an Oracle Client software installation and you can get it here although you will need to adjust your TNSNAMES.ora file, as this will be used to make a connection to your RAC Service.
Getting Spotlight on RAC
Spotlight on RAC should be available very soon. (So I heard from the Marketing Manager) and then you should be able to download an evaluation from here .