Which has the higher priority in your organization: Deploying a new database or securing the ones you already have?
Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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);