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 MARCH 03, 2022

Applies to:

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:

• Email Notification
• OS Command 
• SNMP Trap 
• PL/SQL Procedure

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.

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

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