Oracle 12cR2 DBMS_ADR

Oracle DBMS_ADR_INTERNAL Version 12.2.0.1

General Information

Library Note

Morgan's Library Page Header

Are you prepared for the release of Oracle Database 18c ... the first autonomous database? We are here at the Library. It is time for DBAs to stop fighting robots with their fingers and losing ... time to start using our intelligence and winning.

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	INCIDENT_CREATE	TEST_RESERVE_INCIDS
CREATE_INCIDENT	RESERVE_INCIDS	WRITE_LOG
GET_LOCATION	RUN_PURGE	WRITE_LOG_HANDLER
INCIDENT_ADD_METADATA	SET_TRACEFILE_IDENTIFIER	WRITE_TRACE

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.>