Quest-Spotlight for Oracle

Owned by Phatchakorn Sirabenjaphakorn
Last updated: May 22, 2020
6 min read

1. System Requirements

1.1 Client Requirements

  • Operating Systems
    - Windows 7 (32-bit and 64-bit)
    - Windows 8 (32-bit and 64-bit)
    - Windows 10 (32-bit and 64-bit)
    - Windows Server 2008 , 2008R2 (64-bit)
    - Windows Server 2012, 2012R2 (64-bit)
    - Windows Server 2016 (64-bit)
    - Windows Server 2019 (64-bit) and above

  • Hardware Require (Minimum)
    - A Pentium-based or equivalent PC with :
    a) A 1.2 GHz Processor (recommended minimum). The required processing power will increase when
    Spotlight diagnoses Oracle RAC clusters with many instances.
    b) A monitor capable of supporting a resolution of 1280x1024 or larger. (You should also set the
    display to use the 64K color palette [65536 colors].)
    - 1 gigabyte of free disk space.
    This should exist on a local disk drive rather than a network drive. Extra disk space will be required if
    you choose to log historical snapshots from within Spotlight.
    - 512 megabytes of RAM (minimum) 1 gigabyte recommended.
    Memory consumption will increase for multiple simultaneous connections and as the number of
    instances in an Oracle RAC cluster increases, and will also depend on the connection options chosen.

  • Microsoft .NET 4.0 or above

  • SQL*Net 2.3.4 or later. SQL*Net enables a connection to be established to a database. The database may be local or remote. Before you start Spotlight you must have the SQL*Net connection string for the database.

  • Oracle Client
    - Oracle 10g [full client or instant client]
    - Oracle 11g [full client or instant client]
    - Oracle 12c [full client or instant client]
    - Oracle 18c [full client or instant client]
    - Oracle 19c [full client or instant client]

Spotlight also requires that the version of the Oracle client be the same or later than the version of any Oracle database being diagnosed. For example, to connect to an Oracle 10g cluster, you must use an Oracle 10g client or later

1.2 Monitored Database Servers Requirement

The following Oracle database servers are supported for database queries.
(You must have the Database Administrator [DBA] user ID and password for the database you want to diagnose.)

  • Database Client : An Oracle client must be installed and configured on the system where you are running Toad. The following are supported :
    - Oracle 10g ( Release 2)
    - Oracle 11g (Release 1 or Release 2)
    - Oracle 12c
    - Oracle 18c
    - Oracle 19c

  • When monitoring Oracle 11g Release 2 and above, to use the Spotlight User Wizard to install objects in your schema you require DBA privileges. To use the Spotlight User Wizard to setup another user to use this connection you require SYSDBA privileges.

  • When monitoring Oracle 11g Release 1 (and earlier) the Spotlight User Wizard installs several read-only views into the SYS schema of the target database when you use the wizard to create or modify a Spotlight user. Because of this, the DBA account that you use within the Spotlight User Wizard should have SYSDBA privileges. If the account does not have these privileges, you will be asked to provide a valid SYS account and password.

  • Oracle RAC
    Spotlight supports up to 16 instances in a cluster, with a theoretical limit of 36 instances.

  • Oracle Exadata Storage Servers (Cells)
    Spotlight monitors Exadata Storage Server (Cells) hosted on the following Operating System: Linux Kernel V2.6.
    Ensure CellCLI is in the PATH of the Operating System account on the Exadata Storage Server (Cell) hosts. This is required for Spotlight to collect performance information.

  • Cloud Database Services
    - Oracle Database as a Service.
    - Oracle databases running on Amazon EC2.

  • MySQL
    The following MySQL database servers are supported for database queries. (You must have the Database Administrator [DBA] user ID and password for the database you want to diagnose.
    - Version 5.x.

1.3 Monitored Operating Systems (UNIX) - Requirements

  • Unix Servers
    - Oracle Solaris 9, 10, 11
    - HP-UX 11i, 11i v2, 11i v3
    - IBM AIX 5.2, 5.3, 6.1, 7.1, 7.2
    - Red Hat operating system based on Linux 2.4, 2.6, 3.10 and 4.x kernels
    - SUSE operating system based on Linux 2.4, 2.6, 3.0, 4.x and 5.5 kernels
    - Oracle Enterprise Linux (OEL) based on Linux 2.4, 2.6, 3.8 and 4.x kernels

  • Unix Server Software
    - Perl 5.x
    - awk
    - cat
    - date
    - df
    - grep
    - ifconfig
    - iostat (not HP-UX)
    - netstat
    - ps
    - sar
    - ss (5.x kernels)
    - sed
    - tr
    - uname
    - uptime
    - vmstat
    - wc
    - who
    - For HP-UX, additionally
    - bdf
    - cstm
    - getconf
    - swapinfo
    - /usr/sbin/ioscan
    - For AIX, additionally
    - lsattr
    - lsdev
    - lsps
    - prtconf
    - For Solaris, additionally
    - /etc/swap
    - mpstat
    - nawk
    - prtconf

1.4 Monitored Operating Systems (Windows) - Requirements

  • Operating Systems
    - Windows Server 2008 , 2008R2 (64-bit)
    - Windows Server 2012, 2012R2 (64-bit)
    - Windows Server 2016 (64-bit)
    - Windows Server 2019 (64-bit) and above
    - Windows 7 (32-bit and 64-bit)
    - Windows 8 (32-bit and 64-bit)
    - Windows 10 (32-bit and 64-bit)

  • Administrator access
    Ensure your login to the Windows machine has Administrator access privileges.

    To add a new connection to the Windows machine you are currently using, ensure you are logged in to the machine with Administrator access privileges. If necessary, logout and login again.

  • Privileges
    Spotlight retrieves its data from Windows performance counters and the windows registry of the monitored system. An administrator login to the Windows machine has such access.

  • Remote connectivity
    To add a new connection to a Windows machine other than the one you are currently using, ensure the machine is accessible to the Spotlight client. Spotlight uses NetBIOS traffic to retrieve perfmon and registry information, so any firewalls between the Spotlight client and the machine being monitored must allow this traffic to pass through.

  • 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\Spotligh

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

2. Installation

Install Spotlight for ORACLE and Add License Key

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.

  • 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.

  • 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.

3. Licensing