{"id":80,"date":"2015-11-21T07:58:30","date_gmt":"2015-11-21T13:58:30","guid":{"rendered":"http:\/\/www.aamirharoon.com\/?p=80"},"modified":"2015-11-21T07:58:30","modified_gmt":"2015-11-21T13:58:30","slug":"important-steps-before-upgrading-omr-database-to-12c-pdb","status":"publish","type":"post","link":"http:\/\/www.aamirharoon.com\/?p=80","title":{"rendered":"Important Steps Before Upgrading OMR database to 12c PDB"},"content":{"rendered":"<p>Here are some important steps that needs to be done before you upgrade Oracle Managed Repository (OMR) database to 12c PDB.<\/p>\n<p>First you have to change connect descriptor for Oracle Managed Service (OMS) to SERVICE_NAME instead of SID. \u00a0Run the following command to get the connect descriptor that OMS uses to connect to OMR database:<\/p>\n<pre class=\"c\" data-blogger-escaped-name=\"code\"><span style=\"color: #0000ff;\">emctl config oms -list_repos_details<\/span>\r\n\r\nOracle Enterprise Manager Cloud Control 12c Release 4\r\n\r\nCopyright (c) 1996, 2014 Oracle Corporation.\u00a0 All rights reserved.\r\n\r\nRepository Connect Descriptor : (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=omrhost.example.com)(PORT=1521)))(CONNECT_DATA=(<span style=\"color: #800000;\"><strong>SID=emrep<\/strong><\/span>)))\r\n\r\nRepository User : SYSMAN\r\n\r\n<\/pre>\n<p>Use the following command to change SID to SERVICE_NAME:<\/p>\n<pre class=\"c\" data-blogger-escaped-name=\"code\"><span style=\"color: #0000ff;\">emctl config oms -store_repos_details -repos_conndesc \"(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=omrhost.example.com)(PORT=1521)))(CONNECT_DATA=(<strong>SERVICE_NAME=emrep.example.com<\/strong>)))\" -repos_user SYSMAN -repos_pwd password<\/span>\r\n\r\nOracle Enterprise Manager Cloud Control 12c Release 4\r\nCopyright (c) 1996, 2014 Oracle Corporation.\u00a0 All rights reserved.\r\nSuccessfully updated datasources and stored repository details in Credential Store.\r\nIf there are multiple OMSs in this environment, run this store_repos_details command on all of them.\r\nAnd finally, restart all the OMSs using 'emctl stop oms -all' and 'emctl start oms'.\r\nIt is also necessary to restart the BI Publisher Managed Server.\r\n<\/pre>\n<p>Last step is to update\u00a0the Monitoring Configuration in OEM for &#8220;Management Services and Repository&#8221; target to SERVICE_NAME.<\/p>\n<p><a href=\"http:\/\/www.aamirharoon.com\/wp-content\/uploads\/2015\/11\/msr_mon_config1.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-82 size-full\" src=\"http:\/\/www.aamirharoon.com\/wp-content\/uploads\/2015\/11\/msr_mon_config1.png\" alt=\"msr_mon_config\" width=\"796\" height=\"400\" srcset=\"http:\/\/www.aamirharoon.com\/wp-content\/uploads\/2015\/11\/msr_mon_config1.png 796w, http:\/\/www.aamirharoon.com\/wp-content\/uploads\/2015\/11\/msr_mon_config1-300x151.png 300w\" sizes=\"auto, (max-width: 796px) 100vw, 796px\" \/><\/a><\/p>\n<p>Now you are ready to upgrade OMR database to 12c in CDB\/PDB format \ud83d\ude42<\/p>\n<p>If you don&#8217;t do the above\u00a0steps before upgrading OMR database to PDB then you&#8217;ll be in the same mess I was.<\/p>\n<p>Yes I made a mistake of not doing the above steps on my test environment but luckily knowledge of WebLogic got me out of the mess \ud83d\ude42<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Here are some important steps that needs to be done before you upgrade Oracle Managed Repository (OMR) database to 12c PDB. First you have to<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[14,21,23,22,20,25,26,24],"class_list":["post-80","post","type-post","status-publish","format-standard","hentry","category-oem-cc-12c","tag-12c","tag-12c-omr","tag-cdb","tag-oem-cloud-control","tag-omr-pdb","tag-oms","tag-oms-12c","tag-pdb"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Important Steps Before Upgrading OMR database to 12c PDB - The Database Handyman<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/www.aamirharoon.com\/?p=80\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Important Steps Before Upgrading OMR database to 12c PDB - The Database Handyman\" \/>\n<meta property=\"og:description\" content=\"Here are some important steps that needs to be done before you upgrade Oracle Managed Repository (OMR) database to 12c PDB. First you have to\" \/>\n<meta property=\"og:url\" content=\"http:\/\/www.aamirharoon.com\/?p=80\" \/>\n<meta property=\"og:site_name\" content=\"The Database Handyman\" \/>\n<meta property=\"article:published_time\" content=\"2015-11-21T13:58:30+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/www.aamirharoon.com\/wp-content\/uploads\/2015\/11\/msr_mon_config1.png\" \/>\n<meta name=\"author\" content=\"Aamir\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@aamir814\" \/>\n<meta name=\"twitter:site\" content=\"@aamir814\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Aamir\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\/\/www.aamirharoon.com\/?p=80#article\",\"isPartOf\":{\"@id\":\"http:\/\/www.aamirharoon.com\/?p=80\"},\"author\":{\"name\":\"Aamir\",\"@id\":\"http:\/\/www.aamirharoon.com\/#\/schema\/person\/dbcd256c4a97c6e27b7cc408200a9b63\"},\"headline\":\"Important Steps Before Upgrading OMR database to 12c PDB\",\"datePublished\":\"2015-11-21T13:58:30+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\/\/www.aamirharoon.com\/?p=80\"},\"wordCount\":159,\"commentCount\":0,\"publisher\":{\"@id\":\"http:\/\/www.aamirharoon.com\/#\/schema\/person\/dbcd256c4a97c6e27b7cc408200a9b63\"},\"image\":{\"@id\":\"http:\/\/www.aamirharoon.com\/?p=80#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.aamirharoon.com\/wp-content\/uploads\/2015\/11\/msr_mon_config1.png\",\"keywords\":[\"12c\",\"12c OMR\",\"CDB\",\"OEM Cloud Control\",\"OMR PDB\",\"OMS\",\"OMS 12c\",\"PDB\"],\"articleSection\":[\"OEM Cloud Control 12c\"],\"inLanguage\":\"en\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\/\/www.aamirharoon.com\/?p=80#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/www.aamirharoon.com\/?p=80\",\"url\":\"http:\/\/www.aamirharoon.com\/?p=80\",\"name\":\"Important Steps Before Upgrading OMR database to 12c PDB - The Database Handyman\",\"isPartOf\":{\"@id\":\"http:\/\/www.aamirharoon.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\/\/www.aamirharoon.com\/?p=80#primaryimage\"},\"image\":{\"@id\":\"http:\/\/www.aamirharoon.com\/?p=80#primaryimage\"},\"thumbnailUrl\":\"http:\/\/www.aamirharoon.com\/wp-content\/uploads\/2015\/11\/msr_mon_config1.png\",\"datePublished\":\"2015-11-21T13:58:30+00:00\",\"breadcrumb\":{\"@id\":\"http:\/\/www.aamirharoon.com\/?p=80#breadcrumb\"},\"inLanguage\":\"en\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/www.aamirharoon.com\/?p=80\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"http:\/\/www.aamirharoon.com\/?p=80#primaryimage\",\"url\":\"http:\/\/www.aamirharoon.com\/wp-content\/uploads\/2015\/11\/msr_mon_config1.png\",\"contentUrl\":\"http:\/\/www.aamirharoon.com\/wp-content\/uploads\/2015\/11\/msr_mon_config1.png\",\"width\":796,\"height\":400},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/www.aamirharoon.com\/?p=80#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\/\/www.aamirharoon.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Important Steps Before Upgrading OMR database to 12c PDB\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/www.aamirharoon.com\/#website\",\"url\":\"http:\/\/www.aamirharoon.com\/\",\"name\":\"The Database Handyman\",\"description\":\"My notes about Oracle Database, APEX, OEM Cloud Control and whatever I learn\",\"publisher\":{\"@id\":\"http:\/\/www.aamirharoon.com\/#\/schema\/person\/dbcd256c4a97c6e27b7cc408200a9b63\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/www.aamirharoon.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"http:\/\/www.aamirharoon.com\/#\/schema\/person\/dbcd256c4a97c6e27b7cc408200a9b63\",\"name\":\"Aamir\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en\",\"@id\":\"http:\/\/www.aamirharoon.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/63cc5bb07711a1b9719cc47e13a8205072859c1aef30fac28f412baa84b9cf9b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/63cc5bb07711a1b9719cc47e13a8205072859c1aef30fac28f412baa84b9cf9b?s=96&d=mm&r=g\",\"caption\":\"Aamir\"},\"logo\":{\"@id\":\"http:\/\/www.aamirharoon.com\/#\/schema\/person\/image\/\"},\"sameAs\":[\"http:\/\/www.aamirharoon.com\/about\/\",\"https:\/\/x.com\/aamir814\"],\"url\":\"http:\/\/www.aamirharoon.com\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Important Steps Before Upgrading OMR database to 12c PDB - The Database Handyman","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":"http:\/\/www.aamirharoon.com\/?p=80","og_locale":"en_US","og_type":"article","og_title":"Important Steps Before Upgrading OMR database to 12c PDB - The Database Handyman","og_description":"Here are some important steps that needs to be done before you upgrade Oracle Managed Repository (OMR) database to 12c PDB. First you have to","og_url":"http:\/\/www.aamirharoon.com\/?p=80","og_site_name":"The Database Handyman","article_published_time":"2015-11-21T13:58:30+00:00","og_image":[{"url":"http:\/\/www.aamirharoon.com\/wp-content\/uploads\/2015\/11\/msr_mon_config1.png","type":"","width":"","height":""}],"author":"Aamir","twitter_card":"summary_large_image","twitter_creator":"@aamir814","twitter_site":"@aamir814","twitter_misc":{"Written by":"Aamir","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/www.aamirharoon.com\/?p=80#article","isPartOf":{"@id":"http:\/\/www.aamirharoon.com\/?p=80"},"author":{"name":"Aamir","@id":"http:\/\/www.aamirharoon.com\/#\/schema\/person\/dbcd256c4a97c6e27b7cc408200a9b63"},"headline":"Important Steps Before Upgrading OMR database to 12c PDB","datePublished":"2015-11-21T13:58:30+00:00","mainEntityOfPage":{"@id":"http:\/\/www.aamirharoon.com\/?p=80"},"wordCount":159,"commentCount":0,"publisher":{"@id":"http:\/\/www.aamirharoon.com\/#\/schema\/person\/dbcd256c4a97c6e27b7cc408200a9b63"},"image":{"@id":"http:\/\/www.aamirharoon.com\/?p=80#primaryimage"},"thumbnailUrl":"http:\/\/www.aamirharoon.com\/wp-content\/uploads\/2015\/11\/msr_mon_config1.png","keywords":["12c","12c OMR","CDB","OEM Cloud Control","OMR PDB","OMS","OMS 12c","PDB"],"articleSection":["OEM Cloud Control 12c"],"inLanguage":"en","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["http:\/\/www.aamirharoon.com\/?p=80#respond"]}]},{"@type":"WebPage","@id":"http:\/\/www.aamirharoon.com\/?p=80","url":"http:\/\/www.aamirharoon.com\/?p=80","name":"Important Steps Before Upgrading OMR database to 12c PDB - The Database Handyman","isPartOf":{"@id":"http:\/\/www.aamirharoon.com\/#website"},"primaryImageOfPage":{"@id":"http:\/\/www.aamirharoon.com\/?p=80#primaryimage"},"image":{"@id":"http:\/\/www.aamirharoon.com\/?p=80#primaryimage"},"thumbnailUrl":"http:\/\/www.aamirharoon.com\/wp-content\/uploads\/2015\/11\/msr_mon_config1.png","datePublished":"2015-11-21T13:58:30+00:00","breadcrumb":{"@id":"http:\/\/www.aamirharoon.com\/?p=80#breadcrumb"},"inLanguage":"en","potentialAction":[{"@type":"ReadAction","target":["http:\/\/www.aamirharoon.com\/?p=80"]}]},{"@type":"ImageObject","inLanguage":"en","@id":"http:\/\/www.aamirharoon.com\/?p=80#primaryimage","url":"http:\/\/www.aamirharoon.com\/wp-content\/uploads\/2015\/11\/msr_mon_config1.png","contentUrl":"http:\/\/www.aamirharoon.com\/wp-content\/uploads\/2015\/11\/msr_mon_config1.png","width":796,"height":400},{"@type":"BreadcrumbList","@id":"http:\/\/www.aamirharoon.com\/?p=80#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/www.aamirharoon.com\/"},{"@type":"ListItem","position":2,"name":"Important Steps Before Upgrading OMR database to 12c PDB"}]},{"@type":"WebSite","@id":"http:\/\/www.aamirharoon.com\/#website","url":"http:\/\/www.aamirharoon.com\/","name":"The Database Handyman","description":"My notes about Oracle Database, APEX, OEM Cloud Control and whatever I learn","publisher":{"@id":"http:\/\/www.aamirharoon.com\/#\/schema\/person\/dbcd256c4a97c6e27b7cc408200a9b63"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/www.aamirharoon.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en"},{"@type":["Person","Organization"],"@id":"http:\/\/www.aamirharoon.com\/#\/schema\/person\/dbcd256c4a97c6e27b7cc408200a9b63","name":"Aamir","image":{"@type":"ImageObject","inLanguage":"en","@id":"http:\/\/www.aamirharoon.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/63cc5bb07711a1b9719cc47e13a8205072859c1aef30fac28f412baa84b9cf9b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/63cc5bb07711a1b9719cc47e13a8205072859c1aef30fac28f412baa84b9cf9b?s=96&d=mm&r=g","caption":"Aamir"},"logo":{"@id":"http:\/\/www.aamirharoon.com\/#\/schema\/person\/image\/"},"sameAs":["http:\/\/www.aamirharoon.com\/about\/","https:\/\/x.com\/aamir814"],"url":"http:\/\/www.aamirharoon.com\/?author=1"}]}},"_links":{"self":[{"href":"http:\/\/www.aamirharoon.com\/index.php?rest_route=\/wp\/v2\/posts\/80","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.aamirharoon.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.aamirharoon.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.aamirharoon.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.aamirharoon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=80"}],"version-history":[{"count":16,"href":"http:\/\/www.aamirharoon.com\/index.php?rest_route=\/wp\/v2\/posts\/80\/revisions"}],"predecessor-version":[{"id":98,"href":"http:\/\/www.aamirharoon.com\/index.php?rest_route=\/wp\/v2\/posts\/80\/revisions\/98"}],"wp:attachment":[{"href":"http:\/\/www.aamirharoon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=80"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.aamirharoon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=80"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.aamirharoon.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=80"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}