Oracle DBMS_ADR_INTERNAL
Version 12.2.0.1

General Information
Library Note Morgan's Library Page Header
"I spent my entire adult life looking out for the well-being, the training, the equipping of the troops for whom I was responsible. I will not be lectured about what our military needs by a five-deferment draft dodger,"
~ Sen. Tammy Duckworth
Purpose Utility package supporting the Automatic Diagnostic Repository and related incident reporting.
AUTHID DEFINER
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_STANDARD
ADR_INCIDENT_INFO_T ADR_LOG_MSG_T DBMS_UTILITY
ADR_INCIDENT_T ADR_MSG_TEMPLATE_T PLITBLM
Documented No
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
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,
data     IN     VARCHAR2);
TBD
 
RESERVE_INCIDS
Undocumented dbms_adr_internal.reserve_incids(
home     IN OUT adr_home_t,
id_count IN     BINARY_INTEGER)
RETURN NUMBER;
TBD
 
RUN_PURGE (new 12.2)
??? dbms_adr_internal.run_purge(
home      IN OBJECT???
threshold IN 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
 
SET_TRACEFILE_IDENTIFIER (new 12.2)
An API for performing the action ALTER SESSION SET TRACEFILE_IDENTIFIER = '<identifier_string>'; dbms_adr_internal.set_tracefile_identifier(
home           IN OUT OBJECT???,
trc_identifier IN     VARCHAR2);
TBD
 
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,
con_uid               IN     NUMBER              DEFAULT NULL,
con_id                IN     NUMBER              DEFAULT NULL,
con_name              IN     NUMBER              DEFAULT NULL,
current_home          IN OUT adr_home_t);
TBD
 
WRITE_TRACE
Write trace lines to the trace file in the RDBMS ADR home dbms_adr_internal.write_trace(
home       IN OBJECT???
trace_data IN VARCHAR2);
exec dbms_adr_internal.write_trace(???, 'Testing the new database version 12cR2');

-- go to the directory returned by GET_TRACE_LOCATION function and open the most recent .trc files.>

Related Topics
ADRCI
DBMS_ADR
DBMS_ADR_APP
DBMS_IR
Packages
What's New In 12cR1
What's New In 12cR2

Morgan's Library Page Footer
This site is maintained by Dan Morgan. Last Updated: This site is protected by copyright and trademark laws under U.S. and International law. © 1998-2017 Daniel A. Morgan All Rights Reserved