Page Comparison

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]

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

• 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

• 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

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.1. Activate License Key- Spotlight on Oracle

To activate a purchased commercial license

1. Click Help | About Spotlight.

2. Click license information.

3. Click Change this license.

4. Enter the Authorization key.

Make sure you enter the authorization key exactly. The site message is case sensitive.

The Windows user that updates the authorization key must have administrator access to the Windows registry and write access to the Console\Licenses folder in the Spotlight installation folder.

3.2 Contents of the Release Package

The Spotlight on Oracle release package contains the following products:

1. Spotlight on Oracle 10.9.0

2. Product Documentation, including:

   • Spotlight on Oracle Getting Started Guide

   • Online Help

3.3 Uninstall Spotlight

To remove the application and all associated files from your machine, if required.

• Uninstall the Spotlight Diagnostic Server
  If the Spotlight Diagnostic Server is installed on the same computer as the Spotlight client and the Spotlight client is still installed then click View | Options | Configure Diagnostic Server.
  Alternatively, access the computer where the Diagnostic Server is installed:
  1. Open Windows Control Panel.
  2. Select Programs and Features.
  3. Click Spotlight Diagnostic Server for Oracle | Remove | Yes.

• Uninstall the Spotlight client
  1. Open Windows Control Panel.
  2. Select Programs and Features.
  3. Click Spotlight | Remove | Yes.