Oracle - que hace el paquete MGMT_FAILOVER de system

Cordial Saludo:

Buenos dias, es que tengo problemas con el paquete MGMT_FAILOVER, aparece no compilado y no se deja compilar, verifico y es que aparece solo el body no el head. Quien me puede colaborar.

Muchas Gracias,

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;