Oracle | DBMS_HA_ALERTS

Oracle DBMS_HA_ALERTS_PRVT Version 21c

General Information

Library Note

Morgan's Library Page Header

Which has the higher priority in your organization: Deploying a new database or securing the ones you already have? Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.

Purpose Utilities supporting the DBMA_HA_ALERTS package which is part of Fast Application Notification (FAN).

AUTHID DEFINER

Dependencies

DBMS_HA_ALERT_LIB	DBMS_SERVER_ALERT_PRVT	RECENT_RESOURCE_INCARNATIONS$
DBMS_PRVT_TRACE	DBMS_SYS_ERROR	V$INSTANCE
DBMS_SERVER_ALERT	GV$INSTANCE

Documented No

First Available 10.2

Security Model Owned by SYS with EXECUTE granted to SYSRAC

Source {ORACLE_HOME}/rdbms/admin/dbmshae.sql

Subprograms

CHECK_HA_RESOURCES	INSTANCE_STARTUP_TIMESTAMP_TZ	POST_INSTANCE_UP
CLEAR_INSTANCE_RESOURCES	POST_HA_ALERT

CHECK_HA_RESOURCES

Undocumented dbms_ha_alerts_prvt.check_ha_resources RETURN VARCHAR2;

conn / as sysdba

      

      DECLARE

       retval VARCHAR2(128);

      BEGIN

        retVal := dbms_ha_alerts_prvt.check_ha_resources;

        dbms_output.put_line(retVal); 

      END;

      /

      Y

      

      PL/SQL procedure successfully completed.

CLEAR_INSTANCE_RESOURCES

Undocumented dbms_ha_alerts_prvt.clear_instance_resources( database_domain IN VARCHAR2, database_unique_name IN VARCHAR2, instance_name IN VARCHAR2, event_time IN TIMESTAMP WITH TIME ZONE);

conn / as sysdba

      

      show parameter domain

      

      NAME       TYPE        VALUE

      ---------- ----------- --------------------------------------

      db_domain  string      sub07212035450.testvcn01.oraclevcn.com

      

      show parameter unique

      

      NAME            TYPE        VALUE

      --------------- ----------- ------------------------------

      db_unique_name  string      test21db_iad25g

      

      SELECT instance_name

      FROM v$instance;

      

      INSTANCE_NAME

      ----------------

      test21db

      

      exec dbms_ha_alerts_prvt.clear_instance_resources( 'sub07212035450.testvcn01.oraclevcn.com', 'test21db_iad25g', 'test21db', SYSTIMESTAMP-1);

      

      PL/SQL procedure successfully completed.

INSTANCE_STARTUP_TIMESTAMP_TZ

Undocumented dbms_ha_alerts_prvt.instance_startup_timezone_tz(startup_time IN DATE) RETURN TIMESTAMP WITH TIME ZONE;

conn / as sysdba

      

      set serveroutput on

      

      DECLARE

       sut gv$instance.startup_time%TYPE;

       ret VARCHAR2(100);

      BEGIN

        SELECT startup_time

        INTO sut

        FROM gv$instance;

      

        SELECT SYS_EXTRACT_UTC(dbms_ha_alerts_prvt.instance_startup_timestamp_tz(sut))

        INTO ret

        FROM dual;

      

        dbms_output.put_line(ret);

      END;

      /

      17-JAN-21 02.21.41.000000 AM

      

      PL/SQL procedure successfully completed.

POST_HA_ALERT

Undocumented dbms_ha_alerts_prvt.post_ha_alert( reason_id IN dbms_server_alert.reason_id_t, same_transaction IN BOOLEAN, clear_old_alert IN BOOLEAN, severity IN dbms_server_alert.severity_level_t DEFAULT dbms_server_alert.level_warning, database_domain IN VARCHAR2 DEFAULT SYS_CONTEXT('USERENV', 'DB_DOMAIN'), database_unique_name IN VARCHAR2 DEFAULT NULL, instance_name IN VARCHAR2 DEFAULT NULL, service_name IN VARCHAR2 DEFAULT NULL, host_name IN VARCHAR2 DEFAULT NULL, incarnation IN VARCHAR2 DEFAULT NULL, event_reason IN VARCHAR2, event_time IN TIMESTAMP WITH TIME ZONE, cardinality IN BINARY_INTEGER DEFAULT NULL, event_id IN NUMBER DEFAULT NULL, metric_value IN NUMBER DEFAULT NULL, timeout_seconds IN BINARY_INTEGER DEFAULT NULL, immediate_timeout IN BOOLEAN DEFAULT TRUE, background_process IN BOOLEAN DEFAULT FALSE, signal_interna IN BOOLEAN DEFAULT TRUE, duplicates_ok IN BOOLEAN DEFAULT FALSE);

DECLARE

       rid    dbms_server_alert.reason_id_t;

       strans BOOLEAN := FALSE;

       clrold BOOLEAN := FALSE;

       sev    dbms_server_alert.severity_level_t;

       domain VARCHAR2(128) := SYS_CONTEXT('USERENV', 'DB_DOMAIN');

       uniq   VARCHAR2(30) := 'test21db_iad25g';

       inst   VARCHAR2(30) := 'test21db';

       serv   VARCHAR2(128) := 'test21db_iad25g.sub07212035450';

       host   VARCHAR2(30) := 'test21';

       incarn VARCHAR2(30) := '0';

       eventr VARCHAR2(30) := 'user';

       eventt TIMESTAMP := SYSTIMESTAMP;

       card   BINARY_INTEGER;

       eventi NUMBER;

       metric NUMBER;

       outsec BINARY_INTEGER;

       immdto BOOLEAN := TRUE;

       bkgpro BOOLEAN := FALSE;

       sigint BOOLEAN := TRUE;

       dupok  BOOLEAN := FALSE;

      BEGIN

        rid := dbms_server_alert.rsn_fan_database_down;

        sev := dbms_server_alert.level_warning;

        

        dbms_ha_alerts_prvt.post_ha_alert(rid, strans, clrold, sev, domain, uniq,

                                          inst, serv, host, incarn, eventr, eventt,

                                          card, eventi, metric, outsec, immdto, 

                                          bkgpro, sigint, dupok);

      END;

      /

      

      PL/SQL procedure successfully completed.

POST_INSTANCE_UP

Undocumented dbms_ha_alerts_prvt.post_instance_up RETURN VARCHAR2;

conn / as sysdba

      

      col post_instance_up format a30

      

      SELECT  dbms_ha_alerts_prvt.post_instance_up

      FROM dual;

      

      POST_INSTANCE_UP

      -----------------

      Y