ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
asra_us@oracle.com. Request a Workshop for
your organization today.
Purpose
This package is an administrative interface for the Auto Diag repository.
Creates a log message template object which can be used in the write_log API call. The purpose of the log message template object is to avoid have to specify common parameters in each call to write_log.
When passing a template object, optional parameters that were not set explicitly will be copied from the template object instead.
dbms_adr.set_log_msg_template(
org_id IN VARCHAR2 DEFAULT NULL,
component_id IN VARCHAR2 DEFAULT NULL,
instance_id IN VARCHAR2 DEFAULT NULL,
hosting_client_id IN VARCHAR2 DEFAULT NULL,
msg_group IN VARCHAR2 DEFAULT NULL,
host_id IN VARCHAR2 DEFAULT NULL,
host_nwaddr IN VARCHAR2 DEFAULT NULL,
module_id IN VARCHAR2 DEFAULT NULL,
process_id IN VARCHAR2 DEFAULT NULL,
thread_id IN VARCHAR2 DEFAULT NULL,
user_id IN VARCHAR2 DEFAULT NULL,
upstream_comp_id IN VARCHAR2 DEFAULT NULL,
downstream_comp_id IN VARCHAR2 DEFAULT NULL,
ecid IN adr_log_msg_ecid_t DEFAULT NULL,
error_instance_id IN adr_log_msg_errid_t DEFAULT NULL,
msg_args IN adr_log_msg_args_t DEFAULT NULL,
detail_location IN VARCHAR2 DEFAULT NULL,
suppl_detail IN VARCHAR2 DEFAULT NULL,
con_uid IN NUMBER DEFAULT NULL,
con_id IN NUMBER DEFAULT NULL,
con_name IN VARCHAR2 DEFAULT NULL)
RETURN adr_msg_template_t;
Writes log entries to the alert log in the RDBMS ADR home
dbms_adr.write_log(
msg_id IN VARCHAR2,
msg_type IN INTEGER,
msg_level IN INTEGER,
msg_text IN VARCHAR2,
timestamp_originating IN TIMESTAMP WITH TIME ZONE DEFAULT NULL,
timestamp_normalized IN TIMESTAMP WITH TIME ZONE DEFAULT NULL,
org_id IN VARCHAR2 DEFAULT NULL,
component_id IN VARCHAR2 DEFAULT NULL,
instance_id IN VARCHAR2 DEFAULT NULL,
hosting_client_id IN VARCHAR2 DEFAULT NULL,
msg_group IN VARCHAR2 DEFAULT NULL,
host_id IN VARCHAR2 DEFAULT NULL,
host_nwaddr IN VARCHAR2 DEFAULT NULL,
module_id IN VARCHAR2 DEFAULT NULL,
process_id IN VARCHAR2 DEFAULT NULL,
thread_id IN VARCHAR2 DEFAULT NULL,
user_id IN VARCHAR2 DEFAULT NULL,
suppl_attrs IN adr_log_msg_suppl_attrs_t DEFAULT NULL,
problem_key IN VARCHAR2 DEFAULT NULL,
upstream_comp_id IN VARCHAR2 DEFAULT NULL,
downstream_comp_id IN VARCHAR2 DEFAULT NULL,
ecid IN adr_log_msg_ecid_t DEFAULT NULL,
error_instance_id IN adr_log_msg_errid_t DEFAULT NULL,
msg_args IN adr_log_msg_args_t DEFAULT NULL,
detail_location IN VARCHAR2 DEFAULT NULL,
suppl_detail IN VARCHAR2 DEFAULT NULL,
msg_template_obj IN adr_msg_template_t DEFAULT NULL,
con_uid IN NUMBER DEFAULT NULL,
con_id IN NUMBER DEFAULT NULL,
con_name IN VARCHAR2 DEFAULT NULL);