Installing and Setting up
Installation is rather simple.
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
Conclusion:
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
» 
Comment and Contribute
