Rem drv: <migrate type="data_upgrade" version="11.2.0.3"/>
Rem $Header: emdb/source/oracle/sysman/emdrep/sql/db/11.2.0.3/rac/rac_data_upgrade.sql /st_emdbsa_11.2/1 2011/01/17 11:11:31 ajdsouza Exp $
Rem
Rem rac_data_upgrade.sql
Rem
Rem Copyright (c) 2007, 2011, Oracle and/or its affiliates. 
Rem All rights reserved. 
Rem
Rem    NAME
Rem      rac_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    ajdsouza    01/11/11 - bug fix 10358408
Rem    ajdsouza    01/11/11 - Created
Rem

SET ECHO ON

SET FEEDBACK 1
SET NUMWIDTH 10
SET LINESIZE 80
SET TRIMSPOOL ON
SET TAB OFF
SET PAGESIZE 100


Rem 
Rem  Register response metrics for cluster target for meta ver 5.3
Rem

DECLARE
   l_dummy   INTEGER;
BEGIN

 BEGIN
-- There is a end type meta ver defined, so no need to set end meta ver 
--  this is not the situation when a fresh 11.2.0.2 install is upgraded where end meta ver will be null
  SELECT 1
    INTO l_dummy
    FROM mgmt_metric_versions v
   WHERE v.target_type = 'cluster'
     AND v.end_type_meta_ver IS NOT NULL
     AND v.metric_name = 'Response';

  MGMT_METRIC.SET_END_TYPE_META_VER( 'cluster', 'Response', '5.3');

 EXCEPTION
     WHEN NO_DATA_FOUND THEN
       NULL;
 END;

-- if there is no Response metric for 5.3 in the upgrade path from 11.2.0.2 to 11.2.0.3 then create one
 BEGIN

  SELECT 1
     INTO l_dummy
     FROM mgmt_metrics m
    WHERE m.target_type = 'cluster'
      AND m.metric_name = 'Response'
      AND m.metric_column = ' '
      AND m.type_meta_ver = '5.3';

 EXCEPTION
  WHEN NO_DATA_FOUND THEN
   EMD_RAC.REGISTER_AVAILABILITY( 'cluster', 'Response', 'Status', 'host', '5.3', '5.3');
 END;

 COMMIT;

END;
/