Hi, In this video, I'm going to demonstrate how to set incidents and email alerts for
an Oracle GoldenGate Classic instance in the Enterprise
Manager plug-in.
For the purpose of this demonstration, the classic instance targets have already been
discovered and are ready to be monitored.
An incident is a significant event or set of related significant events that need to
be managed because it can potentially impact your business applications.
These incidents typically need to be tracked, assigned to appropriate personnel, and resolved
as quickly as possible.
In the UI: you can
Create an Incident Threshold
Create an Incident Ruleset
Assign the Rule to a Target.
Assign Users to receive the notification
Email Alert Ruleset created After logging in to the Enterprise Manager
Cloud Control, look up for a discovered target, for which, you want to set incidents and alerts.
On the main page, click Targets and select GoldenGate to view a list of discovered targets.
On the OGG Home Page, click the Extract target. Expand the Oracle GoldenGate Extract drop-down, click Monitoring, and then click Metric and
Collection Settings.
Under Metric and Collection Settings, expand the Metrics with thresholds drop-down, click
All Metrics.
You can set Warning Thresholds and Critical Thresholds on the Metrics tab for all the
end points.
This is a delta operation.
For example, set a Warning Threshold number for Total Inserts and a Critical Threshold
for Total Updates.
Click OK.
Click OK on the confirmation screen.
Click OGG Home.
The Incident Alert has been successfully configured.
To generate the use case, we need to perform the DML operation and process it.
After it is processed, the incidents are generated.
Refresh the OGG Home page and click the critical incident under the Incidents on the
Extract grid.
The Total Updates exceeds the threshold number that is set, and therefore a critical
incident is displayed in the Incident Manager.
You can now create an incident rule.
In this case, we will create a rule set to trigger an email alert.
On the Home page, click Setup, select Incidents, and then click Incident Rule.
Click Create Rule Set...
Enter a Rule name and click Save.
In the Target area, select Targets from the Add drop-down and click Add.
Lookup for a target using the Target Name and click Search.
Select a Target Instance and click Select.
In the Rules area, click Create.
Select an option and click Continue.
Click Add under Selected events of type Metric Alert.
Click Oracle GoldenGate Extract from the Target Type drop-down, type Insert in the Metric
Name and click Search.
Select Total Inserts.
Select the required Corrective Action Status, leave the Severity as All, and click OK.
Click Next.
Click Add.
Select Create Incident and type or select a user under Initial Setup.
Set a Priority (Urgent in this case)
Assign recipients to receive the notifications.
Click Continue. View the summary in the Add Actions Page and click Next.
Click Next again.
Click Continue.
And then click Save.
A rule 309 has been successfully created and added to the current rule set.
EXTRACTSTATUS is the incident rule set that has been created which will trigger alert
and send emails to the administrator in case of the specified incident.
Similarly, you can create your incident rule sets and subscribe to them so that you are
notified with an email every time there is an event or incident.
Do tune into the Oracle Help Center for more insight and information.
Thank You!