Chat now with support
Chat with Support

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

Configuring the On Demand Port on the Agent Manager Concentrator

If a firewall is installed between the Management Server and the Agent Manager, the bidirectional RMI connection shown in the figure above will not be possible because RMI requests require direct connection.

This issue can be resolved by creating an RMI proxy server on the concentrator — an Agent Manager instance that works similarly to an HTTP proxy. This RMI proxy server can be configured to accept RMI requests from the Management Server and direct them to the Agent Manager instances (called downstream instances). For additional details about the concentrator, see Configuring an Agent Manager Instance as a Concentrator in the Agent Manager Installation Guide.

A concentrator agent, created specifically for Foglight for Oracle, allows controlling the RMI server so that the server is initialized (starts collecting data) when the agent starts, and stops when data retrieval by the agent is brought to an end. The agent, which is created manually by the user, requires configuring the following parameters:

Each time the Foglight Management Server sends an RMI request, the list of downstream hosts submitted by the concentrator agent is being searched.

Go to Dashboards > Administration > Agents > Agent Status.
Click Create Agent.
Select the agent type DB_Oracle_Concentrator.
Click Create.
Click Edit Properties.
Click Modify properties for this agent only.
Click Edit to edit the list of downstream Agent Managers.
Click Add Row.
IMPORTANT: When editing the properties of the Foglight Agent Manager concentrator (Dashboards > Administration > Agents > Agent Status), the name of the Foglight Agent Manager should be entered in the Downstream FglAMs section exactly as it appears in the topology, under Home > Agents > All agents > <Agent name> > RMI data > Fglam host property. The <Agent name> parameter refers to any of the Foglight for Oracle agents that reside on the selected Foglight Agent Manager.
Repeat Step 7 to Step 8 as many times as required.
Click Save Changes.
Click Save at the lower right corner of the screen.
Click Back to Agent Status.
Click Activate.
Click OK to complete the process.

Installing and Monitoring a Single Oracle Instance

Enabling the Foglight Management Server to monitor Oracle instances requires the creation of the Foglight agents that monitor these instances and ensuring that these agents communicate properly with the Foglight Management Server.

Foglight for Oracle provides a graphic, intuitive method for creating and configuring multiple agents, which can be used instead of Foglight’s default method for creating agents and editing their properties using the Agent Administration dashboard. Foglight for Oracle allows you to run a wizard that provides a common entry point for adding and discovering all database instances within a user-specified range, and then configuring these instances for monitoring.

IMPORTANT: When running Foglight for Oracle in a Federation architecture, neither the creation nor the administration of agents can be accomplished from the central Foglight Management Server (the Federation Master). These two tasks should be carried out from the stand-alone Management Servers (the Federated Children).
Click the Agent Manager Host <agent manager> link located at the top of the Oracle Connection section.
TNS — used for selecting a database from the tnsnames.ora file by clicking Load file.
Host — Manually enter Host, port and either service name or SID.
Essential — Store and display only critical or fatal alarms.
Normal — Store and display most alarms — essential and best practices; only critical and fatal statistical alarms.
Tuning — Store and display all Oracle alarms sent to Foglight.
Optional — In the Monitoring Extensions pane, click the SQL PI monitoring extension. You are prompted to choose the Agent Manager on which the SQL PI repository will be installed.
Optional —In the Monitoring Extensions pane, click the Operating System link.
Local user — using the same credentials that were used to launch the Agent Manager.
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.
Navigate to the Foglight Management Server credentials view (Dashboards > Administration > Cartridges > Credentials > Manage Credentials).
Add credential of type DSA key and link this credential to the agents created in Step a. For details, see “Adding and deleting credentials” in the Foglight Administration and Configuration Guide.
Go to Agent Status screen (Administration > Agents > Agent Status)
Click Edit Properties.
Select Modify the private properties for this agent.
Optional — In the Monitoring Extensions pane, click Collect VM statistics.

Discovering Multiple Instances to Monitor

Click the Use this option to discover multiple Oracle instances link.
Click Set credentials on the toolbar to provide the login credentials of the instances
Follow the steps described in Installing and Monitoring a Single Oracle Instance , beginning with Step 5 to enter the monitoring credentials and enable the monitoring extensions for this instance.
NOTE: To use stored credentials when enabling the Operating System monitoring extension, click the Operating System > Select from stored credentials link to open the Stored Credentials dialog box. Here you can review the login credentials and authentication methods used for logging in to Foglight.
Foglight stores encrypted credentials in lockboxes, which may be password-protected for added security. Database agents store all user login credentials in a default lockbox called DB-Agent Lockbox. If credentials have already been entered in another lockbox, use the Lockbox list to select from that lockbox.
Click Validate.
Select the check boxes near the multi-node RACs and click OK. After the validation process completes, all instances that passed the validation process successfully are displayed in the table with the status Validated.
If the message is Insufficient database privileges, this issue can be resolved using the Insufficient Database Privileges dialog box that appears. For details, go to Step 12.
Click Insufficient Database Privileges.
Enter a SYSDBA user and password, and then click Grant Privileges. Alternatively, click the View script link, to the right of the Grant privileges button, to grant privileges manually by means of a script.
Click Show details to view the error's description.
Click Set credentials to display the dialog box used for entering the credentials, and enter the required changes.

Loading a TNS file

Click Load TNS file.
Click Choose file and browse for the requested file.
Click Open.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating