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 18.104.22.168.0 and later
Information in this document applies to any platform.
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.
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.
Enterprise Manager Cloud Control Administrators who require an custom PL/SQL procedure to be executed via the Notification subsystem.
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
|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|