{"id":23939,"date":"2023-04-17T09:22:43","date_gmt":"2023-04-17T07:22:43","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=23939"},"modified":"2024-09-10T17:24:56","modified_gmt":"2024-09-10T15:24:56","slug":"changing-fusion-middleware-repository-database","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/changing-fusion-middleware-repository-database\/","title":{"rendered":"Changing Fusion Middleware repository database"},"content":{"rendered":"\n<p>In my previous blog named &#8220;<a href=\"https:\/\/www.dbi-services.com\/blog\/changing-fusion-middleware-forms-and-reports-repository-database\/\">Changing Fusion Middleware Forms and Reports repository database<\/a>&#8220;, I explained how to move a Fusion Middleware Forms and Reports repository from one database to a new database where some other repositories already exist. In this blog, I will explain how to move Fusion Middleware repositories from one database to a brand new database.<\/p>\n\n\n\n<p>The Fusion Middleware repository database migration has been done following the <a href=\"https:\/\/docs.oracle.com\/en\/middleware\/fusion-middleware\/12.2.1.4\/asadm\/changing-network-configurations.html#GUID-2D7EA551-C00D-4604-B02F-1468EEC1F040\" target=\"_blank\" rel=\"noreferrer noopener\">Oracle Fusion Middleware 12.2.1.4 \u2013 Administering Oracle Fusion Middleware<\/a> documentation. The following restrictions applies to this kind of move:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>The service name and SID of the database on the target host must be the same as on the source host.<\/li>\n\n\n\n<li>The port on the target host must be the same as on the source host.<\/li>\n\n\n\n<li>The database on the target host must contain the same schemas as on the source host and the schemas must have the same prefix as on the source host.<\/li>\n<\/ul>\n\n\n\n<p>The Repository Creation Utility (RCU) gives the possibility to create SQL scripts to create the system tables and information plus the Fusion Middleware product repository schemas and tables. We will use this functionality to configure the new database to host the migrated repository.<\/p>\n\n\n\n<p>Using the RCU located in the $ORACLE_HOME\/oracle_common\/bin directory of the Fusion Middleware product I want to migrate the repository, I will generate the scripts that will create all needed objects in the target database for this database to become a Fusion Middleware repository database. Below are the steps I run to archive this.<\/p>\n\n\n\n<p>I start the RCU and select &#8220;Create repository&#8221; and &#8220;Prepare Scripts for System loads&#8221;.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"602\" height=\"469\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/03\/image-18.png\" alt=\"\" class=\"wp-image-23940\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/03\/image-18.png 602w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/03\/image-18-300x234.png 300w\" sizes=\"auto, (max-width: 602px) 100vw, 602px\" \/><\/figure>\n<\/div>\n\n\n<p>I provide the connection information to the target database. <\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"602\" height=\"469\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/03\/image-19.png\" alt=\"\" class=\"wp-image-23941\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/03\/image-19.png 602w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/03\/image-19-300x234.png 300w\" sizes=\"auto, (max-width: 602px) 100vw, 602px\" \/><\/figure>\n<\/div>\n\n\n<p>RCU checks if the target database fulfill the prerequisites.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"602\" height=\"472\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/03\/image-20.png\" alt=\"\" class=\"wp-image-23942\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/03\/image-20.png 602w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/03\/image-20-300x235.png 300w\" sizes=\"auto, (max-width: 602px) 100vw, 602px\" \/><\/figure>\n<\/div>\n\n\n<p>I choose the same prefix as on the source database and the same list of components.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"602\" height=\"472\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/03\/image-21.png\" alt=\"\" class=\"wp-image-23943\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/03\/image-21.png 602w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/03\/image-21-300x235.png 300w\" sizes=\"auto, (max-width: 602px) 100vw, 602px\" \/><\/figure>\n<\/div>\n\n\n<p>RCU checks the prerequisites for the components selected.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"602\" height=\"470\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/03\/image-22.png\" alt=\"\" class=\"wp-image-23945\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/03\/image-22.png 602w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/03\/image-22-300x234.png 300w\" sizes=\"auto, (max-width: 602px) 100vw, 602px\" \/><\/figure>\n<\/div>\n\n\n<p>Once all is validated, I click on the &#8220;Generate&#8221; button to create the DBA script.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"602\" height=\"468\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/03\/image-23.png\" alt=\"\" class=\"wp-image-23946\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/03\/image-23.png 602w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/03\/image-23-300x233.png 300w\" sizes=\"auto, (max-width: 602px) 100vw, 602px\" \/><\/figure>\n<\/div>\n\n\n<p>This raises a process to generate the DBA scripts.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"602\" height=\"471\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/03\/image-24.png\" alt=\"\" class=\"wp-image-23947\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/03\/image-24.png 602w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/03\/image-24-300x235.png 300w\" sizes=\"auto, (max-width: 602px) 100vw, 602px\" \/><\/figure>\n<\/div>\n\n\n<p>Once finalized, the &#8220;Completion Summary&#8221; screen shows the scripts location and the RCU log file name<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"602\" height=\"473\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/03\/image-25.png\" alt=\"\" class=\"wp-image-23948\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/03\/image-25.png 602w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/03\/image-25-300x236.png 300w\" sizes=\"auto, (max-width: 602px) 100vw, 602px\" \/><\/figure>\n<\/div>\n\n\n<p><code>Scripts&nbsp;: \/tmp\/RCU2023-03-13_13-38_739854221\/logs\/<\/code><\/p>\n\n\n\n<p>Run the script &#8220;script_systemLoad.sql&#8221; on the target database as user having the DBA privileges to create the Fusion Middleware system objects and the product metadata schemas. <\/p>\n\n\n\n<p>Once this is done, the rest of the steps are the same as in my previous blog <a href=\"https:\/\/www.dbi-services.com\/blog\/changing-fusion-middleware-forms-and-reports-repository-database\/\">Changing Fusion Middleware Forms and Reports repository database<\/a>&#8220;. Those are:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Export all Fusion Middleware repository schemas from the source database<\/h3>\n\n\n\n<p>Before exporting the schemas, you need to make sure the export will be done in the right character set. In my case, the recommended character set for Fusion Middleware was used: AL32UTF8<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nexport NLS_LANG=AMERICAN_AMERICA.AL32UTF8\nexpdp system\/***** schemas=VM40FR_STB,VM40FR_IAU_APPEND,VM40FR_IAU_VIEWER,VM40FR_MDS,VM40FR_WLS,VM40FR_WLS_RUNTIME,VM40FR_IAU,VM40FR_OPSS dumpfile=VM40FR.dpdmp\ufeff\n<\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">Import those schemas in the target database<\/h3>\n\n\n\n<p>Same as for the database schemas export, the character set has to be correctly set in the NLS_LANG to avoid any character conversion or loose. <\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\nexport NLS_LANG=AMERICAN_AMERICA.AL32UTF8\nimpdp system\/***** file=VM40FR.dpdmp\n<\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">Reconfigure the Fusion Middleware to use the new repository database<\/h3>\n\n\n\n<p>The reconfiguration of the Fusion Middleware Forms &amp; Reports has been done using the chghost.sh tool but this one requires two files. The wallet containing the WebLogic domain administrator password and the mapping file describing the type of changes that the chghost.sh tool will apply. Before running the change host script, make sure no process is running for the Fusion Middleware WebLogic Domain. For example, if the node manager is started as Unix service, make sure to stop it or the change host tool will hang stopping the WebLogic managed servers.<\/p>\n\n\n\n<p>Generate the wallet file for an administrator user named weblogic on my test environments.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code> $MW_HOME\/oracle_common\/common\/bin\/configWallet.sh -walletDir \/home\/oracle\/CHGHOST_TEST weblogic<\/code><\/pre>\n\n\n\n<p> Create the mapping file. db_host_move.txt in this case.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>&#091;ARGUMENTS] &#091;DATABASE_MAPPING] \n#  You can only change the database host name. \nvm07.it.dbi-services.com=vm09.it.dbi-services.com<\/code><\/pre>\n\n\n\n<p>Finally run the chghost.sh script.<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: plain; title: ; notranslate\" title=\"\">\ncd \/app\/oracle\/12c\/Middleware\/oracle_common\/bin\/ \n.\/chghost.sh -chgHostInputFile \/home\/oracle\/CHGHOST_TEST\/db_host_move.txt  -javaHome \/app\/oracle\/Java\/jdk1.8.0_321 -domainLoc \/data\/config\/12c\/domains\/vm12fr -domainAdminUserName weblogic -walletDir \/home\/oracle\/CHGHOST_TEST  -logPriority FINEST  -logDir \/home\/oracle\/CHGHOST_TEST\/logs\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"<p>In my previous blog named &#8220;Changing Fusion Middleware Forms and Reports repository database&#8220;, I explained how to move a Fusion Middleware Forms and Reports repository from one database to a new database where some other repositories already exist. In this blog, I will explain how to move Fusion Middleware repositories from one database to a [&hellip;]<\/p>\n","protected":false},"author":40,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[197,2748],"tags":[3096,490,3094],"type_dbi":[],"class_list":["post-23939","post","type-post","status-publish","format-standard","hentry","category-application-integration-middleware","category-weblogic","tag-metadata-repository","tag-oracle-fusion-middleware","tag-reconfiguration"],"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>Changing Fusion Middleware repository database - dbi Blog<\/title>\n<meta name=\"description\" content=\"This blogs explains how to migrate the database used for the Fusion Middleware repository to a new host using the RCU SQL dba scripts.\" \/>\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\/changing-fusion-middleware-repository-database\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Changing Fusion Middleware repository database\" \/>\n<meta property=\"og:description\" content=\"This blogs explains how to migrate the database used for the Fusion Middleware repository to a new host using the RCU SQL dba scripts.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/changing-fusion-middleware-repository-database\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-17T07:22:43+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-09-10T15:24:56+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/03\/image-18.png\" \/>\n<meta name=\"author\" content=\"Middleware 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=\"Middleware Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 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\/changing-fusion-middleware-repository-database\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/changing-fusion-middleware-repository-database\/\"},\"author\":{\"name\":\"Middleware Team\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1\"},\"headline\":\"Changing Fusion Middleware repository database\",\"datePublished\":\"2023-04-17T07:22:43+00:00\",\"dateModified\":\"2024-09-10T15:24:56+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/changing-fusion-middleware-repository-database\/\"},\"wordCount\":617,\"commentCount\":4,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/changing-fusion-middleware-repository-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/03\/image-18.png\",\"keywords\":[\"metadata repository\",\"Oracle Fusion Middleware\",\"Reconfiguration\"],\"articleSection\":[\"Application integration &amp; Middleware\",\"WebLogic\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/changing-fusion-middleware-repository-database\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/changing-fusion-middleware-repository-database\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/changing-fusion-middleware-repository-database\/\",\"name\":\"Changing Fusion Middleware repository database - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/changing-fusion-middleware-repository-database\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/changing-fusion-middleware-repository-database\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/03\/image-18.png\",\"datePublished\":\"2023-04-17T07:22:43+00:00\",\"dateModified\":\"2024-09-10T15:24:56+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1\"},\"description\":\"This blogs explains how to migrate the database used for the Fusion Middleware repository to a new host using the RCU SQL dba scripts.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/changing-fusion-middleware-repository-database\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/changing-fusion-middleware-repository-database\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/changing-fusion-middleware-repository-database\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/03\/image-18.png\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/03\/image-18.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/changing-fusion-middleware-repository-database\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Changing Fusion Middleware repository database\"}]},{\"@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\/8d8563acfc6e604cce6507f45bac0ea1\",\"name\":\"Middleware Team\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g\",\"caption\":\"Middleware Team\"},\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/middleware-team\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Changing Fusion Middleware repository database - dbi Blog","description":"This blogs explains how to migrate the database used for the Fusion Middleware repository to a new host using the RCU SQL dba scripts.","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\/changing-fusion-middleware-repository-database\/","og_locale":"en_US","og_type":"article","og_title":"Changing Fusion Middleware repository database","og_description":"This blogs explains how to migrate the database used for the Fusion Middleware repository to a new host using the RCU SQL dba scripts.","og_url":"https:\/\/www.dbi-services.com\/blog\/changing-fusion-middleware-repository-database\/","og_site_name":"dbi Blog","article_published_time":"2023-04-17T07:22:43+00:00","article_modified_time":"2024-09-10T15:24:56+00:00","og_image":[{"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/03\/image-18.png","type":"","width":"","height":""}],"author":"Middleware Team","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Middleware Team","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/changing-fusion-middleware-repository-database\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/changing-fusion-middleware-repository-database\/"},"author":{"name":"Middleware Team","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1"},"headline":"Changing Fusion Middleware repository database","datePublished":"2023-04-17T07:22:43+00:00","dateModified":"2024-09-10T15:24:56+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/changing-fusion-middleware-repository-database\/"},"wordCount":617,"commentCount":4,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/changing-fusion-middleware-repository-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/03\/image-18.png","keywords":["metadata repository","Oracle Fusion Middleware","Reconfiguration"],"articleSection":["Application integration &amp; Middleware","WebLogic"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/changing-fusion-middleware-repository-database\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/changing-fusion-middleware-repository-database\/","url":"https:\/\/www.dbi-services.com\/blog\/changing-fusion-middleware-repository-database\/","name":"Changing Fusion Middleware repository database - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/changing-fusion-middleware-repository-database\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/changing-fusion-middleware-repository-database\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/03\/image-18.png","datePublished":"2023-04-17T07:22:43+00:00","dateModified":"2024-09-10T15:24:56+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/8d8563acfc6e604cce6507f45bac0ea1"},"description":"This blogs explains how to migrate the database used for the Fusion Middleware repository to a new host using the RCU SQL dba scripts.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/changing-fusion-middleware-repository-database\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/changing-fusion-middleware-repository-database\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/changing-fusion-middleware-repository-database\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/03\/image-18.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/03\/image-18.png"},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/changing-fusion-middleware-repository-database\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Changing Fusion Middleware repository database"}]},{"@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\/8d8563acfc6e604cce6507f45bac0ea1","name":"Middleware Team","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ddcae7ba0f9d1a0e7ae707f0e689e4a9c95bb48ec49c8e6d9cc86d43f4121cb6?s=96&d=mm&r=g","caption":"Middleware Team"},"url":"https:\/\/www.dbi-services.com\/blog\/author\/middleware-team\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/23939","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\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=23939"}],"version-history":[{"count":8,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/23939\/revisions"}],"predecessor-version":[{"id":28213,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/23939\/revisions\/28213"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=23939"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=23939"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=23939"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=23939"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}