Spotlight on Oracle 10.6 - Getting Started Guide

Welcome to Spotlight Install Spotlight Start Spotlight Spotlight on Oracle Spotlight on Oracle Data Guard Spotlight on Oracle RAC Spotlight on Unix Spotlight on Windows Spotlight on MySQL Troubleshooting: Connection Problems

Welcome to Spotlight

Spotlight® on Oracle is a powerful diagnostic and resolution tool for Oracle databases. Its unique user interface provides you with an intuitive, visual representation of the activity on your database. Graphical flows illustrate the rate at which data is moving between database components. Observe actual database activity in real time.

The power of Spotlight on Oracle lies in its ability to provide visual and audible warnings if the performance metrics exceed acceptable thresholds. The components and data flows change color to show you the source of the problem. Spotlight on Oracle provides detailed information about a specific component allowing you to pinpoint the source of problems.

Spotlight on Oracle incorporates:

Notes:

  • Spotlight on Oracle RAC requires additional licensing. It enables the diagnosis of Oracle databases on multiple host machines under the Real Application Clusters (RAC) architecture and additionally may include monitoring of Exadata systems depending on the license purchased.
  • When delivered as part of the Toad® DBA Suite for Oracle, Spotlight incorporates SQL Optimizer for Oracle. SQL Optimizer offers a fully automated approach to maximizing SQL performance. It eliminates the manual, time-intensive process of ensuring that SQL code is performing as fast as possible.

 

Install Spotlight

Requirements

Section Requirement
User Privileges Ensure the Windows user installing Spotlight has Windows Administrator privileges.

Folder Permissions

During installation, Spotlight requires write access to the following:

  • The Spotlight installation folder (by default, Program Files\Quest Software\Spotlight)
  • ProgramData\Quest Software\Spotlight
  • Users\<current user>\AppData\Roaming\Quest Software\Spotlight

Notes: On a 64-bit operating system the Program Files directory is Program Files (x86).

Permissions to Windows registry keys and sub-keys

During installation, Spotlight requires write access to the following:

  • HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Quest Software\Products

  • HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Quest Software\Spotlight

  • HKEY_CLASSES_ROOT

Note: Wow6432Node is applicable only for 32-bit Spotlight run on 64-bit operating systems.

Steps To Install

To install Spotlight from CD:

  1. Close all open applications on your PC.

  2. Insert the Spotlight Installer CD into your CD-ROM drive.

    If the installation program does not start select Windows Start | Run

    • For Spotlight delivered as part of the Toad DBA Suite for Oracle, enter the command d:\TOAD DBA Suite for Oracle vvv.exe (where d: is the CD-ROM identifier and vvv is the Spotlight version).
    • For Spotlight delivered as a standalone installer, enter the command d:\SpotlightonOracle_vvv.exe (where d: is the CD-ROM identifier and vvv is the Spotlight version).
  3. Follow the instructions on the screen to complete the installation.

To install Spotlight from the downloaded installer:

  1. Close all open applications on your PC.
  2. Execute the downloaded installer.
  3. Follow the instructions on the screen to complete the installation.

Note: To cancel installation at any time, press Esc or click Cancel.

Multiple Concurrent Installations

There has been a major shift in the architecture from Spotlight on Oracle 9.5. You can install major and minor versions of Spotlight on Oracle side by side (or upgrade). Patch and progressive builds will upgrade.

Note: If Spotlight is delivered as part of the Toad DBA Suite and you require multiple Spotlight installations on your computer then contact Quest Software for more information.

MSI Installers for Spotlight on Oracle

MSI installers are available for Spotlight on Oracle. These installers can be run silently, and produce an installation that can be captured and re-used via automatic deployment techniques.

Contact Quest Software for more information.

Self Service Tools
Knowledge Base
Notifications & Alerts
Product Support
Software Downloads
Technical Documentation
User Forums
Video Tutorials
Contact Us
Licensing Assistance
Technical Support
View All
Related Documents