Get Adobe Flash player

postheadericon Spotlight for Oracle System Requirements

Spotlight for Oracle

System Requirements

Client Requirements



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

•  A CD-ROM drive or Internet connection. Spotlight can be downloaded from the Internet or installed from compact disc. The CD-ROM drive should be attached to the PC on which Spotlight is to be installed.

•  A drive mapped to a network device could be used if a local CD-ROM is not available. A printer (optional). Spotlight reports can be printed on a laser or bubble jet printer. You can print graphs in color if your printer provides this capability.

•  A sound card and speakers (optional). Spotlight can use sound to alert you when a threshold is reached. You must have a sound card and speakers installed on your PC for this feature to work.


512 megabytes of RAM (minimum). 512 megabytes is a minimum RAM requirement (assuming no other applications are running), but 1 gigabyte of RAM is recommended. Memory consumption will increase as the number of instances in an Oracle RAC cluster increases, and will also depend on the connection options chosen.

Hard Disk Space

150 megabytes 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 2008 64

•  Microsoft Windows Server 2003 32-bit and 64-bit

•  Microsoft Windows XP Professional 32-bit and 64-bit (Service Pack 1 or later)

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

•  Microsoft Windows 7 32-bit and 64-bit

Note: Spotlight will run on 64-bit versions of the client operating system with the use of a 32-bit Oracle client.

Additional Software

•  MicNET 3.5 service pack 1.

•  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 9.2, Oracle 10g [full client or instant client], or Oracle 11g ). 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.


Server Requirements


Database Server

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 9.2.0 .4 or later

•  Oracle 10g (Release 1 or Release 2)

•  Oracle 11g (Release 1 or Release 2)

Cloud Database Services

Oracle databases running on Amazon EC2.

Operating System Server

The following server operating systems are supported for Operating System Server queries

•  Sun Solaris 8, 9, 10.

•  HP-UX 11i, 11i v2, 11i v3.

•  IBM AIX 5.2, 5.3, 6.1.

•  Red Hat and SUSE operating systems running Linux 2.4 and 2.6 kernels.

•  Windows XP (Service Pack 2 or Service Pack 3), Windows 2003 Server, or Windows 2008 Server.

Oracle RAC Servers

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


Virtualization Support


Review the following information about using Spotlight on Oracle in virtual environments:


Spotlight has been tested for Citrix support on Windows Server 2003 Enterprise Server (Service Pack 2) using the MetaFrame Presentation Server 5.0 and Citrix Presentation Server Clients 10.2.

Desktop (VDI)

Spotlight has been tested on VMware ESX servers and desktop VMware workstations.


Spotlight has been tested on VMware ESX servers.

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