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
Utilities supporting the DBMA_HA_ALERTS package which is part of Fast Application Notification (FAN).
dbms_ha_alerts_prvt.clear_instance_resources(
database_domain IN VARCHAR2,
database_unique_name IN VARCHAR2,
instance_name IN VARCHAR2,
event_time IN TIMESTAMP WITH TIME ZONE);
conn / as sysdba
show parameter domain
NAME TYPE VALUE
---------- ----------- --------------------------------------
db_domain string sub07212035450.testvcn01.oraclevcn.com
show parameter unique
NAME TYPE VALUE
--------------- ----------- ------------------------------
db_unique_name string test21db_iad25g
dbms_ha_alerts_prvt.post_ha_alert(
reason_id IN dbms_server_alert.reason_id_t,
same_transaction IN BOOLEAN,
clear_old_alert IN BOOLEAN,
severity IN dbms_server_alert.severity_level_t DEFAULT
dbms_server_alert.level_warning,
database_domain IN VARCHAR2 DEFAULT SYS_CONTEXT('USERENV', 'DB_DOMAIN'),
database_unique_name IN VARCHAR2 DEFAULT NULL,
instance_name IN VARCHAR2 DEFAULT NULL,
service_name IN VARCHAR2 DEFAULT NULL,
host_name IN VARCHAR2 DEFAULT NULL,
incarnation IN VARCHAR2 DEFAULT NULL,
event_reason IN VARCHAR2,
event_time IN TIMESTAMP WITH TIME ZONE,
cardinality IN BINARY_INTEGER DEFAULT NULL,
event_id IN NUMBER DEFAULT NULL,
metric_value IN NUMBER DEFAULT NULL,
timeout_seconds IN BINARY_INTEGER DEFAULT NULL,
immediate_timeout IN BOOLEAN DEFAULT TRUE,
background_process IN BOOLEAN DEFAULT FALSE,
signal_interna IN BOOLEAN DEFAULT TRUE,
duplicates_ok IN BOOLEAN DEFAULT FALSE);