Search Results post_ha_alert




Overview
Explore in AI Chat

Overview

SYS.DBMS_HA_ALERTS_PRVT is a private Oracle kernel package responsible for posting and managing High Availability (HA) alerts within the Oracle E-Business Suite environment. It functions as the PL/SQL public interface through which the kernel's internal notification subsystem, implemented in kelt.c, is exercised. Its central routine packages alert attributes and dispatches them to the low-level primitives keltpost() and keltpost_bg().

Because it belongs to the SYS schema and is classified as an OTHER API, it is not an EBS application-facing interface but an infrastructure component that underpins server alert delivery. It exists largely to guarantee that HA-related notifications — such as a database or node becoming unavailable, or an instance coming back online — are reliably registered with the server alert framework without being silently discarded as duplicates.

Key Procedures and Functions

  • POST_HA_ALERT — The primary public entry point for posting an HA alert. It assembles the alert's attributes and may invoke keltpost[_bg] up to three times: once to clear an old version of the same alert, once to post the alert at the requested severity, and optionally once to clear the alert immediately. The clearing calls exist specifically to prevent the alert, or a subsequent one, from being rejected as a duplicate of an earlier entry. Parameters documented for this routine include the reason identifier drawn from the server-alert definitions, a same_transaction flag controlling whether the post participates in the caller's transaction or a recursive one, a clear_old_alert flag, the integer severity level, a host_name, an event_reason, and an event_time. When background processing is enabled, the same_transaction setting is ignored.
  • POST_INSTANCE_UP — Posts an alert indicating that an instance has become available again, complementing the failure-oriented posting performed by POST_HA_ALERT.
  • CHECK_HA_RESOURCES — Evaluates the High Availability resources associated with the instance to determine their status.
  • CLEAR_INSTANCE_RESOURCES — Removes or resets the recorded resource state for the instance, typically when resources no longer require alerting.
  • INSTANCE_STARTUP_TIMESTAMP_TZ — Returns the instance startup timestamp, expressed with time zone information, used as a reference point for HA alert timing.

Tables Accessed

The documented metadata exposes no tables reached through APPS synonyms, which is consistent with this package's role as a thin interface to the kernel alert primitives rather than a data-manipulating application unit. Its alert state is managed internally by the high-availability notification subsystem, and reason codes are drawn from the server-alert definitions (dbmsslrt.sql), not from application tables.

Usage Notes

This package is invoked by Oracle kernel and EBS infrastructure code when HA events occur; it is not intended for direct use by forms, concurrent programs, or custom application logic. Because it resides in SYS and is private in nature, customizations should not call it. Its relevance to a search for background_process lies in the same_transaction handling: when background processing (KJHN_BACKGROUND_PROCESS) is active, the transaction-affinity argument is disregarded and the background posting path is taken.