Chat now with support
Chat with Support

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

Tablespace Filtering

Tablespace Filtering

Use the Tablespace Filtering pane to configure the default monitoring settings for the Tablespaces Storage collection, by excluding from monitoring one or more of the following types of tablespaces:

•
Undo tablespaces
•
Temporary tablespaces
•
Read-only tablespaces
•
System-Sysaux tablespaces

This pane also includes the Tablespace Exclude List section. Use this section to add one ore more tablespaces to the Exclude list.

To add tablespaces to the Exclude list:
1
Click Add.
The Add a Tablespace to the Exclude List dialog box opens.
2
Use the Tablespace name field to enter a field name. To exclude multiple tablespaces, insert a regular expression (wild card) and select the Regex check box.
3
Click Add to complete the operation.

Invalid Objects Filtering

Invalid Objects Filtering

Use the Exclude List pane to excluding specific schemas from being monitored by the Invalid Objects collection.

To exclude a schema from being monitored:
1
Select the agent that monitors the instance where the schema resides.
* 
IMPORTANT: If the selected agent is a RAC node, changes made will apply to RAC agent, thereby affecting the entire RAC.
2
Click Add a Schema to the Exclude List.
3
Use the dialog box that appears to enter the name of the requested schema.
4
Click Add.
5
Repeat this procedure for all of the schemas that are to be excluded.
To remove schemas from the table, select the schema’s row and click Delete.
6
At the bottom of the view, click Save changes.

Configuring the Alert Log Filtering Panel Display

Use the Alert Log Filtering view to configure the retrieval and display settings for the Alerts > Alert Log panel. In addition, this view is used to define default settings for invoking alarms based on the collected alerts.

* 
IMPORTANT: While alerts whose severity type is Informational are collected and displayed on the Alert Log panel, alarms are invoked only for alerts whose severity type is Warning or higher.

Use this view to define the following settings:

•
Minimal severity for invoking summary alarms — can be either turned off or set to one of the defined severity values, that is: Warning, Critical or Fatal.
* 
IMPORTANT: By default, the value of this parameter is Critical.
•
Minimal severity for invoking alarms — can be either turned off (the default setting) or set to one of the defined severity values: Warning, Critical or Fatal.
•
Number of rows to collect from logs — the maximum number of rows that would be retrieved from the alert logs.
•
Display under a pre-defined name in the Alert Log panel — using the Match List pane. This pane contains a default list of expressions within the alert logs that are to be retrieved and displayed in the Alert Log panel under a pre-defined name, category and severity.
•
Exclusion from the Alert Log panel display — using the Ignore List pane, which contains a default list of alerts that are to be excluded when setting the alert logs display.
* 
IMPORTANT: Only messages that are explicitly defined in the Ignore List will not be displayed. Messages that were not added to either the Match or Ignore lists appear under name Other, type Oracle alert messages and severity Informational. Therefore, ensure that messages that need not be displayed are added to the Ignore List.

Both the Match List and the Ignore List panes can be customized by adding, editing or removing alert logs. Each filter can be enabled or disabled separately by clicking Edit and selecting or clearing the Enabled check box. Alternatively, to enable or disable all of the filters, click the Enable All or Disable All button.

To add an alert to the Match List:
1
Click Add.
The Add an Alert to the Match List dialog box opens.
Use this dialog box to configure the alert filter by means of the following fields:
•
Filter Name — used for assigning a name to the filter.
•
Severity — used for assigning a severity for the alert. Use this field to set the type of the alarm that is invoked as a result of the alert, or to define that the alert is informational and therefore invokes no alerts.
•
Type — used for entering a filter type, either one of the predefined types or a new type.
•
Expression — identifies the text that is to be extracted as a message from the alert log and displayed in the Message column of the Alert Log panel > Alert Log Messages table. This text usually contains the beginning of the message and a wildcard (for example: ORA-12012.*).
* 
IMPORTANT: Alert filters are enabled automatically upon addition. To disable a filter, use the Edit button.
2
Click Add to save your settings.
Each newly added alert filter is enabled by default. To disable the filter, click Edit and then clear the Enabled check box.
To edit an alert:
1
Click the requested alert log.
2
Click Edit.
The Edit the Selected Alert dialog box opens.
3
Use this dialog box to configure the alert by means of the same fields used for adding it: Filter Name, Severity, Type, and Expression.
4
To disable the filter, clear the Enabled check box.
5
Click Set to save your settings.
6
At the bottom of the view, click Save changes.

Configuring the List of Listeners per Instance

Use the Listeners Monitoring view in the Databases Administration dashboard to edit the list of monitored listeners per instance, by adding or removing listeners from the list.

To add listeners to an instance:
1
Open the drop-down list below the title Please select an agent:, to display the entire list of selected agents.
* 
IMPORTANT: As RAC agents whose version is earlier than 11G2 have no listeners, they are not included in the list, even if such agents appear in the list of selected agents.
2
Select a single agent from the list.
3
Click Add Listener.
The contents of the Add a Listener dialog box that appears now vary between Windows and UNIX. For instructions for Windows-based agent, go to Step 4.
In UNIX, enter a listener service name in the designated field.
4
For a Windows-based agent, type data in the following fields:
•
Listener name — the name of the listener
•
TNS Admin — the path of the $TNS_ADMIN directory (usually $ORACLE_HOME/network/admin)
5
Click Add.
The newly added listener appears in the Listeners table.
To edit the properties of a single listener:
1
Select the requested listener from the table.
2
Click Edit Listener.
3
In the Edit a Listener dialog box, edit the existing data in the various fields (see Step 4 of the procedure for adding a listener).
4
Click Set to apply the changes or Cancel to revert to the previous settings.
To stop monitoring a listener:
1
Select the requested listener from the table.
2
Click Delete Listener.
The Stop Monitoring a Listener dialog box opens.
3
Click Yes to confirm the deletion or Cancel to keep monitoring the listener.
4
At the bottom of the view, click Save changes.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating