How to copy User-Defined Metrics (Two-Columns) to another target

It is not possible to copy UDMs in Grid Control 10.2 between two targets in the case that UDM is Two-Columns type. In this doc I will provide information of how to perform this in 4 minutes. For example I will take two databases already defined on Grid Control: the source database is M300 and the target is SVTN.

All the above is workable ONLY in the case that them are being monitored via the same user. For example: dbsnmp

1.      Define some Two-Column Type UDMs in M300 database.

2.      Go to the following directory (on M300 server)$AGENT_HOME\sysman\emd\collection and find oracle_database_M300.EVEN.xml file.

3.      Go to the following directory (on SVTN server)$AGENT_HOME\sysman\emd\collection and rename oracle_database_SVTN.EVEN.xml file to oracle_database_SVTN.EVEN.xml.old

4.      Copy oracle_database_M300.EVEN.xml from M300 server to SVTN server to appropriate directory and rename it to oracle_database_SVTN.EVEN.xml

5.     Open oracle_database_SVTN.EVEN.xml file and change the following section
<TargetCollection TYPE="oracle_database" NAME="M300.EVEN">
to the new one
<TargetCollection TYPE="oracle_database" NAME="SVTN.EVEN">

6.      Overwrite the following sections (there should be several). If you would like to disable encryption, cut off ENCRYPTED="TRUE" part from ItemProperty tag.

<ItemProperty NAME="UserName" ENCRYPTED="TRUE">dd50eab99a50ItemProperty>

Or

<ItemProperty NAME="UserName">dbsnmpItemProperty>

<ItemProperty NAME="password" ENCRYPTED="TRUE">cdc9d76ac66e7ItemProperty>
with the appropriate section(s) from $AGENT_HOME\sysman\emd\targets.xml file.

7.      Restart SVTN agent service.