OEM templates export and import carried out majorly in the OEM Server Migration from one platform to another platform or DC Migrations.
To have the same monitoring templates in target, the practice is to export the templates from the source server and import into the target server.
Login to OEM CLI console
$ emcli login -username=SYSMAN
Enter password :
Login successful
oemhost-oracle-EM12REPP:/home/oracle
List the Templates
$ emcli list_templates
Template Name Display Name Target Type Oracle Certified Default Template
DB:MON DB:MON oracle_database yes
EXA_CLUSTER_MON EXA_CLUSTER_MON rac_database
EXA_DB_MON EXA_DB_MON oracle_database
EXA_HOST_MON EXA_HOST_MON host
HST:MON HST:MON host yes
LSN_MON LSN_MON oracle_listener yes
ckpt Oracle Coherence Node ckpt Oracle Coherence Node oracle_coherence_node
ckpt Prod Coherence Cluster ckpt Prod Coherence Cluster oracle_coherence
Oracle Certified - Default thresholds for Streams/XStream/GG RAC Oracle Certified - Default thresholds for Streams/XStream/GG RAC rac_database yes
Oracle Certified - Default thresholds for Streams/XStream/GG Oracle Certified - Default thresholds for Streams/XStream/GGt oracle_database yes
Oracle Certified - Disable AQ Metrics for RAC Database Oracle Certified - Disable AQ Metrics for RAC Database rac_database yes
Oracle Certified - Disable AQ Metrics for SI Database Oracle Certified - Disable AQ Metrics for SI Database oracle_database yes
Oracle Certified - Disable Database Usage Tracking Metrics Oracle Certified - Disable Database Usage Tracking Metrics oracle_database yes
Oracle Certified - Disable Solaris Host Virtualization metrics Oracle Certified - Disable Solaris Host Virtualization metrics host yes
Oracle Certified - Disable Streams/XStream/GG Metrics Oracle Certified - Disable Streams/XStream/GG Metrics oracle_database yes
Oracle Certified - Disable Streams/XStream/GG Metrics for RAC Oracle Certified - Disable Streams/XStream/GG Metrics for RAC rac_database yes
Oracle Certified - Enable AQ Metrics for RAC Database Oracle Certified - Enable AQ Metrics for RAC Database rac_database yes
Oracle Certified - Enable AQ Metrics for SI Database Oracle Certified - Enable AQ Metrics for SI Database oracle_database yes
Oracle Certified - Enable DB Usage Tracking Hourly Metrics Oracle Certified - Enable Database Usage Tracking Hourly Metrics oracle_database yes
Oracle Certified - Enable Database Usage Tracking Weekly Metrics Oracle Certified - Enable Database Usage Tracking Weekly Metrics oracle_database yes
Oracle Certified - Enable Solaris Host Virtualization metrics Oracle Certified - Enable Solaris Host Virtualization metrics host yes
Oracle Certified - Enable Streams/XStream/GG Metrics Oracle Certified - Enable Streams/XStream/GG Metrics oracle_database yes
Oracle Certified - Enable Streams/XStream/GG Metrics for RAC Oracle Certified - Enable Streams/XStream/GG Metrics for RAC rac_database yes
Oracle Certified FMW Base Template for Weblogic Domain Oracle Certified FMW Base Template for Weblogic Domain weblogic_domain yes
Oracle Certified FMW Base Template for Weblogic Server Oracle Certified FMW Base Template for Weblogic Server weblogic_j2eeserver yes
Oracle Certified FMW Template for Host Oracle Certified FMW Template for Host host yes
Oracle Certified FMW Template for SOA Composite Oracle Certified FMW Template for SOA Composite oracle_soa_composite yes
Oracle Certified FMW Template for SOA Infrastructure Oracle Certified FMW Template for SOA Infrastructure oracle_soainfra yes
Oracle Certified FMW WS Template for Application Deployment Oracle Certified FMW Web Service Template for J2EE Application j2ee_application yes
Oracle Certified FMW Base Template for Application Deployment Oracle Certified Fusion Apps / FMW Template for JEE App j2ee_application yes
Oracle Certified Fusion Apps Template for Weblogic Server Oracle Certified Fusion Apps / FMW Template for WebLogic Server weblogic_j2eeserver yes
Oracle Certified Fusion Apps Template for Host Oracle Certified Fusion Apps Template for Host host yes
Oracle Certified Fusion Apps Template for JEE App Oracle Certified Fusion Apps Template for JEE App j2ee_application yes
Oracle Certified Fusion Apps Template for SOA Composite Oracle Certified Fusion Apps Template for SOA Composite oracle_soa_composite yes
Oracle Certified Fusion Apps Template for SOA Infrastructure Oracle Certified Fusion Apps Template for SOA Infrastructure oracle_soainfra yes
Oracle Certified FMW Base Template for Weblogic Cluster Oracle Certified Fusion Apps Template for Weblogic Cluster weblogic_cluster yes
Oracle Certified MDA Template for Weblogic Server Oracle Certified MDA Template for Weblogic Server weblogic_j2eeserver yes
Oracle Certified Template for Agent targets Oracle Certified Template for Agent targets oracle_emd yes
Oracle Certified Template for Directory Integration Platform Oracle Certified Template for Directory Integration Platform oracle_eps_server yes yes
Oracle Certified Template for Host targets Oracle Certified Template for Host targets host yes
Oracle Certified FMW JMS Metrics Template for Weblogic Server Oracle Certified Template for JMS Metrics for Weblogic Server weblogic_j2eeserver yes
Oracle Certified FMW JTA Template for Weblogic Server Oracle Certified Template for JTA Metrics for Weblogic Server weblogic_j2eeserver yes
Oracle Certified Template for Oracle Access Management Oracle Certified Template for Oracle Access Management oracle_oam yes yes
Oracle Certified Template for Oracle Adaptive Access Manager Oracle Certified Template for Oracle Adaptive Access Manager oracle_oaam yes yes
Oracle Certified Template for Oracle Identity Federation Oracle Certified Template for Oracle Identity Federation oracle_federation yes yes
Oracle Certified Template for Oracle Identity Manager Oracle Certified Template for Oracle Identity Manager oracle_oim yes yes
Oracle Certified Template for Oracle Internet Directory Oracle Certified Template for Oracle Internet Directory oracle_ldap yes yes
Oracle Certified Template for Oracle Virtual Directory Oracle Certified Template for Oracle Virtual Directory oracle_ovd yes yes
Oracle Certified Template for SAN metrics - Disable Oracle Certified Template for SAN metrics - Disable host yes
Oracle Certified Template for SAN metrics - Enable Oracle Certified Template for SAN metrics - Enable host yes
Oracle Certified Template for Target Discovery - Disabled Oracle Certified Template for Target Discovery - Disabled host yes
Oracle Certified Template for Target Discovery - Every 14 Days Oracle Certified Template for Target Discovery - Every 14 Days host yes
Oracle Certified Template for Target Discovery - Every 7 Days Oracle Certified Template for Target Discovery - Every 7 Days host yes
Oracle Certified Template to Enable Weblogic Cluster Metrics Oracle Certified Template to Enable Weblogic Cluster Metrics weblogic_cluster yes
Oracle Certified-Disable Database Security Configuration Metrics Oracle Certified-Disable Database Security Configuration Metrics oracle_database yes
Oracle Certified-Disable Listener Security Configuration Metrics Oracle Certified-Disable Listener Security Configuration Metrics oracle_listener yes
Oracle Certified-Disable RAC Security Configuration Metrics Oracle Certified-Disable RAC Security Configuration Metrics rac_database yes
Oracle Certified-Enable Database Security Configuration Metrics Oracle Certified-Enable Database Security Configuration Metrics oracle_database yes
Oracle Certified-Enable Listener Security Configuration Metrics Oracle Certified-Enable Listener Security Configuration Metrics oracle_listener yes
Oracle Certified-Enable RAC Security Configuration Metrics Oracle Certified-Enable RAC Security Configuration Metrics rac_database yes
Oracle Certified: Disable Database Storage Configuration Metrics Oracle Certified: Disable Database Storage Configuration Metrics oracle_database yes
Oracle Certified: Enable Database Storage Configuration Metrics Oracle Certified: Enable Database Storage Configuration Metrics oracle_database yes
DisablePDBaaSRacCollectionsTemplate Oracle Certified:Disable Cluster Database PDBaaS Collection rac_database yes
DisableDBServiceRacCollectionsTemplate Oracle Certified:Disable Cluster Database Service Collection rac_database yes
DisableDBServiceCollectionsTemplate Oracle Certified:Disable Database Service Collection oracle_database yes
DisablePDBaaSCollectionsTemplate Oracle Certified:Disable PDBaaS Collection oracle_database yes
EnablePDBaaSRacCollectionsTemplate Oracle Certified:Enable Cluster Database PDBaaS Collection rac_database yes
EnableDBServiceRacCollectionsTemplate Oracle Certified:Enable Cluster Database Service Collection rac_database yes
EnableDBServiceCollectionsTemplate Oracle Certified:Enable Database Service Collection oracle_database yes
EnablePDBaaSCollectionsTemplate Oracle Certified:Enable PDBaaS Collection oracle_database yes
Oracle Coherence Cache - Basic High Frequency Template Oracle Coherence Cache - Basic High Frequency Template oracle_coherence_cache yes
Oracle Coherence Cache - Basic Low Frequency Template Oracle Coherence Cache - Basic Low Frequency Template oracle_coherence_cache yes
Oracle Coherence Cluster - Basic High Frequency Template Oracle Coherence Cluster - Basic High Frequency Template oracle_coherence yes
Oracle Coherence Cluster - Basic Low Frequency Template Oracle Coherence Cluster - Basic Low Frequency Template oracle_coherence yes
Oracle Coherence Node - Basic High Frequency Template Oracle Coherence Node - Basic High Frequency Template oracle_coherence_node yes
Oracle Coherence Node - Basic Low Frequency Template Oracle Coherence Node - Basic Low Frequency Template oracle_coherence_node yes
Target Discovery Schedule for INTERNAL USE ONLY Target Discovery Schedule for INTERNAL USE ONLY host
oemhost-oracle-EM12REPP:/home/oracle
$Export the template using emcli
$ emcli export_template -name=DB:MON -target_type=oracle_database -output_file=/backup/dbmon.xml
File(s) exported successfully.
oemhost-oracle-EM12REPP:/home/oracle
$ ls -ltr /backup/dbmon.xml
-rw-r--r-- 1 oracle dba 265893 Nov 14 08:08 /backup/dbmon.xml
oemhost-oracle-EM12REPP:/home/oracle
$ emcli export_template -name=DB:MON -target_type=oracle_database -output_file=/backup/dbmon.tmp
File /backup/dbmon.tmp is not an xml file. Please specify an xml file.
oemhost-oracle-EM12REPP:/home/oracle
$ emcli export_template -name=DB:MON -target_type=oracle_database -output_file=/backup/dbmon.xml
File(s) exported successfully.
oemhost-oracle-EM12REPP:/home/oracle
$ ls -ltr /backup/dbmon.xml
-rw-r--r-- 1 oracle dba 265893 Nov 14 08:08 /backup/dbmon.xml
oemhost-oracle-EM12REPP:/home/oracle
$ emcli export_template -name=EXA_CLUSTER_MON -target_type=rac_database -output_file=/backup/EXA_CLUSTER_MON.xml
File(s) exported successfully.
oemhost-oracle-EM12REPP:/home/oracle
$ emcli export_template -name=EXA_DB_MON -target_type=oracle_database -output_file=/backup/EXA_DB_MON.xml
File(s) exported successfully.
oemhost-oracle-EM12REPP:/home/oracle
$ emcli export_template -name=EXA_HOST_MON -target_type=host -output_file=/backup/EXA_HOST_MON.xml
File(s) exported successfully.
oemhost-oracle-EM12REPP:/home/oracle
$ emcli export_template -name=HST:MON -target_type=host -output_file=/backup/HSTMON.xml
File(s) exported successfully.
oemhost-oracle-EM12REPP:/home/oracle
$ emcli export_template -name=LSN_MON -target_type=oracle_listener -output_file=/backup/LSN_MON.xml
File(s) exported successfully.
oemhost-oracle-EM12REPP:/home/oracle
$ emcli export_template -name=ckpt Oracle Coherence Node -target_type=oracle_coherence_node -output_file=/backup/ORACoherencecluster.xml
Syntax Error: Too many positional arguments
-- "Oracle" "Coherence" "Node"
oemhost-oracle-EM12REPP:/home/oracle
$ emcli export_template -name="ckpt Oracle Coherence Node" -target_type=oracle_coherence_node -output_file=/backup/ORACoherencecluster.xml
File(s) exported successfully.
oemhost-oracle-EM12REPP:/home/oracle
$ emcli export_template -name="ckpt Prod Coherence Cluster" -target_type=oracle_coherence -output_file=/backup/ORAPRODCoherencecluster.xml
File(s) exported successfully.
oemhost-oracle-EM12REPP:/home/oracle
$The Generated XML files we have to SCP to target server and import into the new migrated OEM server.
