This is Part III in a multi-part series, demonstrating how to take EM12c from out of the box to enterprise level.
You can read Part I and Part II to complete the first phases of this setup and look for future posts in this series to ensure your EM12c is set up to support your database world.
Monitoring templates, when created via an example database and then used as the default for all databases, allows the DBA control to create incidents and notify on what metrics are important to the business.
As templates are used at the global level, we create a template by clicking on Enterprise à Monitoring à Monitoring Template.
There are no templates by default, but as they are based off existing databases, it is easy to create one. Click on “Create” to begin the Template wizard.
For our first Template, we are going to create one based off an existing “Host” target:
We leave the default “target” for our copy choice and then click on the magnifying glass to choose an existing host from our list of targets.
Name the template a clear name and add a description. Choose to make this the default template, (although you can also edit the template and add this later, but if you don’t, it will not be applied to future discovered targets of this type.)
Click on the “Metric Thresholds” tab.
I recommend the following settings be applied to the host monitoring template:
There are rarely any critical metric thresholds. The DBAs main indicator for issues will be at the database level, not the host level, so critical alerting on these settings is removed and warning thresholds are increased to eliminate unnecessary incident creation in the EM12c console.
Save the template.
Click on “Create” to start the next template creation, first for a single database instance and then create a second template with the same metrics that you see in the table below, along with the additions shown in the cluster database metric table and use a cluster database for the source.
Again, choose the default target type and then click on the magnifying glass and choose a database instance, (single instance) and select it as the source for metrics to be sourced for the template.
Name the template a descriptive name and add a description and click in the check box to make it the default for all discovered targets of this type. Click on “Metric Thresholds” to now edit the metric values for warnings and critical.
Update or add the following values for metric thresholds:
Save the template after completing the updates/changes to the metric thresholds.
You should now have three monitoring templates- one for host and then one for single database instance and another for cluster. You can add others as required by the business, but these are the three required to alert of CRITICAL only issues and create incidents for managing during business hours of warning thresholds on metrics. As these are “default” templates, any new targets added for these target types will automatically “adopt” these metric settings and thresholds.
Next, Part IV- Incident Rule Sets