My Oracle Support Banner

EM 12c, EM 13c : Steps to configure PL/SQL Notification Method to Execute a Custom PL/SQL procedure (Doc ID 1542585.1)

Last updated on JUNE 27, 2020

Applies to:

Enterprise Manager Base Platform - Version 12.1.0.1.0 and later
Information in this document applies to any platform.

Purpose

Notification methods define the method by which the notifications will be sent to the Enterprise Manager administrators under the configured conditions. The available Notification methods in Enterprise Manager are:

This document provides the steps for configuring PL/SQL Notification Method in 12c / 13c Enterprise Manager Cloud Control UI so that a custom PL/SQL procedure can be invoked on the occurrence / update of an Event / Incident / Problem as defined in the Incident Management Rules. The procedure can access the contextual information of the event / incident / problem details via environment variables, which can be used to customize automated responses specific to event conditions.

Note:

1. Policy Violations are no longer supported for enabling Notifications beginning with the Enterprise Manager 12c release.
2. Once the notification method has been created, it is necessary to define an Incident Management Rule which provides the conditions under which this method is invoked by the OMS for sending notifications. Refer to:

Note 1368036.1 : EM 12c, EM 13c : Steps to Configure Incident Rules to Send Notifications or Manage Events / Incidents / Problems
Note 1553311.1 : EM 12c, EM 13c : How to Configure Incident Rule to Invoke Advanced Notification Methods like OS Command, PL/SQL or SNMP Traps?

Once the notification method has been created, it is necessary to define an Incident Management Rule which provides the conditions under which this method is invoked by the OMS, for sending notifications.

Scope

Enterprise Manager Cloud Control Administrators who require an custom PL/SQL procedure to be executed via the Notification subsystem.

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
 Create the PL/SQL Procedure
 Passing Information to the PL/SQL Procedure
 Migrating pre-12c PL/SQL Procedures
 Sample PL/SQL Procedure
 Configure the PL/SQL Notification Method
 OMS Parameters related to PL/SQL Notification
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.