System requirements

System requirements

Before installing Foglight for Oracle, ensure your system meets the following minimum hardware and software requirements:

• Hardware and software requirements
• UNIX server and programs
• UNIX user permissions and installation settings
• Required privileges
• Supported platforms

Hardware and software requirements

Before installing Foglight for Oracle, ensure that your system meets the hardware and software requirements detailed in Foglight System Requirements and Platform Support Guide.

Customers running large deployments (that is, with more than 50 Oracle instances) should consult the Foglight for Databases Deployment Guide.

UNIX server and programs

The following UNIX programs must be accessible to the user logged on to the UNIX and Linux computers:

• On all platforms: df, du, awk, iostat, vmstat, uptime, netstat, sed, ps, uname, ls -l

In addition, the following platform-specific programs must be available:

• On the Linux platform: /proc/vmstat, /proc/net/dev, free, /proc/cpuinfo, getconf
• On the Solaris platform: /usr/sbin/prtconf, mpstat, pagesize, psrinfo
• On the AIX platform: lsattr, lsdev, pagesize, bindprocessor, lsdev, oslevel
• On the HP-UX specific platform: bdf (instead of df), sar, /var/adm/syslog/syslog.log, /usr/sbin/ioscan, getconf, /swapinfo, InfoLog (needs to be enabled)

Programs that should be configured to be run using sudo

The sudo utility allows system administrators to grant specific users (or groups of users) the ability to run certain commands that require administrative privileges as root, without having to log in as administrator.

The programs that can be run using sudo in the various Linux and UNIX operating systems are as follows:

• On all platforms, when monitoring the Clusterware using the CRS agent:
  • For running the Clusterware monitoring wizard: test, uname, ps, awk, {CRS_HOME}/bin/olsnodes
  • For monitoring the Clusterware: {CRS_HOME}/bin/crs_stat (for versions 10gR1, 10gR2, 11gR1), ${CRS_HOME}/bin/crsctl(for versions 11gR2 and above), tail
• On all platforms: df, du, awk, iostat, vmstat, uptime, netstat, sed, ps, uname, grep, ls -l

In addition, the following platform-specific programs must be available:

• On the Linux platform: /proc/vmstat, /proc/net/dev, free, /proc/cpuinfo, getconf
• On the Solaris platform: /usr/sbin/prtconf, mpstat, pagesize, psrinfo
• On the AIX platform: lsattr, lsdev, pagesize, lsdev, bindprocessor, oslevel
• On the HP-UX specific platform: bdf (instead of df), sar, /var/adm/syslog/syslog.log, /usr/sbin/ioscan, getconf, /swapinfo, InfoLog (needs to be enabled)

UNIX user permissions and installation settings

• On AIX, the user must be a member of the administrator 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.
• For connection using telnet, a telnet daemon must be installed and running.
• 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.

Required privileges

For information on the required privileges, refer to the Foglight for Databases Deployment Guide.

Direct NFS client

This version of Foglight for Oracle support usage of direct NFS client.

Monitoring an Instance that Is Part of a Data Guard Environment

To monitor a data guard environment with a physical standby (Redo Apply):

1. Make sure that the Standby Database is in receiving mode.
2. Use SQLPLUS to connect to the Primary Database as SYS user.
3. Create the standby Foglight schema owner.
4. From the Primary Database, run the grant privileges script on the standby user created in Step 3. to stay in that mode after the check.
5. Open a web browser and run the Oracle Monitoring Installer wizard.
6. Select "Add a New Instance".
7. Specify the Standby Database credentials and connection details (the user that was created in Step 3).
8. Click Verify Connectivity.
9. If the Standby Database is mounted, click on validate standby button.
10. After the verify process is complete, the next step is to monitor the physical Standby Database.

To monitor a data guard environment with logical standby (SQL Apply):

1. Use SQLPLUS to connect to the logical standby as SYS user.
2. Create the standby Foglight schema owner.
3. Open a web browser and run the Oracle Monitoring Installer wizard.
4. Continue the discovery process as usual, using the logical standby user credentials and connection details.
5. Click Verify Connectivity.
6. Once the connectivity verification is completed, the next step is to monitor the logical standby database.

Supported platforms

Foglight for Oracle supports monitoring the following platforms:

• Supported Oracle® Database Versions:
  • 10g
  • 11g
  • 12c
• Supported Oracle Editions (all):
  • Enterprise Edition
  • Standard Edition
  • Standard Edition One
  • Standard Edition 2
  • Express Edition
  • Personal Edition
• Supported Operating Systems:
  • All Operating systems supported by Oracle.

Note 1: Foglight for Oracle supports monitoring the Amazon Relational Database Service (Amazon RDS™).

Note 2: SQL PI extension supports Oracle versions 11gR1 and later.

Linux on System Z (z/Linux) support

Foglight for Oracle fully supports monitoring of instances that are installed on a z/Linux operating system. The supported monitored instances versions are the same as specified in the list above for the Linux platform.

Back to Top

Troubleshooting

Troubleshooting

This section provides a list of references which address the most commonly faced issues relating to remote connectivity, allowing for easy troubleshooting using the vendor's information knowledgebase:

• To verify TCP/IP connectivity for SQL statement collections, Management Studio (SSMS) cannot be used as other protocols may be leveraged. Instead, verify connectivity using a UDL as detailed here: http://support.microsoft.com/kb/308075/
• To verify the WMI connectivity using a Microsoft Windows built-in utility, see http://technet.microsoft.com/en-us/library/cc180684.aspx
• To troubleshoot WMI access permissions, see http://blogs.technet.com/b/askperf/archive/2007/08/14/wmi-troubleshooting-permissions.aspx
• For information about WMI connectivity from Windows Server 2003/Vista and later versions, see http://msdn.microsoft.com/en-us/library/aa822854(VS.85).aspx
• For WMI troubleshooting tips and techniques, see http://msdn.microsoft.com/en-us/library/aa394603(VS.85).aspx

Back to Top

Product licensing

Product licensing

Foglight includes a licensing capability that restricts access to those features that are defined in the license. Any Management Server installation requires a license that grants access to server-specific parts of the browser interface and the features associated with them. Foglight cartridges are also license-protected. While some cartridges are covered by the base Foglight license (such as Foglight Agent Manager cartridges and the Foglight for Infrastructure), others may require an additional license.

Foglight for Oracle is covered by the base Foglight license that allows cartridges to be installed. The SQL Performance Investigator extension requires a dedicated license.

To activate a trial or a purchased commercial license:

1. On the navigation panel, under Dashboards, click Administration > Setup > Manage Licenses.
2. Click Install.
3. In the Install License dialog box, click Browse.
4. In the file browser that appears, specify the location of the license file.
5. In the Install License dialog box, click Install License.

Back to Top

Getting started with Foglight for Oracle

Getting started with Foglight for Oracle

Contents of the release package

The Foglight for Oracle 5.7.5.50 release package contains the following:

1. Foglight for Oracle cartridge: 
   • DB_Oracle-5_7_5_50.car
2. Product documentation, including:
   • Foglight for Oracle User and Reference Guide (PDF and online help)
   • Foglight for Databases Deployment Guide (PDF)
     Note: This guide replaces the following documents, provided in previous versions of this product: Foglight for Oracle Getting Started Guide, Foglight for Oracle Permissions Guide, and Foglight for Oracle Hardware Sizing Guide.
   • Foglight for Oracle Release Notes (this document)

Installation instructions

For installation pre-requisites, permissions, information necessary to determine your environment’s hardware requirements, and for installation instructions, see the Foglight for Databases Deployment Guide.

Additional resources

Additional information is available from the following:

• Online product documentation (http://documents.quest.com/ProductsAZ.aspx#F)
• Foglight Community https://www.quest.com/community/products/foglight/

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.

This release has the following known capabilities or limitations: The server will be enabled for Global Operation, but not localized to any particular locale.

Back to Top