RE:que hace el paquete MGMT_FAILOVER de system
El dueño del paquete es el SYSMAN, prueba conectarte con el usuario SYS y recompilarlo.
Si de algo te sirve al HEAD en un Oracle 10g Standar es el siguiente:
create or replace PACKAGE SYSMAN.MGMT_FAILOVER AS
G_ACTIVE_OMS_GRACE_PROP CONSTANT VARCHAR2(50) := 'ACTIVE_OMS_GRACE_TIME';
G_DEFAULT_OMS_GRACE CONSTANT INTEGER := 60;
G_MIN_OMS_GRACE CONSTANT INTEGER := 30;
-- Register a new middle-tier with the failvoer package.
-- Returns a new id for the failover
FUNCTION register(p_host_url IN VARCHAR2,
p_oms_url IN VARCHAR2,
p_heartbeat_interval IN NUMBER) RETURN INTEGER;
-- Gets the count of middle-tiers registerd with the failover package
FUNCTION get_middle_tier_count RETURN INTEGER;
-- Register a callback
PROCEDURE register_callback(p_callback_name VARCHAR2);
-- Heartbeat. Returns 1 on success, 0 on failure
FUNCTION heartbeat(p_id IN NUMBER) RETURN INTEGER;
-- Check whether any components have died
PROCEDURE check_failure;
-- Gets the count of active middle-tiers registerd with the failover package
-- Active middle tiers are the ones pinged repository recently. The threshold
-- is defined by parameter ACTIVE_OMS_GRACE_TIME in mgmt_parameters.
FUNCTION get_active_mt_count RETURN INTEGER;
END MGMT_FAILOVER;