Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Jan 24, 2006

Monitoring Oracle 10g RAC with Quest Spotlight on RAC - Part I - Page 2

By Tarry Singh

Installing and Setting up

Installation is rather simple.

  • Install your Oracle Client Software.

  • Install SoRAC

  • Setting up the TNSNAMES.ora

  • Connecting to your RAC

Upon double clicking your connection, you get to fill in the Mycluster Properties file:

Above, you will see the connection string drop down for both your Oracle RAC Service and ASM instances. The minimum that you need is the Oracle Connection String. SoRAC connects to the instance and queries view gv$instance for all RAC instances and it queries the view gv$active_instances to display the active instances in the cluster.

The Oracle Username and Password is the same as that required for Spotlight on Oracle – SoRAC and SoO share the same Oracle user. You will be prompted to create a user or use an existing user. Follow the steps below to create a new user.

Step 1: Wizard opens up

Step 2: It connects to an instance to upgrade the user

Step 3: Create a new user

Step 4: We will call the new user spotrac.

Step 5: I pick tablespaces "Users" and "TEMP", you can however create your own tablespace as well.

Step 6: Creating user and configuring...

Step 7: Done.

All other fields are optional. If the cluster uses ASM, then you can fill the Monitor ASM section. ASM is managed via an Oracle instance, which must be entered here. It only supports the user "SYS" as we know. This section must be filled out to populate the ASM spinner, associated drilldown and ASM Service Time alarm.

Connecting/Verifying the Cluster

Step 1: Double clicking the connection we get our instances presented to us...

Step 2: Click test and then OK

Step 3: Calibration Settings


In the next and the final article of "Monitoring Oracle RAC with Spotlight on RAC" (SoRAC), we will discuss in detail how the Alarm (Oracle Aggregated Alarms, Cluster Balance Alarms, Cluster Latency and Overhead Alarms, Global Cache Alarms, ASM Alarms) and Drilldowns work. Here you have seen that the homepage or the monitoring pane of SoRAC is very intuitive. You as a busy DBA will spend a lot less time on complex problems, as a graphical overview will point you in the right direction.

» See All Articles by Columnist Tarry Singh

Oracle Archives

Latest Forum Threads
Oracle Forum
Topic By Replies Updated
Oracle Data Mining: Classification jan.hasller 0 July 5th, 07:19 AM
Find duplicates - Unique IDs Lava 5 July 2nd, 08:30 AM
no matching unique or primary key rcanter 1 April 25th, 12:32 PM
Update values of one table based on condition of values in other table using Trigger Gladiator 3 February 29th, 06:01 PM