Chat now with support
Chat with Support

Spotlight on Oracle 10.5 - Release Notes

System Requirements

Before installing Spotlight, ensure your system meets the following minimum hardware and software requirements:

Client Requirements

Requirement Description
Platform

A Pentium-based or equivalent PC with:

  • A 1.2 GHz Processor (recommended minimum). The required processing power will increase when Spotlight diagnoses Oracle RAC clusters with many instances.
  • 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].)
Memory

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.

Hard Disk Space 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.
Operating System

Microsoft Windows Server 2012 64-bit

Microsoft Windows Server 2008 64-bit

Microsoft Windows 10 32-bit and 64-bit

Microsoft Windows 8 32-bit and 64-bit

Microsoft Windows 7 32-bit and 64-bit

Microsoft Windows Vista Business 32-bit and 64-bit (Service Pack 1 or later)

Additional Software (Monitor Oracle Database Servers)

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

    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.

Additional Software (Monitor MySQL Database Servers) MySQL. Spotlight on MySQL supports MySQL versions 5.0.3 or later that employ the InnoDB storage engine. With reduced functionality, it also supports versions of MySQL that use other storage engines (such as MyISAM). Spotlight on MySQL may NOT support versions of the MySQL server prior to 5.0.3.

Spotlight Diagnostic Server Requirements

Requirement Description
Platform

2 GHz Pentium Dual Core

Memory 2 GB RAM
Hard Disk Space 300 MB
Operating System

Microsoft Windows 7 (32-bit and 64-bit)

Microsoft Windows 8 (32-bit and 64-bit)

Microsoft Windows 10 (32-bit and 64-bit)

Microsoft Windows Server 2008 (32-bit and 64-bit)

Microsoft Windows Server 2008 R2 (64-bit)

Microsoft Windows Server 2012 (64-bit)

Additional .NET 4.0 or above must be installed on the Diagnostic Server.

Internet Access

A network connection between the Diagnostic Server and Spotlight on Oracle client is required during installation of the Diagnostic Server and intermittently for connection updates.

Preferably the Diagnostic Server should be installed on a Physical Machine however it can be installed on a Virtual Machine if required.

Connections to a database using an LDAP server are not supported through the Spotlight Diagnostic Server.

Monitored Database Servers - Requirements

Requirement Description
Oracle

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

  • Oracle 10g (Release 1 or Release 2)
  • Oracle 11g (Release 1 or Release 2)
  • Oracle 12c

Notes:

  • 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.0.3 and later.

Monitored Operating Systems (UNIX) - Requirements

Requirement Description
Unix Servers

Unix servers and versions. Spotlight supports the following server operating systems for O/S Server queries:

  • Oracle Solaris 9, 10, 11
  • HP-UX 11i, 11i v2, 11i v3
  • IBM AIX 5.2, 5.3, 6.1, 7.1
  • Red Hat operating system based on Linux 2.4, 2.6 and 3.10 kernels
  • SUSE operating system based on Linux 2.4, 2.6 and 3.0 kernels

  • Oracle Enterprise Linux (OEL) based on Linux 2.4, 2.6 and 3.8 kernels

Unix Server Software

Unix programs. The following Unix programs must be accessible to the user logged on to the Unix machine.

  • Perl 5.x
  • awk
  • cat
  • date
  • df
  • grep
  • ifconfig
  • iostat (not HP-UX)
  • netstat
  • ps
  • sar
  • 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
Unix User Permissions and Installation Settings
  • The Unix user should have no special processing on log-on. In particular there must be no input required from the user, and nor should any special login banners be displayed.
  • On AIX, the user must be a member of the "adm" group to be able to run the sar command.
  • On Linux, the sysstat package must be installed to enable the user to get detailed disk I/O information.
  • On Linux the /proc filesystem must be present.
  • For connection using SSH, the sshd daemon must be installed and running.
  • The Unix user must have read/write access to /tmp

Monitored Operating Systems (Windows) - Requirements

Requirement Description
Operating Systems

Microsoft Windows Server 2012 64-bit

Microsoft Windows Server 2008 64-bit

Microsoft Windows 10 32-bit and 64-bit

Microsoft Windows 8 32-bit and 64-bit

Microsoft Windows 7 32-bit and 64-bit

Microsoft Windows Vista Business 32-bit and 64-bit (Service Pack 1 or later)

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.

Virtualization Support

Review the following information about using Spotlight in virtual environments:

Requirement Description
Application

Spotlight has been tested on Citrix XenApp 6.5.

Desktop (VDI)

Spotlight has been tested on desktop VMware workstations.

Server

Spotlight has been tested on VMware ESX server.

Spotlight supports Oracle Virtualization (OVM). Limited testing has been done using Oracle VM 3.0.

Note:Spotlight may work in virtualization environments other than the ones in which it was tested.

Upgrade and Compatibility

From time to time, Quest Software may make upgrades and patches available on the Internet. Upgrades will be made available from http://software.quest.com/. Instructions for downloading and installing upgrades are provided on the web site.

Notes:

  • When upgrading to Spotlight on Oracle 10.3.2 history data will be reset. If you would like to keep history between upgrades then you can change the folder spotlight stores history to, through Spotlight Options | storage->History Location.
  • VBScript is used to detect pre-existing Spotlight installations. If for security reasons your client system is unable to execute VBScript, you can provide the UPGRADE_EXISTING_PRODUCT=0 property during install to bypass checking for installed Spotlights. For example:

msiexec.exe /i Spotlight.msi UPGRADE_EXISTING_PRODUCT=0

 

Back to Top

Product Licensing

Spotlight is supplied with a time-limited trial key so you may test the product. When the trial key expires Spotlight reverts to a preview mode, which limits access to the Spotlight home page and one connection at a time. If you select to open a drilldown in preview mode the following message is displayed:

The current license does not allow access to this functionality.

When you enter a valid license key and authorization message in the License Viewer, you are licensed to use 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.

Getting Started

Contents of the Release Package

The Spotlight on Oracle release package contains the following products:

  1. Spotlight on Oracle 10.5
  2. Product Documentation, including:
    • Spotlight on Oracle Getting Started Guide
    • Online Help

Installation Instructions

Refer to the Spotlight on Oracle Getting Started Guide for installation instructions.

Note: When upgrading to Spotlight on Oracle 10.3.2 history data will be reset. If you would like to keep history between upgrades then you can change the folder spotlight stores history to, through Spotlight Options | storage->History Location.

Globalization

This section contains information about installing and operating this product in non-English configurations, such as those needed by customers outside of North America. This section does not replace the materials about supported platforms and configurations found elsewhere in the product documentation.

This release is Unicode-enabled and supports any character set. In this release, all product components should be configured to use the same or compatible character encodings and should be installed to use the same locale and regional options. This release is targeted to support operations in the following regions: North America, Western Europe and Latin America, Central and Eastern Europe, Far-East Asia, Japan.

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating