Tuesday, July 24, 2012

Export Transfer Monitor Template Between OMSs


Requirements
To be able to export a monitoring template from an Oracle Enterprise Manager Repository so that it can be imported into another OEM Repository the Enterprise Manager Command Line Utility (emcli) must be installed and operational.

Steps

1.       Templates Available for Export, name must match exactly as indicated in OEM.
You can see a list via OEM Console or you can query the OEM repository database. 

Example:

SQL> SELECT TEMPLATE_NAME,TARGET_TYPE FROM MGMT_TEMPLATES;

TEMPLATE_NAME
----------------------------------------------------------------
TARGET_TYPE
----------------------------------------------------------------
Listner
oracle_listener

Prod DEV and TEST Databases
oracle_database

Production
oracle_database

Project Database Hosts
host

CPE Databases
oracle_database

2.       Select the template you want to extract and put into another OEM environment.

3.       Export the Template you want to put in the other OEM environment using the emcli utility.

Examples:

emcli export_template -name="Listner" -target_type=oracle_listener -output_file=/home/oracle/templates/Listener.template

emcli export_template -name='Prod DEV and TEST Databases' -target_type=oracle_database -output_file=/home/oracle/templates/prod_dev_and_test_databases.template

emcli export_template -name='Production' -target_type=oracle_database -output_file=/home/oracle/templates/Production.template

emcli export_template -name='Project Database Hosts' -target_type=host -output_file=/home/oracle/templates/Project_Database_hosts.template

emcli export_template -name='CPE Databases' -target_type=oracle_database -output_file=/home/oracle/templates/CPE_Databases.template

4.       Transfer the file created by the export of the template to the new OEM environment

5.       Import the template into the new OEM environment. 

Example:

emcli import_template -files="Listener.template;prod_dev_and_test_databases.template;Production.template;Project_Database_hosts.template;CPE_Databases.template"

No comments: