Chat now with support
Chat with Support

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

Contents of the input CSV file for ASM instances

The input CSV file contains the following fields, which are used as columns in the resulting file.

RAC Agent Name

The name of the RAC agent. This name must be unique per agent.

Agent Name

The requested agent name. This name must be unique per agent. If an agent with the given name already exists, the newly provided agent will not be created.

Host

The host that is serving the ASM instance.

Port

The TNS listener port.

SID

The name of the SID used for establishing connection to the instance.

User name

The name of the user to be used for connecting to the ASM instance. Can be either ASMSNMP or SYS.

User Type

Connection privileges level to be used for monitoring the ASM instance. The possible values are either “SYSASM” or “SYSDBA”.

Password

The password of the database user name.

Enable OS Monitoring

Specifies whether to create an Infrastructure Cartridge agent for the given host name; the possible values are True or False.

OS Platform (Optional)

The type of the OS platform where the Oracle instance runs; the possible values are either UNIX or WINDOWS.

Authentication (Optional)

OS authentication type. This field can have one of the following values:

OS User Name (Optional)

The user name to be used for connecting to the OS and monitoring it.

OS Password (Optional)

The password of the OS user name specified above.

SSH Port (Optional)

The port that is used for listening to incoming SSH connections on the monitored hosts; if the monitored host is Windows-based, leave this field empty.

Private Key File Path (Optional)

The full path of the private key file; relevant only to the following credential types: RSA_KEY, DSA_KEY.

Passphrase (Optional)

The passphrase of the OS user that is used in public key authentication; relevant only to the following credential types: RSA_KEY, DSA_KEY.

Use sudo (Optional)

Used for indicating that the OS user specified above is not an administrator user, but can run certain commands that require administrative privileges as root.

The possible values are TRUE or FALSE. if the monitored host is Windows-based, leave this field empty to indicate FALSE.

 

Using Foglight for Oracle

Using Foglight for Oracle

Foglight for Oracle monitors the Oracle database activity by connecting to and querying the Oracle database. The agents provided monitor the Oracle database system. The dashboards included with the cartridge provide a visual representation of the status of the major components of the Oracle agents. They allow you to determine any potential bottleneck in database performance.

This section provides agent configuration instructions and information on investigating Oracle database performance. It covers the entire monitoring process, starting with the discovery of the database instances and the connection with these instances, and proceeding with the use of the various drilldowns and the Global Administration options.

Viewing the Databases Dashboard

The Instance home page is launched by accessing the Databases dashboard.

2

The Databases dashboard provides an at-a-glance view of the monitored environment, with all of the currently monitored database types.

The Databases dashboard includes these sections:

ASM — ASM-related data, which was previously retrieved through the Foglight for Oracle agent, is only enabled if the Foglight ASM instance is configured and running. For details about configuring and running this instance, see Adding ASM Instances . For details about the monitoring information displayed on the ASM tab, see Reviewing ASM Instances .
Status summary — a color-coded bar, which provides a visual representation of the summarized health condition of all instances listed in the Database Group table.
Database-specific health summary — when the database group All is selected, this section displays all of the currently monitored instances for each database type, divided by their health state (for example: four Oracle instances, three of which have the health state Warning and one is indicated with the health state Fatal). When a user-defined database group is selected, this section displays data only about the agents included within the selected group.
The Monitor button — Use this button to add instances to be monitored.
The Configure Alarms button — Takes you directly to the Administration > Alarms page. On the Alarms page you can configure alarm settings and specify alarm sensitivity levels. Sensitivity levels control which alarms are enabled by default.
The Settings button — Use this button to do one of the following:
Currently selected database group table — a list of all monitored databases within the database group that is currently selected in the Databases section. For details, see Using the Currently Selected Database Group Table .
The Show Quick View button — provides the ability to open a quick view of the instance at the bottom of the screen.
The Select dashboards () button — provides direct link to several drilldowns and panels, thereby saving the need to navigate to these locations through the Overview drilldown.

Assigning Instances to Users

The User Level Access screen allows you to assign specific instances to users. As a result, when users view their Database dashboard, they will only see the instances which have been assigned to them. This makes it easier to find the data which is relevant to them.

The User Level Access screen only displays users who are not Administrative users.

1
On the main Database dashboard, click Settings and select Users Level Access from the menu.
2
Click Users. The table will display user names of non-Administrative users only, log in information, and instance information.
5
Click Set and Close to save your choices and exit.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating