Oracle DBMS_ADR_INTERNAL
Version 12.1.0.1

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 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);
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

Related Topics
ADRCI
DBMS_ADR
DBMS_ADR_APP
DBMS_IR
Packages

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-2014 Daniel A. Morgan All Rights Reserved