{"id":3964,"date":"2014-09-12T02:42:00","date_gmt":"2014-09-12T00:42:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/oracle-oem-cloud-control-12104-awr-warehouse\/"},"modified":"2014-09-12T02:42:00","modified_gmt":"2014-09-12T00:42:00","slug":"oracle-oem-cloud-control-12104-awr-warehouse","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/oracle-oem-cloud-control-12104-awr-warehouse\/","title":{"rendered":"Oracle OEM Cloud Control 12.1.0.4 &#8211; AWR Warehouse"},"content":{"rendered":"<p>This post explains how to configure and use the new AWR warehouse functionality present in Enterprise Manager Cloud Control 12.1.0.4. This new feature offers the possibility to store date from the AWR of your main databases in the EM AWR warehouse.<\/p>\n<p>As OEM AWR warehouse automatically extracts the AWR data of the database you have selected, there is no impact on your production databases. The main advantage is that it allows to keep AWR historical data beyond the retention period of the target databases. Another benefit is a performance improvement and a space gain of the target databases because AWR data are uploaded in a centralized AWR warehouse.<\/p>\n<p>We have to apply a patch to get the AWR warehouse functionality available in the menu Database Performance. For Linux x86-64, you have to apply the patch 19176910 which contains the EM DB plugin bundle patch 12.1.0.6.2. Before applying of the patch the screen appears as follows:<\/p>\n<p>&nbsp;<\/p>\n<p class=\"dbiNormal\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/aw1.png\" alt=\"aw1\" width=\"289\" height=\"149\" \/><\/p>\n<p class=\"dbiNormal\">\n<p>We have to use the latest Opatchversion available for\u00a011.1 release.<\/p>\n<p>Watch out OPatch 11.2.0.x.0 version is not supported with Oracle Management Service (OMS) 12.1.0.3 and 12.1.0.4<\/p>\n<p>&nbsp;<\/p>\n<p><code><a href=\"mailto:oracle@vmtestoraem12c:\/u01\/app\/oracle\/MiddleWare_12cR4\/oms\/OPatch\/\">oracle@vmtestoraem12c:\/u01\/app\/oracle\/MiddleWare_12cR4\/oms\/OPatch\/<\/a> [oms12c] opatch version<\/code><code><\/code><\/p>\n<p><code>OPatch Version: 11.1.0.11.0<\/code><\/p>\n<p><code><\/code><code>OPatch succeeded.<\/code><\/p>\n<p>&nbsp;<\/p>\n<p>Then we can run:<\/p>\n<p>&nbsp;<\/p>\n<p><a href=\"mailto:oracle@vmtestoraem12c:\/home\/oracle\/19176910\/\">oracle@vmtestoraem12c:\/home\/oracle\/19176910\/<\/a> [oms12c] opatchauto apply -analyze<\/p>\n<p>OPatch Automation Tool<\/p>\n<p>Copyright (c) 2014, Oracle Corporation. All rights reserved.<\/p>\n<p>OPatchauto version : 11.1.0.11.0<\/p>\n<p>OUI version\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : 11.1.0.12.0<\/p>\n<p>Running from\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 : \/u01\/app\/oracle\/MiddleWare_12cR4\/oms<\/p>\n<p>Log file location : \/u01\/app\/oracle\/MiddleWare_12cR4\/oms\/cfgtoollogs\/opatch\/opatch2014-08-25_16-45-18PM_1.log<\/p>\n<p>OPatchauto log file: \/u01\/app\/oracle\/MiddleWare_12cR4\/oms\/cfgtoollogs\/opatchauto\/19176910\/opatch_oms_2014-08-25_16-45-20PM_analyze.log<\/p>\n<p>[Aug 25, 2014 4:46:33 PM]\u00a0\u00a0 Prerequisites analysis summary:<\/p>\n<p>&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;&#8212;-<\/p>\n<p>The following sub-patch(es) are applicable:<\/p>\n<p>oracle_sysman_db91:19051532<\/p>\n<p>oracle_sysman_vt91:19060193<\/p>\n<p>oracle_sysman_mos91:18873245<\/p>\n<p>oracle_sysman_emas91:19051543<\/p>\n<p>oracle_sysman_ssa91:19051528<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-size: 9.5pt;\">\u00a0<\/span><\/p>\n<p>We can check if any patches are installed in the OMS:<\/p>\n<p><span style=\"font-size: 9.5pt;\">\u00a0<\/span><\/p>\n<p><a href=\"mailto:oracle@vmtestoraem12c:\/home\/oracle\/19176910\/\">oracle@vmtestoraem12c:\/home\/oracle\/19176910\/<\/a> [oms12c] opatchauto lspatches<\/p>\n<p>OPatch Automation Tool<\/p>\n<p>Copyright (c) 2014, Oracle Corporation. All rights reserved.<\/p>\n<p>There are no patches installed in the OMS system.<\/p>\n<p class=\"dbiNormal\">\n<p>Then we stop the OMS:<\/p>\n<p>&nbsp;<\/p>\n<p class=\"dbiNormal\"><a href=\"mailto:oracle@vmtestoraem12c:\/home\/oracle\/19176910\/\">oracle@vmtestoraem12c:\/home\/oracle\/19176910\/<\/a> [oms12c] emctl stop oms<\/p>\n<p class=\"dbiNormal\">Oracle Enterprise Manager Cloud Control 12c Release 4<\/p>\n<p class=\"dbiNormal\">Copyright (c) 1996, 2014 Oracle Corporation. All rights reserved.<\/p>\n<p class=\"dbiNormal\">Stopping WebTier&#8230;<\/p>\n<p class=\"dbiNormal\">WebTier Successfully Stopped<\/p>\n<p class=\"dbiNormal\">Stopping Oracle Management Server&#8230;<\/p>\n<p class=\"dbiNormal\">Oracle Management Server Successfully Stopped<\/p>\n<p class=\"dbiNormal\">Oracle Management Server is Down<\/p>\n<p class=\"dbiNormal\">\n<p>Then we run under the patch directory : opatchauto apply<\/p>\n<p>Once the patch is applied you can start the oms with the classical command : emctl start oms<\/p>\n<p>Finally we have the AWR warehouse menu:<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"font-size: 9.5pt;\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/aw2.png\" alt=\"aw2\" width=\"281\" height=\"156\" \/><\/span><\/p>\n<p><span style=\"font-size: 9.5pt;\">\u00a0<\/span><\/p>\n<p>We have first to configure the AWR warehouse repository:<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/aw3.png\" alt=\"aw3\" width=\"495\" height=\"311\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>You select the configure button:<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/aw4.png\" alt=\"aw4\" width=\"495\" height=\"311\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>You enter the database and host credentials:<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/aw4.png\" alt=\"aw4\" width=\"359\" height=\"288\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>You configure the snapshot management for a one year retention period, you can also define the snapshot upload interval from 1 hour to 24 hours:<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/aw6.png\" alt=\"aw6\" width=\"506\" height=\"269\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>The caw_load_setup job_%id is successful.<\/p>\n<p>Now we have access to the AWR warehouse screen where we can add databases:<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/aw7.png\" alt=\"aw7\" width=\"605\" height=\"193\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>When you select add, you have to define preferred credentials to the database you add and add some grants:<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/aw8.png\" alt=\"aw8\" width=\"605\" height=\"96\" \/><\/p>\n<p class=\"dbiNormal\">\n<p>We have to allocate the execute privilege on dbms_swrf_internal to system:<\/p>\n<p class=\"dbiNormal\">\n<p><code class=\"dbiNormal\">SYS&gt; grant execute on sys.dbms_swrf_internal to system;<\/code><\/p>\n<p><code class=\"dbiNormal\"><\/code><code class=\"dbiNormal\">Grant succeeded.<\/code><\/p>\n<p><span style=\"font-size: 9.5pt; font-family: 'DIN Offc','sans-serif';\">\u00a0<\/span><\/p>\n<p>For the NMO error, I forgot to run the root.sh agent 12c script:<\/p>\n<p><span style=\"font-size: 9.5pt; font-family: 'DIN Offc','sans-serif';\">\u00a0<\/span><\/p>\n<p><code class=\"dbiNormal\">[<a href=\"mailto:root@vmtestoradg1 ~\">root@vmtestoradg1 ~<\/a>]# cd \/u00\/app\/oracle\/agent12c\/core\/12.1.0.4.0<\/code><\/p>\n<p><code class=\"dbiNormal\"><\/code><code class=\"dbiNormal\">[<a href=\"mailto:root@vmtestoradg1\">root@vmtestoradg1<\/a> 12.1.0.4.0]# .\/root.sh<\/code><code class=\"dbiNormal\"><\/code><\/p>\n<p><code class=\"dbiNormal\">Finished product-specific root actions.<\/code><\/p>\n<p><code class=\"dbiNormal\"><\/code><code class=\"dbiNormal\">\/etc exist<\/code><\/p>\n<p>&nbsp;<\/p>\n<p>Finally the databases are added:<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/aw9.png\" alt=\"aw9\" width=\"605\" height=\"273\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>We have to grant the access to the databases added, we select a target database and we choose Privileges:<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/aw10.png\" alt=\"aw10\" width=\"314\" height=\"102\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>We select the sysman administrator account:<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/aw11.png\" alt=\"aw11\" width=\"225\" height=\"259\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>As we have configured the snapshot upload interval to 24 hours, we will have data every day:<\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/aw12.png\" alt=\"aw12\" width=\"591\" height=\"160\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>From this dashboard you can make ADDM comparaisons, view ADDM reports, ASH analytics or directly go to the performance page of the database you have selected.<\/p>\n<p>The AWR warehouse feature requires the diagnostic pack license; This new feature seems very interesting due to the central and consolidated AWR warehouse. I will test this exciting feature deeper in the next weeks.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This post explains how to configure and use the new AWR warehouse functionality present in Enterprise Manager Cloud Control 12.1.0.4. This new feature offers the possibility to store date from the AWR of your main databases in the EM AWR warehouse. As OEM AWR warehouse automatically extracts the AWR data of the database you have [&hellip;]<\/p>\n","protected":false},"author":27,"featured_media":3965,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[198],"tags":[209,218],"type_dbi":[],"class_list":["post-3964","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database-management","tag-oracle-12c","tag-oracle-enterprise-manager-cloud-12c"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.2 (Yoast SEO v27.2) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Oracle OEM Cloud Control 12.1.0.4 - AWR Warehouse - dbi Blog<\/title>\n<meta name=\"description\" content=\"This post explains how to configure and use the new AWR warehouse functionality present in Enterprise Manager Cloud Control 12.1.0.4. This new feature offers the possibility to store date from the AWR of your main databases in the EM AWR warehouse.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/oracle-oem-cloud-control-12104-awr-warehouse\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Oracle OEM Cloud Control 12.1.0.4 - AWR Warehouse\" \/>\n<meta property=\"og:description\" content=\"This post explains how to configure and use the new AWR warehouse functionality present in Enterprise Manager Cloud Control 12.1.0.4. This new feature offers the possibility to store date from the AWR of your main databases in the EM AWR warehouse.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/oracle-oem-cloud-control-12104-awr-warehouse\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2014-09-12T00:42:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/aw1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"289\" \/>\n\t<meta property=\"og:image:height\" content=\"149\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Oracle Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Oracle Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-oem-cloud-control-12104-awr-warehouse\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-oem-cloud-control-12104-awr-warehouse\/\"},\"author\":{\"name\":\"Oracle Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"headline\":\"Oracle OEM Cloud Control 12.1.0.4 &#8211; AWR Warehouse\",\"datePublished\":\"2014-09-12T00:42:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-oem-cloud-control-12104-awr-warehouse\/\"},\"wordCount\":651,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-oem-cloud-control-12104-awr-warehouse\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/aw1.png\",\"keywords\":[\"Oracle 12c\",\"Oracle Enterprise Manager Cloud 12c\"],\"articleSection\":[\"Database management\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-oem-cloud-control-12104-awr-warehouse\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-oem-cloud-control-12104-awr-warehouse\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/oracle-oem-cloud-control-12104-awr-warehouse\/\",\"name\":\"Oracle OEM Cloud Control 12.1.0.4 - AWR Warehouse - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-oem-cloud-control-12104-awr-warehouse\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-oem-cloud-control-12104-awr-warehouse\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/aw1.png\",\"datePublished\":\"2014-09-12T00:42:00+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\"},\"description\":\"This post explains how to configure and use the new AWR warehouse functionality present in Enterprise Manager Cloud Control 12.1.0.4. This new feature offers the possibility to store date from the AWR of your main databases in the EM AWR warehouse.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-oem-cloud-control-12104-awr-warehouse\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/oracle-oem-cloud-control-12104-awr-warehouse\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-oem-cloud-control-12104-awr-warehouse\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/aw1.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/aw1.png\",\"width\":289,\"height\":149},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/oracle-oem-cloud-control-12104-awr-warehouse\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle OEM Cloud Control 12.1.0.4 &#8211; AWR Warehouse\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee\",\"name\":\"Oracle Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g\",\"caption\":\"Oracle Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Oracle OEM Cloud Control 12.1.0.4 - AWR Warehouse - dbi Blog","description":"This post explains how to configure and use the new AWR warehouse functionality present in Enterprise Manager Cloud Control 12.1.0.4. This new feature offers the possibility to store date from the AWR of your main databases in the EM AWR warehouse.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/oracle-oem-cloud-control-12104-awr-warehouse\/","og_locale":"en_US","og_type":"article","og_title":"Oracle OEM Cloud Control 12.1.0.4 - AWR Warehouse","og_description":"This post explains how to configure and use the new AWR warehouse functionality present in Enterprise Manager Cloud Control 12.1.0.4. This new feature offers the possibility to store date from the AWR of your main databases in the EM AWR warehouse.","og_url":"https:\/\/www.dbi-services.com\/blog\/oracle-oem-cloud-control-12104-awr-warehouse\/","og_site_name":"dbi Blog","article_published_time":"2014-09-12T00:42:00+00:00","og_image":[{"width":289,"height":149,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/aw1.png","type":"image\/png"}],"author":"Oracle Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Oracle Team","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-oem-cloud-control-12104-awr-warehouse\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-oem-cloud-control-12104-awr-warehouse\/"},"author":{"name":"Oracle Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"headline":"Oracle OEM Cloud Control 12.1.0.4 &#8211; AWR Warehouse","datePublished":"2014-09-12T00:42:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-oem-cloud-control-12104-awr-warehouse\/"},"wordCount":651,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-oem-cloud-control-12104-awr-warehouse\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/aw1.png","keywords":["Oracle 12c","Oracle Enterprise Manager Cloud 12c"],"articleSection":["Database management"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/oracle-oem-cloud-control-12104-awr-warehouse\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-oem-cloud-control-12104-awr-warehouse\/","url":"https:\/\/www.dbi-services.com\/blog\/oracle-oem-cloud-control-12104-awr-warehouse\/","name":"Oracle OEM Cloud Control 12.1.0.4 - AWR Warehouse - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-oem-cloud-control-12104-awr-warehouse\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-oem-cloud-control-12104-awr-warehouse\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/aw1.png","datePublished":"2014-09-12T00:42:00+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee"},"description":"This post explains how to configure and use the new AWR warehouse functionality present in Enterprise Manager Cloud Control 12.1.0.4. This new feature offers the possibility to store date from the AWR of your main databases in the EM AWR warehouse.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/oracle-oem-cloud-control-12104-awr-warehouse\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/oracle-oem-cloud-control-12104-awr-warehouse\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-oem-cloud-control-12104-awr-warehouse\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/aw1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2022\/04\/aw1.png","width":289,"height":149},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/oracle-oem-cloud-control-12104-awr-warehouse\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Oracle OEM Cloud Control 12.1.0.4 &#8211; AWR Warehouse"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/66ab87129f2d357f09971bc7936a77ee","name":"Oracle Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f711f7cd2c9b09bf2627133755b569fb5be0694810cfd33033bdd095fedba86d?s=96&d=mm&r=g","caption":"Oracle Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/oracle-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/3964","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/27"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=3964"}],"version-history":[{"count":0,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/3964\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media\/3965"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=3964"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=3964"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=3964"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=3964"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}