Spotlight on Oracle 10.5

New Features Resolved Issues and Enhancements Known Issues System Requirements Product Licensing Getting Started Globalization About us Copyright

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 *SQLNet 2.3.4 or later.** SQLNet enables a connection to be established to a database. The database may be local or remote. Before you start Spotlight you must have the SQLNet 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

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

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

Click Help | About Spotlight.
Click license information.
Click Change this license.
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:

Spotlight on Oracle 10.5
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.

Documentos relacionados

The document was helpful.

Seleccionar calificación

I easily found the information I needed.