Edit D:\app\Administrator\product\11.2.0\dbhome_1\sysman\admin\metadata\hascluster.xmlp

<!-- $Header: emdb/sysman/admin/metadata/hascluster.xmlp /st_emdbsa_11.2/19 2009/06/12 18:24:49 shasingh Exp $

Desc : Metrics common to cluster target and a host target in a 
  Single Instance HA configuration

MODIFIED    (MM/DD/YY)
   shasingh     06/04/09 - mark Status column for stateless alert
   ajdsouza     03/20/09 - added metric for cluster health check
   ajdsouza     02/17/09 - added metrics css_nodes and vip relocation
   rsamaved     11/26/08 - change usage type from hidden metrics
   rsamaved     11/24/08 - hide clusterware event metrics
   ajdsouza     07/01/08 - added multiple metrics for eons with filters
   shasingh     04/30/08 - Changed status column case
   ajdsouza     05/22/07 - added resouces
   ajdsouza     02/05/07 - creation

-->

<Metric NAME="crs_event" TYPE="TABLE" IS_METRIC_LONG_RUNNING="TRUE">

<Display>
        <Label NLSID="crs_event">Clusterware Event</Label>
      </Display>
      <TableDescriptor>

<ColumnDescriptor NAME="metric_source" TYPE="STRING" IS_KEY="FALSE">
          <Display>
            <Label NLSID="metric_source">Metric Source</Label>
          </Display>
         </ColumnDescriptor>

<ColumnDescriptor NAME="ons_event_type" TYPE="STRING" IS_KEY="FALSE">
          <Display>
            <Label NLSID="ons_event_type">Clusterware Event</Label>
          </Display>
         </ColumnDescriptor>

<ColumnDescriptor NAME="ons_event_time" TYPE="STRING" IS_DATE="FALSE" IS_KEY="FALSE">
          <Display>
            <Label NLSID="ons_event_time">Event Time</Label>
          </Display>
         </ColumnDescriptor>

<ColumnDescriptor NAME="crs_entity_subtype" TYPE="STRING" IS_KEY="FALSE">
          <Display>
            <Label NLSID="resource_instance_resource_type">Resource Type</Label>
          </Display>
         </ColumnDescriptor>

<ColumnDescriptor NAME="crs_entity_id" TYPE="STRING" IS_KEY="FALSE">
          <Display>
            <Label NLSID="resource_instance_id">Resource Instance ID</Label>
          </Display>
         </ColumnDescriptor>

<ColumnDescriptor NAME="crs_event_value" TYPE="STRING" IS_KEY="FALSE">
          <Display>
            <Label NLSID="crs_event_value">Event Value</Label>
          </Display>
         </ColumnDescriptor>

<ColumnDescriptor NAME="Status" TYPE="STRING" IS_KEY="FALSE" STATELESS_ALERTS="TRUE">
          <Display>
            <Label NLSID="Status">State</Label>
          </Display>
         </ColumnDescriptor>

<ColumnDescriptor NAME="crs_event_composite_status" TYPE="STRING" IS_KEY="FALSE">
          <Display>
            <Label NLSID="crs_event_composite_status">Composite State</Label>
          </Display>
         </ColumnDescriptor>

<ColumnDescriptor NAME="crs_event_body" TYPE="STRING" IS_KEY="FALSE" IS_LONG_TEXT="TRUE">
          <Display>
            <Label NLSID="crs_event_body">Event Body</Label>
          </Display>
         </ColumnDescriptor>

<ColumnDescriptor NAME="crs_event_body1" TYPE="STRING" IS_KEY="FALSE" >
          <Display>
            <Label NLSID="crs_event_body1">Event Body Part 1</Label>
          </Display>
         </ColumnDescriptor>

<ColumnDescriptor NAME="crs_event_body2" TYPE="STRING" IS_KEY="FALSE" >
          <Display>
            <Label NLSID="crs_event_body2">Event Body Part 2</Label>
          </Display>
         </ColumnDescriptor>

</TableDescriptor>

<PushDescriptor  RECVLET_ID="CRSeOns">
      <Property NAME="eonsPort" SCOPE="INSTANCE" OPTIONAL="TRUE">eonsPort</Property>
      <Property NAME="eonsPort_dynamic" SCOPE="INSTANCE" OPTIONAL="TRUE">eonsPort_dynamic</Property>
      <Property NAME="eonsPort_static" SCOPE="USER" OPTIONAL="TRUE">eonsPort_static</Property>
      <Property NAME="eonsEventType" SCOPE="GLOBAL" OPTIONAL="TRUE"></Property>
      <Property NAME="TriggerCollection" SCOPE="GLOBAL" OPTIONAL="TRUE">none</Property>
      <Property NAME="subscribeResourceType" SCOPE="GLOBAL" OPTIONAL="TRUE">ora.</Property>
      <Property NAME="sendMetricRow" SCOPE="GLOBAL" OPTIONAL="TRUE"><![CDATA[TRUE]]></Property>
      <Property NAME="eventGeneratingComponent" SCOPE="GLOBAL" OPTIONAL="TRUE"><![CDATA[ORACLE_CLUSTERWARE]]></Property>
      <Property NAME="disableEonsRcvlet" SCOPE="SYSTEMGLOBAL">disableEonsRcvlet</Property>
     </PushDescriptor>

<QueryDescriptor FETCHLET_ID="OSLineToken">
	 <Property NAME="perlBin" SCOPE="SYSTEMGLOBAL">perlBin</Property>
	 <Property NAME="scriptsDir" SCOPE="SYSTEMGLOBAL">scriptsDir</Property>
         <Property NAME="ENVEM_PERLBIN_DIR" SCOPE="SYSTEMGLOBAL">perlBin</Property>
         <Property NAME="ENVEM_SCRIPTS_DIR" SCOPE="SYSTEMGLOBAL">scriptsDir</Property>
         <Property NAME="ENVCRS_HOME" SCOPE="INSTANCE" OPTIONAL="TRUE">OracleHome</Property>
         <Property NAME="OracleHome" SCOPE="INSTANCE" OPTIONAL="TRUE">OracleHome</Property>
         <Property NAME="ENVEM_VERSION_CATEGORY" SCOPE="INSTANCE" OPTIONAL="TRUE">VersionCategory</Property>
         <Property NAME="VersionCategory" SCOPE="INSTANCE" OPTIONAL="TRUE">VersionCategory</Property>
	 <Property NAME="startsWith" SCOPE="GLOBAL">em_result=</Property>
         <Property NAME="warningStartsWith" SCOPE="GLOBAL">em_warning=</Property>
	 <Property NAME="delimiter" SCOPE="GLOBAL">|</Property>
         <Property NAME="subscribeResourceType" SCOPE="GLOBAL" OPTIONAL="TRUE">ora.</Property>
         <Property NAME="command" SCOPE="GLOBAL"><![CDATA[
%perlBin%/perl %scriptsDir%/has/has_metrics.pl crs_event %OracleHome% %subscribeResourceType% %VersionCategory%
]]></Property>
	</QueryDescriptor>

</Metric>

<!--
  <Metric NAME="resource_instance" TYPE="TABLE" IS_METRIC_LONG_RUNNING="TRUE" KEYS_FROM_MULT_COLLS="TRUE" >

<Display>
        <Label NLSID="resource_instance">Resource Instance State</Label>
      </Display>
      <TableDescriptor>

<ColumnDescriptor NAME="resource_name" TYPE="STRING" IS_KEY="FALSE">
          <Display>
            <Label NLSID="resource_instance_resource_name">Resource Name</Label>
          </Display>
         </ColumnDescriptor>

<ColumnDescriptor NAME="crs_event_value" TYPE="STRING" IS_KEY="FALSE">
          <Display>
            <Label NLSID="resource_instance_value">State</Label>
          </Display>
         </ColumnDescriptor>

<ColumnDescriptor NAME="crs_event_composite_status" TYPE="STRING" IS_KEY="FALSE">
          <Display>
            <Label NLSID="resource_instance_composite_status">State Change</Label>
          </Display>
         </ColumnDescriptor>

</TableDescriptor>
     <PushDescriptor  RECVLET_ID="CRSeOns">
      <Property NAME="eonsPort" SCOPE="INSTANCE" OPTIONAL="TRUE">eonsPort</Property>
      <Property NAME="eonsPort_dynamic" SCOPE="INSTANCE" OPTIONAL="TRUE">eonsPort_dynamic</Property>
      <Property NAME="eonsPort_static" SCOPE="USER" OPTIONAL="TRUE">eonsPort_static</Property>
      <Property NAME="eonsEventType" SCOPE="GLOBAL" OPTIONAL="TRUE">CRS_RESOURCE_STATE_CHANGE,CRS_RESOURCE_PROFILE_CHANGE</Property>
      <Property NAME="TriggerCollection" SCOPE="GLOBAL" OPTIONAL="TRUE">none</Property>
      <Property NAME="subscribeResourceType" SCOPE="GLOBAL" OPTIONAL="TRUE"></Property>
      <Property NAME="subscribeResourceTypeVerb" SCOPE="GLOBAL" OPTIONAL="TRUE"></Property>
      <Property NAME="skipTimestampInKey" SCOPE="GLOBAL" OPTIONAL="TRUE"><![CDATA[YES]]></Property>
      <Property NAME="sendMetricRow" SCOPE="GLOBAL" OPTIONAL="TRUE"><![CDATA[TRUE]]></Property>
      <Property NAME="eventGeneratingComponent" SCOPE="GLOBAL" OPTIONAL="TRUE"><![CDATA[ORACLE_CLUSTERWARE]]></Property>
      <Property NAME="sendStatusRelatedEventsOnly" SCOPE="GLOBAL" OPTIONAL="TRUE"><![CDATA[YES]]></Property>
      <Property NAME="disableEonsRcvlet" SCOPE="SYSTEMGLOBAL">disableEonsRcvlet</Property>
     </PushDescriptor>

<QueryDescriptor FETCHLET_ID="OSLineToken">
	 <Property NAME="perlBin" SCOPE="SYSTEMGLOBAL">perlBin</Property>
	 <Property NAME="scriptsDir" SCOPE="SYSTEMGLOBAL">scriptsDir</Property>
         <Property NAME="ENVEM_PERLBIN_DIR" SCOPE="SYSTEMGLOBAL">perlBin</Property>
         <Property NAME="ENVEM_SCRIPTS_DIR" SCOPE="SYSTEMGLOBAL">scriptsDir</Property>
         <Property NAME="ENVCRS_HOME" SCOPE="INSTANCE" OPTIONAL="TRUE">OracleHome</Property>
         <Property NAME="OracleHome" SCOPE="INSTANCE" OPTIONAL="TRUE">OracleHome</Property>
	 <Property NAME="startsWith" SCOPE="GLOBAL">em_result=</Property>
         <Property NAME="warningStartsWith" SCOPE="GLOBAL">em_warning=</Property>
	 <Property NAME="delimiter" SCOPE="GLOBAL">|</Property>
         <Property NAME="skipTimestampInKey" SCOPE="GLOBAL" OPTIONAL="TRUE"><![CDATA[YES]]></Property>
         <Property NAME="subscribeResourceType" SCOPE="GLOBAL" OPTIONAL="TRUE"></Property>
         <Property NAME="subscribeResourceTypeVerb" SCOPE="GLOBAL" OPTIONAL="TRUE"></Property>
         <Property NAME="sendStatusRelatedEventsOnly" SCOPE="GLOBAL" OPTIONAL="TRUE"><![CDATA[YES]]></Property>
         <Property NAME="command" SCOPE="GLOBAL"><![CDATA[
%perlBin%/perl %scriptsDir%/has/has_metrics.pl resource_instance_alert_metric %OracleHome% %subscribeResourceType% %subscribeResourceTypeVerb%
]]></Property>
	</QueryDescriptor>

</Metric>
  -->

<Metric NAME="resource_status" TYPE="TABLE" IS_METRIC_LONG_RUNNING="TRUE" KEYS_FROM_MULT_COLLS="TRUE" >

<Display>
        <Label NLSID="resource_status">Resource State</Label>
      </Display>
      <TableDescriptor>

<ColumnDescriptor NAME="crs_entity_name" TYPE="STRING" IS_KEY="FALSE">
          <Display>
            <Label NLSID="resource_instance_resource_name">Resource Name</Label>
          </Display>
         </ColumnDescriptor>

<ColumnDescriptor NAME="resource_status_cardinality" TYPE="STRING" IS_KEY="FALSE">
          <Display>
            <Label NLSID="resource_status_cardinality">Cardinality</Label>
          </Display>
         </ColumnDescriptor>

<ColumnDescriptor NAME="resource_status_degree" TYPE="STRING" IS_KEY="FALSE">
          <Display>
            <Label NLSID="resource_status_degree">Degree</Label>
          </Display>
         </ColumnDescriptor>

<ColumnDescriptor NAME="resource_status_total_count" TYPE="NUMBER" IS_KEY="FALSE">
          <Display>
            <Label NLSID="resource_status_total_count">Configured Instance Count</Label>
          </Display>
         </ColumnDescriptor>

<ColumnDescriptor NAME="resource_status_online_count" TYPE="NUMBER" IS_KEY="FALSE">
          <Display>
            <Label NLSID="resource_status_online_count">Online Instance Count</Label>
          </Display>
         </ColumnDescriptor>

<ColumnDescriptor NAME="resource_status_offline_count" TYPE="NUMBER" IS_KEY="FALSE">
          <Display>
            <Label NLSID="resource_status_offline_count">Offline Instance Count</Label>
          </Display>
         </ColumnDescriptor>

<ColumnDescriptor NAME="resource_status_unknown_count" TYPE="NUMBER" IS_KEY="FALSE">
          <Display>
            <Label NLSID="resource_status_unknown_count">Unknown Instance Count</Label>
          </Display>
         </ColumnDescriptor>

<ColumnDescriptor NAME="resource_status_intermediate_count" TYPE="NUMBER" IS_KEY="FALSE">
          <Display>
            <Label NLSID="resource_status_intermediate_count">Intermediate Instance Count</Label>
          </Display>
         </ColumnDescriptor>

<ColumnDescriptor NAME="resource_status_alert_state" TYPE="STRING" IS_KEY="FALSE">
          <Display>
            <Label NLSID="resource_status_alert_state">State Triggering Alert</Label>
          </Display>
         </ColumnDescriptor>

<ColumnDescriptor NAME="resource_status_alert_count" TYPE="STRING" IS_KEY="FALSE">
          <Display>
            <Label NLSID="resource_status_alert_count">Count of Instances in alert state</Label>
          </Display>
         </ColumnDescriptor>

<ColumnDescriptor NAME="resource_status_additional_mesg" TYPE="STRING" IS_KEY="FALSE">
          <Display>
            <Label NLSID="resource_status_additional_mesg">Additional State Information</Label>
          </Display>
         </ColumnDescriptor>

</TableDescriptor>
     <PushDescriptor  RECVLET_ID="CRSeOns">
      <Property NAME="eonsPort" SCOPE="INSTANCE" OPTIONAL="TRUE">eonsPort</Property>
      <Property NAME="eonsPort_dynamic" SCOPE="INSTANCE" OPTIONAL="TRUE">eonsPort_dynamic</Property>
      <Property NAME="eonsPort_static" SCOPE="USER" OPTIONAL="TRUE">eonsPort_static</Property>
      <Property NAME="eonsEventType" SCOPE="GLOBAL" OPTIONAL="TRUE">CRS_RESOURCE_STATE_CHANGE,CRS_RESOURCE_PROFILE_CHANGE</Property>
      <Property NAME="TriggerCollection" SCOPE="GLOBAL" OPTIONAL="TRUE">none</Property>
      <Property NAME="subscribeResourceType" SCOPE="GLOBAL" OPTIONAL="TRUE"></Property>
      <Property NAME="subscribeResourceTypeVerb" SCOPE="GLOBAL" OPTIONAL="TRUE"></Property>
      <Property NAME="skipIdInKey" SCOPE="GLOBAL" OPTIONAL="TRUE"><![CDATA[YES]]></Property>
      <Property NAME="skipEventInKey" SCOPE="GLOBAL" OPTIONAL="TRUE"><![CDATA[YES]]></Property>
      <Property NAME="skipTimestampInKey" SCOPE="GLOBAL" OPTIONAL="TRUE"><![CDATA[YES]]></Property>
      <Property NAME="sendMetricRow" SCOPE="GLOBAL" OPTIONAL="TRUE"><![CDATA[YES]]></Property>
      <Property NAME="eventGeneratingComponent" SCOPE="GLOBAL" OPTIONAL="TRUE"><![CDATA[ORACLE_CLUSTERWARE]]></Property>
      <Property NAME="sendStatusRelatedEventsOnly" SCOPE="GLOBAL" OPTIONAL="TRUE"><![CDATA[YES]]></Property>
      <Property NAME="disableEonsRcvlet" SCOPE="SYSTEMGLOBAL">disableEonsRcvlet</Property>
     </PushDescriptor>

<QueryDescriptor FETCHLET_ID="OSLineToken">
	 <Property NAME="perlBin" SCOPE="SYSTEMGLOBAL">perlBin</Property>
	 <Property NAME="scriptsDir" SCOPE="SYSTEMGLOBAL">scriptsDir</Property>
         <Property NAME="ENVEM_PERLBIN_DIR" SCOPE="SYSTEMGLOBAL">perlBin</Property>
         <Property NAME="ENVEM_SCRIPTS_DIR" SCOPE="SYSTEMGLOBAL">scriptsDir</Property>
         <Property NAME="ENVCRS_HOME" SCOPE="INSTANCE" OPTIONAL="TRUE">OracleHome</Property>
         <Property NAME="OracleHome" SCOPE="INSTANCE" OPTIONAL="TRUE">OracleHome</Property>
	 <Property NAME="startsWith" SCOPE="GLOBAL">em_result=</Property>
         <Property NAME="warningStartsWith" SCOPE="GLOBAL">em_warning=</Property>
	 <Property NAME="delimiter" SCOPE="GLOBAL">|</Property>
         <Property NAME="subscribeResourceType" SCOPE="GLOBAL" OPTIONAL="TRUE"><![CDATA[]]></Property>
         <Property NAME="subscribeResourceTypeVerb" SCOPE="GLOBAL" OPTIONAL="TRUE"><![CDATA[]]></Property>
         <Property NAME="skipIdInKey" SCOPE="GLOBAL" OPTIONAL="TRUE"><![CDATA[YES]]></Property>
         <Property NAME="skipTimestampInKey" SCOPE="GLOBAL" OPTIONAL="TRUE"><![CDATA[YES]]></Property>
         <Property NAME="sendStatusRelatedEventsOnly" SCOPE="GLOBAL" OPTIONAL="TRUE"><![CDATA[YES]]></Property>
         <Property NAME="command" SCOPE="GLOBAL"><![CDATA[
%perlBin%/perl %scriptsDir%/has/has_metrics.pl resource_instance_status_metric %OracleHome% %subscribeResourceType% %subscribeResourceTypeVerb%
]]></Property>
	</QueryDescriptor>

</Metric>

<!--
  <Metric NAME="css_nodes" TYPE="TABLE" IS_METRIC_LONG_RUNNING="TRUE" KEYS_FROM_MULT_COLLS="TRUE" >

<Display>
        <Label NLSID="css_nodes">Clusterware Server</Label>
      </Display>
      <TableDescriptor>

<ColumnDescriptor NAME="css_software_version" TYPE="STRING" IS_KEY="FALSE">
          <Display>
            <Label NLSID="css_software_version">Software Version</Label>
          </Display>
         </ColumnDescriptor>

<ColumnDescriptor NAME="crs_server_state" TYPE="STRING" IS_KEY="FALSE">
          <Display>
            <Label NLSID="crs_server_state">Server State</Label>
          </Display>
         </ColumnDescriptor>

<ColumnDescriptor NAME="css_node_state" TYPE="STRING" IS_KEY="FALSE">
          <Display>
            <Label NLSID="css_node_state">Node State</Label>
          </Display>
         </ColumnDescriptor>

</TableDescriptor>
     <PushDescriptor  RECVLET_ID="CRSeOns">
      <Property NAME="eonsPort" SCOPE="INSTANCE" OPTIONAL="TRUE">eonsPort</Property>
      <Property NAME="eonsPort_dynamic" SCOPE="INSTANCE" OPTIONAL="TRUE">eonsPort_dynamic</Property>
      <Property NAME="eonsPort_static" SCOPE="USER" OPTIONAL="TRUE">eonsPort_static</Property>
      <Property NAME="eonsEventType" SCOPE="GLOBAL" OPTIONAL="TRUE"><![CDATA[CRS_SERVER_STATE_CHANGE,CRS_NODE_STATE_CHANGE]]></Property>
      <Property NAME="TriggerCollection" SCOPE="GLOBAL" OPTIONAL="TRUE">none</Property>
      <Property NAME="skipIdInKey" SCOPE="GLOBAL" OPTIONAL="TRUE"><![CDATA[YES]]></Property>
      <Property NAME="skipEventInKey" SCOPE="GLOBAL" OPTIONAL="TRUE"><![CDATA[YES]]></Property>
      <Property NAME="sendMetricRow" SCOPE="GLOBAL" OPTIONAL="TRUE"><![CDATA[YES]]></Property>
      <Property NAME="skipEntityTypeInKey" SCOPE="GLOBAL" OPTIONAL="TRUE"><![CDATA[YES]]></Property>
      <Property NAME="skipEntitySubTypeInKey" SCOPE="GLOBAL" OPTIONAL="TRUE"><![CDATA[YES]]></Property>
      <Property NAME="skipTimestampInKey" SCOPE="GLOBAL" OPTIONAL="TRUE"><![CDATA[YES]]></Property>
      <Property NAME="eventGeneratingComponent" SCOPE="GLOBAL" OPTIONAL="TRUE"><![CDATA[ORACLE_CLUSTERWARE]]></Property>
      <Property NAME="disableEonsRcvlet" SCOPE="SYSTEMGLOBAL">disableEonsRcvlet</Property>
     </PushDescriptor>

</Metric>

-->

<Metric NAME="cluster_health_check" TYPE="TABLE" IS_METRIC_LONG_RUNNING="TRUE" >

<Display>
        <Label NLSID="cluster_health_check">Clusterware Component Health Check</Label>
      </Display>
      <TableDescriptor>

<ColumnDescriptor NAME="cluster_health_check_component" TYPE="STRING" IS_KEY="FALSE">
          <Display>
            <Label NLSID="cluster_health_check_component">Component Name</Label>
          </Display>
         </ColumnDescriptor>

<ColumnDescriptor NAME="cluster_health_check_comp_description" TYPE="STRING" IS_KEY="FALSE">
          <Display>
            <Label NLSID="cluster_health_check_comp_description">Component Description</Label>
          </Display>
         </ColumnDescriptor>

<ColumnDescriptor NAME="cluster_health_check_status" TYPE="STRING" IS_KEY="FALSE">
          <Display>
            <Label NLSID="cluster_health_check_status">Component State</Label>
          </Display>
         </ColumnDescriptor>

<ColumnDescriptor NAME="cluster_health_check_status_mesg" TYPE="STRING" IS_KEY="FALSE">
          <Display>
            <Label NLSID="cluster_health_check_status_mesg">Component State Description</Label>
          </Display>
         </ColumnDescriptor>

<ColumnDescriptor NAME="cluster_health_check_node" TYPE="STRING" IS_KEY="FALSE">
          <Display>
            <Label NLSID="cluster_health_check_node">Scope</Label>
          </Display>
         </ColumnDescriptor>

<ColumnDescriptor NAME="cluster_health_check_message" TYPE="STRING" IS_KEY="FALSE" IS_LONG_TEXT="TRUE">
          <Display>
            <Label NLSID="cluster_health_check_message">Error Message</Label>
          </Display>
         </ColumnDescriptor>

</TableDescriptor>

</Metric>

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de