Chat now with support
Chat with Support

Foglight for Oracle (Cartridge) 5.9.3.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

Defining the Connection Settings for the Monitored Oracle Instances

The Connection Details view contains a table that displays all the agents that were selected before entering the Databases Administration dashboard.

To define the connection settings for the requested agents:
1
Select the check boxes to the left of the agents for which uniform credentials are to be set. To cancel the selection, click Select None and select again.
2
Click Set Credentials.
The Edit Instance Credentials dialog box opens.
3
Use the Connection Details section to enter the TNS listener port, or accept the default port (1521).
4
Use the Login Credentials section to type the user name and the password used for connecting to the Oracle instance.
5
Select whether to enable OS monitoring, in order to retrieve OS-related data, such as CPU utilization and memory consumption. For instructions about configuring OS monitoring, see Configuring OS monitoring credentials .
* 
IMPORTANT: When enabling OS monitoring, ensure that the selected OS user has the privileges required for monitoring the operating system. For details, see the Foglight for Oracle Release Notes.
6
Select whether to enable and set user-defined collections. For more information, see Enabling and setting credentials for user-defined collections.
7
If the selected agents reside on a VMware virtual host, click Edit VMWare connection details to define their connection details. For more information, see Defining the VMware Connection Profile.
8
Click Validate to proceed to the next stage of validating the instance’s connectivity.

Validating Connectivity and Starting to Monitor the Instances

After setting the default credentials for the host, these newly created credentials can now be used by the wizard to attempt to log in to the instances.

To validate the instances’ connectivity:
1
Click Test connection.
The Verifying Connectivity progress bar appears.
At the end of this process, any connectivity issues are listed in the Status column of the instance table. When the connection is successful, the Status column displays the status message Validated, which indicates that the instance connected successfully and the specified Oracle user has the required permissions.
If the connection failed verification, the Status column displays one of several connectivity status messages.
The messages, causes, and appropriate responses are:
•
No valid RAC nodes were detected (for a RAC) — modify the RAC nodes’ credentials.
•
Invalid username/password — check the credentials and try again.
•
Process Error — see the code error under the Details column.
•
Wrong Database Credentials — modify the login credentials.
•
Database Connection Failed — the database to which the instance tries to connect is not running or cannot be accessed. Ensure clearing the check box near the database’s name.
•
Insufficient Privileges — grant the user the privileges required for connecting to the database, by clicking the status Insufficient Privileges.
The Grant Database Privileges dialog box opens.
Use this dialog box to specify a SYSDBA (System Database Administrator) user with sufficient privileges.
Type a SYSDBA user and password, and then click Grant.
If the Sysdba credentials entered were incorrect, the column displays the status Wrong Sysdba credentials.
After correcting the mistakes that resulted in the connectivity failure, click again Validate connectivity.
2
Click Validate connectivity on the status bar.
3
Click Save Changes.
The Applying Modified Settings progress bar appears.
Configuring OS monitoring credentials
To configure the OS monitoring credentials:
1
Use the Host Credentials section to select whether to log in to the monitored host using the existing host connection details or to edit the host connection details.
2
If the option to edit the host connection details is selected, select whether to disable OS monitoring, which is enabled by default.
* 
IMPORTANT: When enabling OS monitoring, ensure that the selected OS user has the privileges required for monitoring the operating system. For details, see the Foglight for Oracle Release Notes.
3
Specify the requested authentication type:
•
Local user — using the same credentials that were used for running the monitoring software (Agent Manager) on the Oracle host.
•
Windows — the user name (in the domain\user name format) and password, used for logging in to a Windows-based monitored host.
•
SSH (DSA) — using the SSH private key, generated via the DSA algorithm.
•
SSH (RSA) — using the SSH private key, generated via the RSA algorithm.
•
SSH (login credentials) — the user name and password used for logging in to a UNIX-based monitored host.
4
If any option other than Agent Manager local user is selected, enter the required credentials.
* 
IMPORTANT: If either of the UNIX authentication types is selected, to run certain commands that require administrative privileges as root, without having to log in as administrator, select the Use sudo check box.
* 
IMPORTANT: It is possible to delete or edit existing credentials by clicking Select from stored credentials and entering the User Credentials dialog box. However, it is highly advisable not to make any changes to existing credentials, as such changes will affect all agents that currently use these credentials.
Enabling and setting credentials for user-defined collections

Use the user-defined collections feature to add customized collections to all of the currently selected agents, thereby providing for queries not included in Foglight for Oracle.

Use the Connection Details view to enable and configure the creation of user-defined collections.

To enable and configure the creation of user-defined collections:
1
Select the requested agents.
2
Click Set UDC credential.
The Edit Credentials for User-defined Collections dialog box opens.
3
Click Edit Credentials for User-defined Collections.
The Edit Credentials for User-defined Collections dialog box opens.
4
Select the check box Enable user-defined collections.
5
Select whether to perform the collection using the existing agent credentials or by creating dedicated credentials.
6
If the user-defined collections are to be enabled using dedicated credentials, type the requested user name and password.
7
Select whether to connect as SYSDBA.
8
Click Set.

To add user-defined collections, go to the User-defined Collections view in the Databases Administration dashboard. For details, see Configuring User-defined Collections .

Defining the VMware Connection Profile

If you have Oracle instances that run on virtual hosts, monitoring such instances requires setting a dedicated connection profile, in order to connect to the requested VMware server.

* 
NOTE: The VMware connection profile can be defined only if OS monitoring is enabled.

Establishing such a connection is necessary in order to retrieve the Virtualization overhead data, that is, the percentage of CPU that is unavailable to this virtual machine because it is being utilized either by other virtual machines or by VMware itself. The Virtualization Overhead indicator is displayed in both the real-time and history summary pages.

To edit the VMWare Connection Profile:
1
Select the requested agents.
2
Click Set credentials.
3
In the Edit Credentials dialog box, click Edit VMWare connection details.
The Edit VMWare Credentials dialog box opens.
4
Select the check box Enable monitoring the VMWare CPU layer.
5
Enter the details required for monitoring the CPU distribution data, that is: vCenter or ESX host name, port, VMware user, and VMware password.
6
Click OK.

Defining the Connection Settings for the Monitored ASM Instances

The Connection Details view contains a table, which displays all of the agents that were selected before entering the Databases Administration dashboard.

To define the connection settings for the requested ASM agents:
1
Go to the ASM tab.
2
Select the check boxes to the left of the requested ASM agents.
3
Click Settings.
4
Click Administration.
5
In the Connection Details view, select the check boxes to the left of the ASM agents for which uniform credentials are to be set. To cancel the selection, click Select None and select again
6
Click Set Credentials.
The dialog box Edit credentials of ASM instance opens.This dialog box is identical to the one used for configuring ASM instances for monitoring.

Defining Data Collection and Storage Options

The Foglight for Oracle agent collects and stores data at all times, even when the browser window that displays the data is not active. Use the Collections view in the Databases Administration dashboard to specify:

•
Which collections are sampled and stored.
•
The data collection values when sampling is carried out in offline, online, and real-time frequency modes.
•
The collection frequency.
When a user is currently focusing on a screen, the sampling frequency for all of the collections associated with this screen automatically switches to Real-Time. The collection frequency setting determines the sampling frequencies of the other collections, which do not run in Real-Time mode).
The available collection frequencies, which can be selected from the field The selected agent's current collection frequency is, are:
•
Low — all collections are running in Offline mode, regardless of whether a Client is connected
•
Normal — the collections' running mode (Online/Offline/Real-time) adjusts dynamically to the Client's connection status (disconnected/connected/focusing on a screen).
•
High — all collections are running in Online mode, regardless of whether a Client is connected.
•
The Query timeout for on-demand collections.
This setting defines the number of seconds that a query for on-demand collections can run before it times out.
On-demand collections are collections whose data is retrieved not by predefined time intervals but upon entering a screen or clicking a button.
The default setting of this parameter is 60 seconds, but it can be modified by clicking the number that indicates the parameter’s value in the field Query timeout for on-demand collections:.

The Collections table contains the following columns.

Table 29. Collections
Column
Description
Collection Enabled

Defines whether the selected collections are sampled and stored.

Collection Name

The name of the collection. This list is sorted in alphabetical order.

Offline Frequency (Sec)

Used for defining the collection interval, in seconds, in offline mode (for example: 300).

Offline frequency refers to the longest interval possible for sampling the monitored instance.

Online Frequency (Sec)

Used for defining the collection interval, in seconds, in online mode (for example: 60).

Real-time Frequency (Sec)

Used for defining the collection interval, in seconds, in real-time mode (for example: 20).

Only one collection can be sampled at real-time frequency at any given moment.

Query Timeout (Sec)

The amount of time, in seconds, that elapses before the query times out.

* 
IMPORTANT: In the Normal collection frequency, when the browser window that displays Foglight for Oracle is active, the collection frequency mode in the active screen (for example: the Current Sessions panel in the Activity drilldown) switches to the fastest frequency possible - once every 20 seconds.
To modify the values of a specific collection:
1
Select the collection’s row in the table.
2
Click Edit.
The Edit the Collection dialog box opens.
3
Select whether to enable the collection and storage of the selected collection.
4
Set the collection interval, in seconds, in offline frequency mode (if available).
5
Set the collection interval, in seconds, in online frequency mode (if available).
6
Set the collection interval, in seconds, in real-time frequency mode.
7
Set the query timeout, in seconds.
8
Click Set to apply these settings or Cancel to reject them.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating