Oracle 12c DBMS_ADR_INTERNAL Demos

Oracle DBMS_ADR_INTERNAL Version 12.1.0.2

General Information

Library Note

Morgan's Library Page Footer

The Library is currently in the process of being upgraded from Oracle Database Version 12.1.0.1 to 12.1.0.2. Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs, and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.

Interested in Oracle GoldenGate? Check out the IGGOUG,

Purpose

Utility package supporting the Automatic Diagnostic Repository and related incident reporting.

AUTHID

DEFINER

Data Types

Dependencies

ADR_HOME_T	ADR_LOG_MSG_ARGS_T	DBMS_ADR
ADR_INCIDENT_CORR_KEYS_T	ADR_LOG_MSG_ECID_T	DBMS_ADRI_LIB
ADR_INCIDENT_ERR_ARGS_T	ADR_LOG_MSG_ERRID_T	DBMS_ADR_APP
ADR_INCIDENT_FILES_T	ADR_LOG_MSG_SUPPL_ATTRS_T	DBMS_UTILITY
ADR_INCIDENT_INFO_T	ADR_LOG_MSG_T	PLITBLM
ADR_INCIDENT_T	ADR_MSG_TEMPLATE_T

Documented

First Available

12.1.0

Security Model

Owned by SYS with no privileges granted

Source

{ORACLE_HOME}/rdbms/admin/prvsadri.plb

Subprograms

CREATE_ADR_HOME	INCIDENT_CREATE	WRITE_LOG
CREATE_INCIDENT	RESERVE_INCIDS	WRITE_LOG_HANDLER
GET_LOCATION	TEST_RESERVE_INCIDS	WRITE_TRACE
INCIDENT_ADD_METADATA

CREATE_ADR_HOME

Undocumented

dbms_adr_internal.create_adr_home(home IN OUT adr_home_t);

TBD

CREATE_INCIDENT

Create an incident

dbms_adr_internal.create_incident(
problem_key             IN VARCHAR2,
error_facility          IN VARCHAR2,
error_number            IN NUMBER,
error_message           IN VARCHAR2,
error_args              IN adr_incident_err_args_t,
ecid                    IN VARCHAR2,
signalling_component    IN VARCHAR2,
signalling_subcomponent IN VARCHAR2,
suspect_component       IN VARCHAR2,
suspect_subcomponent    IN VARCHAR2,
correlation_keys        IN adr_incident_corr_keys_t,
files                   IN adr_incident_files_t,
current_home            IN adr_home_t)
RETURN adr_incident_t;

TBD

GET_LOCATION

Retrieve an ADR directory disk location

dbms_adr_internal.get_location(
home IN OUT adr_home_t,
adr_service IN VARCHAR2)
RETURN VARCHAR2;

TBD

INCIDENT_ADD_METADATA

Add metadata to an existing incident

dbms_adr_internal.incident_add_metadata(incident IN OUT adr_incident_t);

TBD

INCIDENT_CREATE

Undocumented

dbms_adr_internal.incident_create(incident IN OUT adr_incident_t);

TBD

RESERVE_INCIDS

Undocumented

dbms_adr_internal.reserve_incids(
home IN OUT adr_home_t,
id_count IN BINARY_INTEGER)
RETURN NUMBER;

TBD

TEST_RESERVE_INCIDS

Undocumented

dbms_adr_internal.test_reserve_incids;

exec dbms_adr_internal.test_reserve_incids;
BEGIN dbms_adr_internal.test_reserve_incids; END;

*
ERROR at line 1:
ORA-21560: argument ORA-21560: argument 2 is null, invalid, or out of range
is null, invalid, or out of range
ORA-06512: at "SYS.DBMS_ADR_INTERNAL", line 489
ORA-06512: at line 1

WRITE_LOG

Write a string to the current ADR log file

dbms_adr_internal.write_log(
home IN OUT adr_home_t,
log_msg IN adr_log_msg_t);

TBD

WRITE_LOG_HANDLER

Undocumented

dbms_adr_internal.write_log_handler(
msg_id                IN     VARCHAR2,
msg_type              IN     NUMBER,
msg_level             IN     NUMBER,
msg_text              IN     VARCHAR2,
timestamp_originating IN     TIMESTAMP WITH TIME ZONE,
timestamp_normalized IN     TIMESTAMP WITH TIME ZONE,
org_id                IN     VARCHAR2,
component_id          IN     VARCHAR2,
instance_id           IN     VARCHAR2,
hosting_client_id     IN     VARCHAR2,
msg_group             IN     VARCHAR2,
host_id               IN     VARCHAR2,
host_nwaddr           IN     VARCHAR2,
module_id             IN     VARCHAR2,
process_id            IN     VARCHAR2,
thread_id             IN     VARCHAR2,
user_id               IN     VARCHAR2,
suppl_attrs           IN     adr_log_msg_suppl_attrs_t,
problem_key           IN     VARCHAR2,
upstream_comp_id      IN     VARCHAR2,
downstream_comp_id    IN     VARCHAR2,
ecid                  IN     adr_log_msg_ecid_t,
error_instance_id     IN     adr_log_msg_errid_t,
msg_args              IN     adr_log_msg_args_t,
detail_location       IN     VARCHAR2,
suppl_detail          IN     VARCHAR2,
msg_template_obj      IN     adr_msg_template_t,
current_home          IN OUT adr_home_t);

TBD

WRITE_TRACE

Write a string to the current ADR trace file

dbms_adr_internal.write_trace(
home IN OUT adr_home_t,
trc_msg IN VARCHAR2);

TBD