{"id":5045,"date":"2013-02-13T02:13:44","date_gmt":"2013-02-13T06:13:44","guid":{"rendered":"http:\/\/onlineappsdba.com\/?p=5045"},"modified":"2013-02-13T02:14:34","modified_gmt":"2013-02-13T06:14:34","slug":"exporting-and-importing-oim-10g-environment","status":"publish","type":"post","link":"https:\/\/onlineappsdba.com\/index.php\/2013\/02\/13\/exporting-and-importing-oim-10g-environment\/","title":{"rendered":"Exporting and importing OIM 10g environment"},"content":{"rendered":"<p>Hi All,<\/p>\n<p>This post will provide detailed steps to replicate one OIM 10g environment to the other. It is assumed that source and target OIM environments are of 10g version and are on patches with same application server.<\/p>\n<p><strong>Steps to be performed at Source OIM environment<\/strong>:<\/p>\n<ul>\n<li>Shutdown the OIM server.<\/li>\n<li>Export the OIM database using below command<\/li>\n<\/ul>\n<p><em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 exp system\/&lt;SYSTEM_PASSWORD&gt; file=&lt;DUMP_FILE_NAME&gt;.dmp owner=&lt;SOURCE_OIM_DB_USER&gt; log=exp_&lt;file_name&gt;.log consistent=y statistics=none<\/em><\/p>\n<ul>\n<li>Export the tablespaces used by OIM server using below commands<\/li>\n<\/ul>\n<p><em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 select DEFAULT_TABLESPACE, TEMPORARY_TABLESPACE from dba_users where username='&lt;SOURCE_OIM_DB_USER&gt;&#8217;;<\/em><\/p>\n<p><em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 select distinct tablespace_name from dba_segments where owner='&lt;SOURCE_OIM_DB_USER&gt;&#8217;;<\/em><\/p>\n<p><strong>Steps to be performed at Destination OIM environment<\/strong>:<\/p>\n<ul>\n<li>Shutdown the OIM server.<\/li>\n<li>Backup the OIM database schema using the below command<\/li>\n<\/ul>\n<p><em>\u00a0\u00a0\u00a0 exp system\/&lt;system_password&gt; file=&lt;file_name&gt;_backup.dmp owner=&lt;OIM_DB_USER&gt; log=exp_&lt;FILE_NAME&gt;.log statistics=none<\/em><\/p>\n<ul>\n<li>Backup the files <strong>$OIM_HOME\/config\/.xldatabasekey<\/strong> and <strong>$OIM_HOME\/config\/.xlkeystore<\/strong> and <strong>$OIM_HOME\/config\/configkey.key<\/strong><\/li>\n<li>Drop the OIM schema user and tablespaces using the below commands<\/li>\n<\/ul>\n<p><em>drop user &lt;OIM_DB_USER&gt; cascade <\/em><br \/>\n<em>drop tablespace &lt;OIM_DB_TABLESPACE_NAME&gt; including content and datafile<\/em><br \/>\n<em>drop tablespace &lt;OIM_DB_TEMP_TABLESPACE_NAME&gt; including content and datafile<\/em><\/p>\n<ul>\n<li>Create OIM schema user with prepare_xl_db.bat\/sh script as shown below. \u00a0<strong>NOTE: The schema name should be same as it was dropped in previous step<\/strong>.<\/li>\n<\/ul>\n<p><em>\u00a0\u00a0\u00a0 prepare_xl_db.bat &lt;DB_CONNECT_STRING&gt; &lt;$ORACLE_HOME&gt; &lt;OIM_DB_USER&gt; &lt;OIM_DB_USER_PASSWORD&gt; &lt;OIM_DB_TABLESPACE_NAME&gt; &lt;OIM_DB_DATAFILE_LOCATION&gt; &lt;OIM_DB_DATAFILE_NAME&gt; &lt;OIM_DB_TEMP_TABLESPACE_NAME&gt; &lt;DB_SYSTEM_USER_PASSWORD&gt;<\/em><\/p>\n<ul>\n<li>If there are any additional tablespaces that are used by OIM they need to be created too.<\/li>\n<li>Copy the dmp files from Source to Destination OIM environment to a location that has appropriate permissions.<\/li>\n<li>Ensure the tablespaces of OIM schema user are dimensioned properly for smooth importing of DB dump file.<\/li>\n<li>Import the dump file using the below command.<\/li>\n<\/ul>\n<p><em>\u00a0\u00a0\u00a0\u00a0 imp system\/&lt;SYSTEM_PASSWORD&gt; file=&lt;DUMP_FILE_NAME&gt;.dmp fromuser=&lt;SOURCE_OIM_DB_USER&gt; touser=&lt;OIM_DB_USER&gt; log=imp_&lt;FILE_NAME&gt;.log<\/em><\/p>\n<p>Check the import log file to make sure that there are no errors.<\/p>\n<p><strong>Additional Steps<\/strong>:<\/p>\n<ul>\n<li>When a OIM schema backup was taken in a fresh OIM 10g environment and in the future you wish to restore the OIM 10g with fresh DB then there is no need to execute the below steps.<\/li>\n<\/ul>\n<ul>\n<li>Login to OIM Database as OIM schema user and update the schema name using the below command.<\/li>\n<\/ul>\n<p><em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SQLPLUS&gt;update SDK set SDK_SCHEMA='&lt;OIM_DB_USER&gt;&#8217;;<\/em><br \/>\n<em>\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 SQLPLUS&gt;commit;<\/em><\/p>\n<ul>\n<li>Copy from source to destination the following files: $OIM_HOME\/config\/.xldatabasekey, $OIM_HOME\/config\/.xlkeystore and $OIM_HOME\/config\/configkey.key.<\/li>\n<li>Modify xlconfig.xml with following changes under <strong>DirectDB<\/strong> section:<\/li>\n<\/ul>\n<p><em>Change the &lt;url&gt; value to the correct one.<\/em><br \/>\n<em>Change the &lt;username&gt; value to the correct one.<\/em><br \/>\n<em>If the password for the schema of the new environment is different from the original one, then set the encrypted value for to &#8220;false&#8221; and then set the password in clear text.Modify xlconfig.xml<\/em><\/p>\n<ul>\n<li>Login to the application server console and update the data sources xlDS and xlXADS for Database URL, DB port, and DB schema credentials.<\/li>\n<\/ul>\n<p><strong>Testing the replication<\/strong>:<br \/>\nStart the OIM server and make sure that there are no exceptions in logs. Try to login to OIM admin console with xelsysadm user. Please note to use xelsysadm credentials as per Source OIM environment.<\/p>\n<p><strong>References<\/strong>:<\/p>\n<p>Oracle metalink note <strong>555655.1<\/strong>.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Hi All, This post will provide detailed steps to replicate one OIM 10g environment to the other. It is assumed [&hellip;]<\/p>\n","protected":false},"author":115,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[185],"tags":[],"class_list":["post-5045","post","type-post","status-publish","format-standard","hentry","category-oim"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Exporting and importing OIM 10g environment  -<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/onlineappsdba.com\/index.php\/2013\/02\/13\/exporting-and-importing-oim-10g-environment\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Exporting and importing OIM 10g environment  -\" \/>\n<meta property=\"og:description\" content=\"Hi All, This post will provide detailed steps to replicate one OIM 10g environment to the other. It is assumed [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/onlineappsdba.com\/index.php\/2013\/02\/13\/exporting-and-importing-oim-10g-environment\/\" \/>\n<meta property=\"article:published_time\" content=\"2013-02-13T06:13:44+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2013-02-13T06:14:34+00:00\" \/>\n<meta name=\"author\" content=\"Masroof Ahmad\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Masroof Ahmad\" \/>\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\":\"WebPage\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2013\/02\/13\/exporting-and-importing-oim-10g-environment\/\",\"url\":\"https:\/\/onlineappsdba.com\/index.php\/2013\/02\/13\/exporting-and-importing-oim-10g-environment\/\",\"name\":\"Exporting and importing OIM 10g environment -\",\"isPartOf\":{\"@id\":\"https:\/\/onlineappsdba.com\/#website\"},\"datePublished\":\"2013-02-13T06:13:44+00:00\",\"dateModified\":\"2013-02-13T06:14:34+00:00\",\"author\":{\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\"},\"breadcrumb\":{\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2013\/02\/13\/exporting-and-importing-oim-10g-environment\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/onlineappsdba.com\/index.php\/2013\/02\/13\/exporting-and-importing-oim-10g-environment\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/onlineappsdba.com\/index.php\/2013\/02\/13\/exporting-and-importing-oim-10g-environment\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/onlineappsdba.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Exporting and importing OIM 10g environment\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/onlineappsdba.com\/#website\",\"url\":\"https:\/\/onlineappsdba.com\/\",\"name\":\"\",\"description\":\"Oracle Implementation &amp; Training Experts\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/onlineappsdba.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb\",\"name\":\"Masroof Ahmad\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g\",\"caption\":\"Masroof Ahmad\"},\"url\":\"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Exporting and importing OIM 10g environment  -","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:\/\/onlineappsdba.com\/index.php\/2013\/02\/13\/exporting-and-importing-oim-10g-environment\/","og_locale":"en_US","og_type":"article","og_title":"Exporting and importing OIM 10g environment  -","og_description":"Hi All, This post will provide detailed steps to replicate one OIM 10g environment to the other. It is assumed [&hellip;]","og_url":"https:\/\/onlineappsdba.com\/index.php\/2013\/02\/13\/exporting-and-importing-oim-10g-environment\/","article_published_time":"2013-02-13T06:13:44+00:00","article_modified_time":"2013-02-13T06:14:34+00:00","author":"Masroof Ahmad","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Masroof Ahmad","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/onlineappsdba.com\/index.php\/2013\/02\/13\/exporting-and-importing-oim-10g-environment\/","url":"https:\/\/onlineappsdba.com\/index.php\/2013\/02\/13\/exporting-and-importing-oim-10g-environment\/","name":"Exporting and importing OIM 10g environment -","isPartOf":{"@id":"https:\/\/onlineappsdba.com\/#website"},"datePublished":"2013-02-13T06:13:44+00:00","dateModified":"2013-02-13T06:14:34+00:00","author":{"@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb"},"breadcrumb":{"@id":"https:\/\/onlineappsdba.com\/index.php\/2013\/02\/13\/exporting-and-importing-oim-10g-environment\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/onlineappsdba.com\/index.php\/2013\/02\/13\/exporting-and-importing-oim-10g-environment\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/onlineappsdba.com\/index.php\/2013\/02\/13\/exporting-and-importing-oim-10g-environment\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/onlineappsdba.com\/"},{"@type":"ListItem","position":2,"name":"Exporting and importing OIM 10g environment"}]},{"@type":"WebSite","@id":"https:\/\/onlineappsdba.com\/#website","url":"https:\/\/onlineappsdba.com\/","name":"","description":"Oracle Implementation &amp; Training Experts","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/onlineappsdba.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/909a876ed58d400faf82caf81d61bfdb","name":"Masroof Ahmad","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/onlineappsdba.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/10f9db7bdbbd7f9ccfbe9b2d208e5978fc28315e9c704383e639a926ea0fce5f?s=96&d=mm&r=g","caption":"Masroof Ahmad"},"url":"https:\/\/onlineappsdba.com\/index.php\/author\/masroof\/"}]}},"_links":{"self":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/5045","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/users\/115"}],"replies":[{"embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/comments?post=5045"}],"version-history":[{"count":0,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/posts\/5045\/revisions"}],"wp:attachment":[{"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/media?parent=5045"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/categories?post=5045"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/onlineappsdba.com\/index.php\/wp-json\/wp\/v2\/tags?post=5045"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}