Chat now with support
Chat with Support

Foglight for Oracle (Cartridge) 5.9.5.10 - User Guide

Installing and Configuring Agents Using Foglight for Oracle
Viewing the Databases Dashboard Assigning Instances to Users Selecting an Instance to Monitor Foglight for Oracle Overview Dashboard Overview view Advisories view SQL Performance Investigator (SQL PI) Oracle Activity Drilldown Pluggable Databases Drilldown Storage Drilldown Reviewing Configuration Settings Reviewing the Alert Log Reviewing Monitored Data Guard Environments Reviewing ASM Instances Reviewing Exadata-related Information
Administering Foglight for Oracle Reporting Reference Glossary

Overview

Any upgrade of Foglight for Oracle to the latest version, which is not met by similar upgrade of the database cartridge components, is detected upon opening the Databases dashboard, when the upgrade wizard starts automatically.

Selecting the check box at the bottom left of the screen prevents this wizard from appearing when entering the Databases dashboard. Nevertheless, if several database cartridge components still require upgrade, the need to upgrade them is indicated in the dashboard. The indication is evident both in the caption Upgrade required, which is displayed in red to the right of the requested instance, and in the button Upgrade, which appears only if upgrade is required.

Running the Upgrade Wizard

1
Click Upgrade.
2
Click Foglight for Oracle.
A Welcome page displays What’s New in this release, including bug fixes. At the bottom of the New Features table, is a link to the Rule Modification Overview page, where you can review the list of rules that have been modified and are in the following states:
Updated — The rule was updated in this release. To review the updated rule, click View updated rule. If a rule targeted for update was modified by a user, the user’s modified rule is copied and disabled before the updated rule is installed. To review the modified rule, click View user-updated rule.
3
If SQL Performance Investigator is not configured, proceed to Step 5.
6
Click Upgrade the selected Foglight Agent Managers.
9
If the status row of one or more agents displays the status Insufficient privileges, complete the following steps:
d
Click Grant database privileges.

Migrating Agents

The SQL Performance Investigator extension is only supported on Windows 64-bit and Linux 64 (Red-Hat 6, SUSE 11 and CentOS 6). As a result, you may need to migrate Oracle agents from an Agent Manager running on Linux to a Windows Agent Manager.

In addition, the migration tool allows you to perform resource balancing between the agent managers running Oracle agents with and without the SQL PI extension installed.

1
Open the migration wizard by navigating to Dashboards > Databases> Support Dashboard.
6
Click Next to migrate the agents.
7
When migration has completed, click Finish to exit the Wizard.

About Monitoring Extensions

During the installation process you can choose to install and configure one or more of the monitoring extensions. The monitoring extensions provide a more in-depth analysis of the monitored instance and the environment it is running on, creating a whole and unified status.

SQL Performance Investigator allows you to rapidly identify bottlenecks, anomalies, and application trends by focusing on top resource consumers and providing multi-dimensional SQL domain drilldowns. SQL PI allows you to:

Monitoring the operating system allows you to identify resource consumption and provides a full view of the server health. An Infrastructure agent, which is created automatically as part of the monitoring process, monitors the operating system.

Monitoring the VMWare system allows you to identify resource consumption and provides a full view of the data center and ESX health when the server is part of a VMWare environment.

Related Documents