Rem drv: Rem Rem $Header: emcore/source/oracle/sysman/emdrep/sql/core/latest/target/relocate_target_pkgdef.sql /st_emcore_10.2.0.4.2db11.2/1 2009/03/25 11:24:45 joyoon Exp $ Rem Rem relocate_target_pkgdef.sql Rem Rem Copyright (c) 2004, 2009, Oracle and/or its affiliates. Rem All rights reserved. Rem Rem NAME Rem relocate_target_pkgdef.sql - Rem Rem DESCRIPTION Rem Rem Rem NOTES Rem Rem Rem MODIFIED (MM/DD/YY) Rem gsbhatia 07/01/05 - New repmgr header impl Rem rzkrishn 02/21/05 - get siblings as well in getRelatedTargets Rem rzkrishn 01/12/05 - procedure to find if duplicate target Rem rzkrishn 08/19/04 - using space as default in callbacks Rem rzkrishn 07/30/04 - callback can't be NULL in delete_tgt_relocation Rem rzkrishn 07/14/04 - rzkrishn_oms_side_of_13253 Rem rzkrishn 07/07/04 - adding callbacks Rem rzkrishn 06/15/04 - Created Rem -- -- Package: em_target_relocate -- -- PURPOSE: -- This package contains internal procedures used by target relocation. -- -- -- NOTES: -- CREATE OR REPLACE PACKAGE EM_TARGET_RELOCATE AS -- Package level Type Definition TYPE CURSORTYPE IS REF CURSOR; -- -- compare_agent_versions -- -- Takes 2 agent URL;s and determine if agent1 is of higher, equal or -- lower version than agent2. -- returns 0 if equal, 1 if agent1 > agent2, -1 agent1 < agent2 -- FUNCTION compare_agent_versions( p_src_agent_target IN VARCHAR2, p_dest_agent_target IN VARCHAR2 ) RETURN NUMBER; -- -- is_cluster_target -- -- Takes a target type and determines if it is a]cluster target or not. -- Returns FALSE if non-cluster target. TRUE if cluster target. -- FUNCTION is_cluster_target(p_target_type IN VARCHAR2) RETURN INTEGER; -- -- find_agent_monitoring_for_tgt -- -- Takes a targetname, target type and determines the current agent -- monitoring for that target. -- PROCEDURE find_agent_monitoring_for_tgt(p_target_name IN VARCHAR2, p_target_type IN VARCHAR2, p_agent_target OUT VARCHAR2); -- -- find_emd_url_for_target -- -- takes a target name and target type and finds the EMD url of -- the agent monitoring the target. -- FUNCTION find_emd_url_for_target(p_target_name IN VARCHAR2, p_target_type IN VARCHAR2) RETURN STRING; -- -- find_target_guid -- -- takes a target name and target type and finds -- its target guid. -- FUNCTION find_target_guid(p_target_name IN VARCHAR2, p_target_type IN VARCHAR2) RETURN STRING; -- -- check_preconditions -- -- Checks all the sql conditions to determine if target can be moved. -- returns TRUE for ok to proceed, FALSE for failure to proceed. -- 1. check if src agent version <= dest agent version -- 2. user has privileges to move the target. -- 3. target to be moved is not a cluster target. -- FUNCTION check_preconditions( p_target_name IN VARCHAR2, p_target_type IN VARCHAR2, p_user_name IN VARCHAR2, p_src_agent_target IN VARCHAR2, p_dest_agent_target IN VARCHAR2 ) RETURN INTEGER; -- -- PROCEDURE: add_tgt_relocation_callback -- -- PURPOSE -- Adds a callback to the repository. This callback is called whenever -- that target is relocated from one agent to another. -- -- PROCEDURE callback_name( target_name IN VARCHAR2, -- target_type IN VARCHAR2, -- old_agent_url IN VARCHAR2, -- new_agent_url IN VARCHAR2); -- -- PROCEDURE add_tgt_relocation_callback( p_callback_name IN VARCHAR2, p_target_name IN VARCHAR2 DEFAULT ' ', p_target_type IN VARCHAR2 DEFAULT ' '); -- -- PROCEDURE: delete_tgt_relocation_callback -- -- PURPOSE -- Deletes a callback from repository. -- -- PROCEDURE callback_name( target_name IN VARCHAR2, -- target_type IN VARCHAR2, -- old_agent_url IN VARCHAR2, -- new_agent_url IN VARCHAR2); -- -- PROCEDURE delete_tgt_relocation_callback( p_callback_name IN VARCHAR2, p_target_name IN VARCHAR2 DEFAULT ' ', p_target_type IN VARCHAR2 DEFAULT ' '); -- -- PROCEDURE: exec_tgt_relocation_callbacks -- -- Execute callbacks for target relocation. -- PROCEDURE exec_tgt_relocation_callbacks( p_target_name IN VARCHAR2, p_target_type IN VARCHAR2, p_old_agent_url IN VARCHAR2, p_new_agent_url IN VARCHAR2); -- -- PROCEDURE: update_tables_for_relocation -- -- PURPOSE -- updates MGMT_TARGETS, MGMT_DUPLICATE_TARGETS and invoke -- all the callbacks registered. -- PROCEDURE update_tables_for_relocation( p_target_name IN VARCHAR2, p_target_type IN VARCHAR2, p_old_agent_url IN VARCHAR2, p_new_agent_url IN VARCHAR2); -- -- PROCEDURE get_cli_blackouts_for_target -- -- PURPOSE -- gets a cursor to fetch all CLI blackouts for the target given the -- target name, target type and emd_url. -- PROCEDURE get_cli_blackouts_for_target ( p_target_name IN VARCHAR2, p_target_type IN VARCHAR2, p_emd_url IN VARCHAR2, p_cli_blackouts_cur OUT CURSORTYPE ); -- -- PROCEDURE get_related_targets -- -- PURPOSE -- gets related targets given a target. -- PROCEDURE get_related_targets ( p_target_name IN VARCHAR2, p_target_type IN VARCHAR2, p_emd_url IN VARCHAR2, p_related_parents_cur OUT CURSORTYPE, p_related_children_cur OUT CURSORTYPE, p_related_siblings_cur OUT CURSORTYPE ); -- -- check_if_duplicate_target -- -- Takes a target, source agent and destination agent url. determines if the -- target is monitored by source agent and is considered as duplicate for -- destination agent. -- returns 1 if duplicate, 0 if not duplicate. -- FUNCTION check_if_duplicate_target( p_target_name IN VARCHAR2, p_target_type IN VARCHAR2, p_src_agent_url IN VARCHAR2, p_dest_agent_url IN VARCHAR2 ) RETURN INTEGER; -- -- Handle master agent switch in case of relocating target. -- When a given target to be relocated is a member of cluster -- and the agent was master, OMS will find a new master if there is -- good one, otherwise it will keep the current master -- PROCEDURE relocate_master_agent(p_target_name IN VARCHAR2, p_target_type IN VARCHAR2, p_old_agent_url IN VARCHAR2, p_new_agent_url IN VARCHAR2 ); END EM_TARGET_RELOCATE; / show errors;