Rem drv: <migrate type="data_upgrade" version="10.2.0.0" pos="ecm_data_upgrade_recompile.sql+"/>
Rem
Rem $Header: failover_data_upgrade.sql 26-jul-2005.19:32:12 chyu Exp $
Rem
Rem failover_data_upgrade.sql
Rem
Rem Copyright (c) 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      failover_data_upgrade.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    chyu        07/26/05 - modifying the migrate header position 
Rem    chyu        07/18/05 - updating the new rep manager header 
Rem    skini       06/23/05 - Register module name 
Rem    rmaggarw    02/18/05 - rmaggarw_bug-4190985
Rem    rmaggarw    02/17/05 - Created
Rem

BEGIN
DECLARE
l_oms_id INTEGER :=0;
BEGIN
    FOR crec IN (SELECT host_url FROM MGMT_OMS_PARAMETERS 
                   WHERE name = 'TIMESTAMP') 
    LOOP
          l_oms_id := l_oms_id + 1;
	  INSERT INTO mgmt_oms_parameters(host_url, name, value) VALUES
          (crec.host_url, 'OMS_ID', l_oms_id);
    END LOOP;

    COMMIT;
END;
END;
/
show errors;

-- Register a new logging module for failover
BEGIN
    MGMT_LOG.register_logging_module (MGMT_FAILOVER.G_MODULE_NAME,
				    'OMS failover');
END;
/