Edit D:\rfid\database\database\doc\owb.112\e10579\migrate.htm
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html lang="en" xml:lang="en" xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=us-ascii" /> <meta http-equiv="Content-Language" content="en" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <meta http-equiv="Content-Script-Type" content="text/javascript" /> <meta name="robots" content="all" scheme="http://www.robotstxt.org/" /> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = document) - Version 5.1" /> <meta name="Date" content="2009-07-31T16:48:21Z" /> <meta name="doctitle" content="Oracle® Warehouse Builder Installation and Administration Guide 11g Release 2 (11.2) for Windows and Linux" /> <meta name="partno" content="E10579-01" /> <meta name="docid" content="WBINS" /> <link rel="Start" href="../../index.htm" title="Home" type="text/html" /> <link rel="Copyright" href="../../dcommon/html/cpyr.htm" title="Copyright" type="text/html" /> <link rel="Stylesheet" href="../../dcommon/css/blafdoc.css" title="Default" type="text/css" /> <script type="text/javascript" src="../../dcommon/js/doccd.js"> </script> <link rel="Contents" href="toc.htm" title="Contents" type="text/html" /> <link rel="Index" href="index.htm" title="Index" type="text/html" /> <link rel="Prev" href="uninstall.htm" title="Previous" type="text/html" /> <link rel="Next" href="components.htm" title="Next" type="text/html" /> <link rel="alternate" href="../e10579.pdf" title="PDF version" type="application/pdf" /> <title>Migrating Oracle Warehouse Builder from Earlier Releases</title> </head> <body> <div class="header"> <div class="zz-skip-header"><a name="top" id="top" href="#BEGIN">Skip Headers</a></div> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <tr> <td align="left" valign="top"><b>Oracle® Warehouse Builder Installation and Administration Guide<br /> 11<i>g</i> Release 2 (11.2) for Windows and Linux</b><br /> Part Number E10579-01</td> <td valign="bottom" align="right"> <table class="icons oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="245"> <tr> <td align="center" valign="top"><a href="../../index.htm"><img width="24" height="24" src="../../dcommon/gifs/doclib.gif" alt="Go to Documentation Home" /><br /> <span class="icon">Home</span></a></td> <td align="center" valign="top"><a href="../../nav/portal_booklist.htm"><img width="24" height="24" src="../../dcommon/gifs/booklist.gif" alt="Go to Book List" /><br /> <span class="icon">Book List</span></a></td> <td align="center" valign="top"><a href="toc.htm"><img width="24" height="24" src="../../dcommon/gifs/toc.gif" alt="Go to Table of Contents" /><br /> <span class="icon">Contents</span></a></td> <td align="center" valign="top"><a href="index.htm"><img width="24" height="24" src="../../dcommon/gifs/index.gif" alt="Go to Index" /><br /> <span class="icon">Index</span></a></td> <td align="center" valign="top"><a href="../../dcommon/html/feedback.htm"><img width="24" height="24" src="../../dcommon/gifs/feedbck2.gif" alt="Go to Feedback page" /><br /> <span class="icon">Contact Us</span></a></td> </tr> </table> </td> </tr> </table> <hr /> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <tr> <td align="left" valign="top"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="98"> <tr> <td align="center" valign="top"><a href="uninstall.htm"><img width="24" height="24" src="../../dcommon/gifs/leftnav.gif" alt="Go to previous page" /><br /> <span class="icon">Previous</span></a></td> <td align="center" valign="top"><a href="components.htm"><img width="24" height="24" src="../../dcommon/gifs/rightnav.gif" alt="Go to next page" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </td> <td align="right" valign="top" style="font-size: 90%"><a href="../e10579.pdf">View PDF</a></td> </tr> </table> <a name="BEGIN" id="BEGIN"></a></div> <div class="IND"><!-- End Header --><a id="CHDFEBII" name="CHDFEBII"></a><a id="WBINS07000" name="WBINS07000"></a> <h1 class="chapter"><span class="secnum">6</span> Migrating Oracle Warehouse Builder from Earlier Releases</h1> <p>Oracle Warehouse Builder enables you to upgrade repositories from earlier versions of Oracle Warehouse Builder10<span class="italic">g</span> Release 2 and Oracle Warehouse Builder 11<span class="italic">g</span> Release 1 to Warehouse Builder 11<span class="italic">g</span> Release 2. This section describes how to perform this upgrade.</p> <p>To upgrade from versions of Oracle Warehouse Builder earlier than 10<span class="italic">g</span> Release 2, you must first upgrade to Oracle Warehouse Builder 10<span class="italic">g</span> Release 2 or Oracle Warehouse Builder 11<span class="italic">g</span> Release 1. You may then upgrade your repository to Oracle Warehouse Builder 11<span class="italic">g</span> Release 2.</p> <p>Note that during the repository upgrade, the Design Metadata and Control Center Agent audit data is automatically moved to the <code>OWBSYS</code> schema.</p> <p>This section includes the following topics:</p> <ul> <li> <p><a href="#CHDEHGJG">"Migrating the Repository on the Same Database Instance"</a></p> </li> <li> <p><a href="#CHDBJFGC">"Migrating the Repository to a Different Oracle Database Instance"</a></p> </li> <li> <p><a href="#CHDJJIGA">"Upgrading Locations"</a></p> </li> </ul> <a id="CHDEHGJG" name="CHDEHGJG"></a><a id="WBINS07100" name="WBINS07100"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1">Migrating the Repository on the Same Database Instance</h2> <p>You can perform an in-place upgrade of either a 10<span class="italic">g</span> R2 or 11<span class="italic">g</span> R1 repository that exists on the same database instance as your Oracle Database 11<span class="italic">g</span> R2 installation.</p> <p>To preform the tasks in this section, you must have <code>SYSADMIN</code> privileges, which allow you to execute prerequisite scripts. Note that before you start the actual migration using the Repository Assistant, you should prepare by backing up the current <code>OWBSYS</code> schema, creating an <code>OWBSYS</code> schema if it does not exist (10<span class="italic">g</span> R2) or upgrade it (11<span class="italic">g</span> R1), and resetting <code><span class="codeinlineitalic">OWB_HOME</span></code> on the new instance. Note that you would also need to unlock the <code>OWBSYS</code> and <code>OWBSYS_AUDIT</code> schemas.</p> <p>Also note that the repositories from versions earlier than 10<span class="italic">g</span> R2 cannot be upgraded to 11<span class="italic">g </span>R2 directly; they must be first upgraded to 10<span class="italic">g</span> R2.</p> <a id="WBINS16055" name="WBINS16055"></a> <div class="sect2"><a id="sthref231" name="sthref231"></a> <h3 class="sect2">Preparing for Repository Migration</h3> <p>The steps for preparing a repository for migration are separate for Windows and Linux.</p> <a id="WBINS16056" name="WBINS16056"></a> <p class="subhead2">To prepare for a repository upgrade on Windows:</p> <ol> <li> <p>Ensure that you make a back-up copy of the <code>OWBSYS</code> schema, using the backup strategy employed in your organization.</p> </li> <li> <p>On the Microsoft Windows desktop, click <span class="bold">Start</span> and select <span class="bold">Run</span>.</p> </li> <li> <p>In the Run window, for <span class="bold">Open</span>, enter <code>cmd</code>.</p> <p>Click <span class="bold">OK</span>.</p> </li> <li> <p>At the command prompt, start SQL*Plus:</p> <pre xml:space="preserve" class="oac_no_warn">C:\><span class="bold">sqlplus</span> SQL*Plus: Release 11.2 - Production on Mon July 27 16:24:02 2009 Copyright (c) 1982, 2009, Oracle. All rights reserved. </pre></li> <li> <p>Connect as user with administrative privileges:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> <span class="bold">connect sys as sysdba</span> Enter password: <span class="bolditalic">password</span> </pre></li> <li> <p>You have two options for the <code>OWBSYS</code> schema:</p> <ul> <li> <p>If the <code>OWBSYS</code> schema does not exist on the Oracle Database instance, run the <code>cat_owb.sql</code> script to create it:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> <span class="bold">@C:\OWB112\owb\UnifiedRepos\cat_owb.sql</span> </pre></li> <li> <p>If the <code>OWBSYS</code> schema exists on the Oracle Database instance, and you are upgrading from OWB 11<span class="italic">g</span> Release 1, run the <code>cat_owb_reposupgrade.sql</code> script to upgrade it:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> <span class="bold">@C:\OWB112\owb\UnifiedRepos\cat_owb_reposupgrade.sql</span> </pre></li> </ul> </li> <li> <p>Run the <code>reset_owbcc_home.sql</code> script to reset the <code><span class="codeinlineitalic">OWB_HOME</span></code> directory:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> <span class="bold">@C:/OWB112/owb/UnifiedRepos/reset_owbcc_home.sql</span> </pre> <p>Note that this entry is case-sensitive, does not accept a trailing slash, and requires forward slashes only, regardless of the operating system.</p> </li> </ol> <a id="WBINS16057" name="WBINS16057"></a> <p class="subhead2">To prepare for a repository upgrade in Linux:</p> <ol> <li> <p>Ensure that you make a back-up copy of the <code>OWBSYS</code> schema, using the backup strategy employed in your organization.</p> </li> <li> <p>At the command prompt, start SQL*Plus:</p> <pre xml:space="preserve" class="oac_no_warn">% <span class="bold">sqlplus</span> SQL*Plus: Release 11.2 - Production on Mon July 27 16:37:21 2009 Copyright (c) 1982, 2009, Oracle. All rights reserved. </pre></li> <li> <p>Connect as user with administrative privileges:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> <span class="bold">connect sys as sysdba</span> Enter password: <span class="bolditalic">password</span> </pre></li> <li> <p>You have two options:</p> <ul> <li> <p>If the <code>OWBSYS</code> schema does not exist on the Oracle Database instance, run the <code>cat_owb.sql</code> script:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> <span class="bold">@OWB112/owb/UnifiedRepos/cat_owb.sql</span> </pre> <p>You are prompted for the tablespace name; enter it.</p> </li> <li> <p>If the <code>OWBSYS</code> schema exists on the Oracle Database instance, and you are upgrading from OWB 11<span class="italic">g</span> Release 1, run the <code>cat_owb_reposupgrade.sql</code> script:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> <span class="bold">@OWB112/owb/UnifiedRepos/cat_owb_reposupgrade.sql</span> </pre> <p>You are prompted for the tablespace name; enter it.</p> </li> </ul> </li> <li> <p>Run the <code>reset_owbcc_home.sql</code> script to reset the <code><span class="codeinlineitalic">OWB_HOME</span></code> directory:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> <span class="bold">@OWB112/owb/UnifiedRepos/reset_owbcc_home.sql</span> </pre> <p>Note that this entry is case-sensitive, does not accept a trailing slash, and requires forward slashes only, regardless of the operating system.</p> </li> <li> <p>Unlock the <code>OWBSYS</code> and <code>OWBSYS_AUDIT</code> accounts, as described in the following sections:</p> <ul> <li> <p><span class="bolditalic">For Windows</span>, <a href="setup_windows.htm#BACHIHIE">"Unlocking the OWBSYS and OWBSYS_AUDIT Accounts"</a></p> </li> <li> <p><span class="bolditalic">For Linux</span>, <a href="setup_linux.htm#BABDJDBJ">"Unlocking the OWBSYS and OWBSYS_AUDIT Accounts"</a></p> </li> </ul> </li> </ol> </div> <!-- class="sect2" --> <a id="WBINS16058" name="WBINS16058"></a> <div class="sect2"><a id="sthref232" name="sthref232"></a> <h3 class="sect2">Upgrading an OWB 11g R1 Repository</h3> <p>When upgrading from an OWB 11<span class="italic">g</span> R1 repository, you are upgrading an existing <code>OWBSYS</code> schema on an existing repository.</p> <a id="WBINS16059" name="WBINS16059"></a> <p class="subhead2">To perform an in-place repository upgrade of an 11g R1 repository:</p> <ol> <li><a id="CIADBFGB" name="CIADBFGB"></a> <p>Start the Repository Assistant.</p> <p><span class="bolditalic">In Windows,</span> from the <span class="bold">Start</span> menu, select <span class="bold">Program Files</span>, then <span class="bold">Oracle - OWB112</span>, then <span class="bold">Warehouse Builder</span>, then <span class="bold">Administration</span>, then <span class="bold">Repository Assistant</span>.</p> <p><span class="bolditalic">In Linux,</span> from the command line, run <code><span class="codeinlineitalic">OWB_HOME</span></code><code>/owb/bin/unix/reposinst.sh</code>.</p> </li> <li> <p>On the Welcome page of the Repository Assistant, click <span class="bold">Next</span>.</p> </li> <li> <p>On the Database Information page, enter the host name, port number, and the service name where the OWB is installed.</p> <img width="559" height="417" src="img/upgrade_00.gif" alt="Surrounding text describes upgrade_00.gif." title="Surrounding text describes upgrade_00.gif." /><br /> <p>Click <span class="bold">Next</span>.</p> </li> <li> <p>On the Choose Operation page, select <span class="bold">Upgrade repository to current release of Oracle Warehouse Builder</span>.</p> <img width="518" height="372" src="img/upgrade_01.gif" alt="Description of upgrade_01.gif follows" title="Description of upgrade_01.gif follows" longdesc="img_text/upgrade_01.htm" /><br /> <a id="sthref233" name="sthref233" href="img_text/upgrade_01.htm">Description of the illustration upgrade_01.gif</a><br /> <br /> <p>Click <span class="bold">Next</span>.</p> </li> <li> <p>On the Choose Upgrade Operations page, select <span class="bold">Upgrade repository on the same database instance</span>.</p> <img width="530" height="363" src="img/upgrade_02.gif" alt="Description of upgrade_02.gif follows" title="Description of upgrade_02.gif follows" longdesc="img_text/upgrade_02.htm" /><br /> <a id="sthref234" name="sthref234" href="img_text/upgrade_02.htm">Description of the illustration upgrade_02.gif</a><br /> <br /> <p>Click <span class="bold">Next</span>.</p> </li> <li> <p>On the OWBSYS Information page, enter the password for the <code>OWBSYS</code> user.</p> <img width="569" height="386" src="img/upgrade_03.gif" alt="Description of upgrade_03.gif follows" title="Description of upgrade_03.gif follows" longdesc="img_text/upgrade_03.htm" /><br /> <a id="sthref235" name="sthref235" href="img_text/upgrade_03.htm">Description of the illustration upgrade_03.gif</a><br /> <br /> <p>Click <span class="bold">Next</span>.</p> </li> <li> <p>On the File Information page, in the Directory Name field, specify the name of the existing directory used for storing <code>*.mdl</code> files, log files, and other temporary files used during repository upgrade.</p> <img width="551" height="382" src="img/upgrade_04.gif" alt="Description of upgrade_04.gif follows" title="Description of upgrade_04.gif follows" longdesc="img_text/upgrade_04.htm" /><br /> <a id="sthref236" name="sthref236" href="img_text/upgrade_04.htm">Description of the illustration upgrade_04.gif</a><br /> <br /> <p>Click <span class="bold">Next</span>.</p> </li> <li> <p>On the Summary page, click <span class="bold">Finish</span> to complete the upgrade process. <img width="588" height="410" src="img/upgrade_05.gif" alt="Description of upgrade_05.gif follows" title="Description of upgrade_05.gif follows" longdesc="img_text/upgrade_05.htm" /><br /> <a id="sthref237" name="sthref237" href="img_text/upgrade_05.htm">Description of the illustration upgrade_05.gif</a><br /> <br /></p> </li> <li> <p>The Installation Progress popup window indicates the progress of the upgrade operation. When complete, click <span class="bold">OK</span>.</p> </li> </ol> </div> <!-- class="sect2" --> <a id="WBINS16060" name="WBINS16060"></a> <div class="sect2"><a id="sthref238" name="sthref238"></a> <h3 class="sect2">Upgrading an OWB 10g R2 Repository</h3> <p>You can upgrade a 10<span class="italic">g</span> R2 repository by exporting its content to a file, and then importing the file into an 11<span class="italic">g</span> R2 repository, using the Repository Assistant.</p> <a id="CIAJFHEI" name="CIAJFHEI"></a><a id="WBINS16061" name="WBINS16061"></a> <div class="sect3"> <h4 class="sect3">Exporting a Repository to a File</h4> <a id="WBINS16062" name="WBINS16062"></a> <p class="subhead2">To export a repository to a file:</p> <ol> <li> <p>Start the Repository Assistant.</p> <p><span class="bolditalic">In Windows,</span> from the <span class="bold">Start</span> menu, select <span class="bold">Program Files</span>, then <span class="bold">Oracle - OWB112</span>, then <span class="bold">Warehouse Builder</span>, then <span class="bold">Administration</span>, then <span class="bold">Repository Assistant</span>.</p> <p><span class="bolditalic">In Linux,</span> from the command line, run <code><span class="codeinlineitalic">OWB_HOME</span></code><code>/owb/bin/unix/reposinst.sh</code>.</p> </li> <li> <p>On the Welcome page of the Repository Assistant, click <span class="bold">Next</span>.</p> </li> <li><a id="CIABGAEJ" name="CIABGAEJ"></a> <p>On the Database Information page, enter the host name, port number, and the service name where the OWB is installed.</p> <p>Click <span class="bold">Next</span>.</p> </li> <li> <p>On the Choose Operation page, select <span class="bold">Upgrade repository to current release of Oracle Warehouse Builder</span>.</p> <img width="518" height="372" src="img/upgrade_01.gif" alt="Description of upgrade_01.gif follows" title="Description of upgrade_01.gif follows" longdesc="img_text/upgrade_01.htm" /><br /> <a id="sthref239" name="sthref239" href="img_text/upgrade_01.htm">Description of the illustration upgrade_01.gif</a><br /> <br /> <p>Click <span class="bold">Next</span>.</p> </li> <li> <p>On the Choose Upgrade Operation page, select <span class="bold">Export entire repository to a file</span>.</p> <img width="530" height="363" src="img/export_01.gif" alt="Description of export_01.gif follows" title="Description of export_01.gif follows" longdesc="img_text/export_01.htm" /><br /> <a id="sthref240" name="sthref240" href="img_text/export_01.htm">Description of the illustration export_01.gif</a><br /> <br /> <p>Click <span class="bold">Next</span>.</p> </li> <li> <p>On the User Information page, enter the user name and password of the 10<span class="italic">g</span> R2 repository owner.</p> <img width="569" height="386" src="img/export_02.gif" alt="Description of export_02.gif follows" title="Description of export_02.gif follows" longdesc="img_text/export_02.htm" /><br /> <a id="sthref241" name="sthref241" href="img_text/export_02.htm">Description of the illustration export_02.gif</a><br /> <br /> <p>Click <span class="bold">Next</span>.</p> </li> <li><a id="CIABFEDC" name="CIABFEDC"></a> <p>On the File Information page, fill these fields:</p> <ul> <li> <p><span class="bold">File Name:</span> the name of the MDL file for storing the repository.</p> </li> <li> <p><span class="bold">Log File:</span> the name of the export operation log file that stores status and statistical information.</p> </li> </ul> <img width="551" height="382" src="img/upgrade_04.gif" alt="Description of upgrade_04.gif follows" title="Description of upgrade_04.gif follows" longdesc="img_text/upgrade_04.htm" /><br /> <a id="sthref242" name="sthref242" href="img_text/upgrade_04.htm">Description of the illustration upgrade_04.gif</a><br /> <br /> <p>Click <span class="bold">Next</span>.</p> </li> <li> <p>On the Summary page, click <span class="bold">Finish</span>.</p> <p>An Export Repository Progress window appears showing progress.</p> <p>At the end of the export process, a status message appears. The export operation creates the file.</p> </li> </ol> </div> <!-- class="sect3" --> <a id="CIAGHBEC" name="CIAGHBEC"></a><a id="WBINS16063" name="WBINS16063"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h4 class="sect3">Importing a File into a Repository</h4> <a id="WBINS16064" name="WBINS16064"></a> <p class="subhead2">To import a file into a repository:</p> <ol> <li> <p>Start the Repository Assistant.</p> <p><span class="bolditalic">In Windows,</span> from the <span class="bold">Start</span> menu, select <span class="bold">Program Files</span>, then <span class="bold">Oracle - OWB112</span>, then <span class="bold">Warehouse Builder</span>, then <span class="bold">Administration</span>, then <span class="bold">Repository Assistant</span>.</p> <p><span class="bolditalic">In Linux,</span> from the command line, run <code><span class="codeinlineitalic">OWB_HOME</span></code><code>/owb/bin/unix/reposinst.sh</code>.</p> </li> <li> <p>On the Welcome page of the Repository Assistant, click <span class="bold">Next</span>.</p> </li> <li> <p>On the Database Information page, enter the host name, port number, and the service name where the OWB is installed.</p> <p>Click <span class="bold">Next</span>.</p> </li> <li> <p>On the Choose Upgrade Operation page, select <span class="bold">Import entire repository from file</span>.</p> <img width="530" height="363" src="img/import_02.gif" alt="Description of import_02.gif follows" title="Description of import_02.gif follows" longdesc="img_text/import_02.htm" /><br /> <a id="sthref243" name="sthref243" href="img_text/import_02.htm">Description of the illustration import_02.gif</a><br /> <br /> <p>Click <span class="bold">Next</span>.</p> </li> <li> <p>On the OWBSYS Information page, enter the password.</p> <img width="511" height="379" src="img/import_01.gif" alt="Description of import_01.gif follows" title="Description of import_01.gif follows" longdesc="img_text/import_01.htm" /><br /> <a id="sthref244" name="sthref244" href="img_text/import_01.htm">Description of the illustration import_01.gif</a><br /> <br /> <p>Click <span class="bold">Next</span>.</p> </li> <li><a id="CIAHDBJA" name="CIAHDBJA"></a> <p>On the File Information page, enter or browse to find the name of the files used when exporting the repository.</p> <img width="551" height="382" src="img/upgrade_04.gif" alt="Description of upgrade_04.gif follows" title="Description of upgrade_04.gif follows" longdesc="img_text/upgrade_04.htm" /><br /> <a id="sthref245" name="sthref245" href="img_text/upgrade_04.htm">Description of the illustration upgrade_04.gif</a><br /> <br /> <p>Click <span class="bold">Next</span>.</p> </li> <li> <p>On the Summary page, click <span class="bold">Finish</span>.</p> <p>The file is imported into a workspace that has the same name as the 10<span class="italic">g</span> R2 OWB repository.</p> </li> </ol> </div> <!-- class="sect3" --></div> <!-- class="sect2" --></div> <!-- class="sect1" --> <a id="CHDBJFGC" name="CHDBJFGC"></a><a id="WBINS07200" name="WBINS07200"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1">Migrating the Repository to a Different Oracle Database Instance</h2> <p>The process of migrating the repository to a different Oracle Database instance involves the export of the existing repository to file, and subsequent import of information from that file into a new repository on the other Oracle Database instance.</p> <p>This process is virtually identical to upgrading from an OWB 10g R2 repository to a current version of the repository. The main difference is that at the time of importing, you would be providing the credentials of a remote Oracle Database instance where the export files reside.</p> <a id="WBINS16065" name="WBINS16065"></a> <div class="sect2"><a id="sthref246" name="sthref246"></a> <h3 class="sect2">Exporting a Repository</h3> <p>The export part of the scenario uses the Repository Assistant to create an MDL zip file. This MDL zip includes information about all the workspaces in the repository, with each workspace stored as a separate file.</p> <p>The export operation is described in section <a href="#CIAJFHEI">"Exporting a Repository to a File"</a>.</p> </div> <!-- class="sect2" --> <a id="WBINS16066" name="WBINS16066"></a> <div class="sect2"><a id="sthref247" name="sthref247"></a> <h3 class="sect2">Importing a Repository</h3> <p>Before importing the repository, in the target Oracle Database instance that contains the migrated repository, create the same users who had access to the original repository. You must do this to ensure that the security information is correctly imported. However, you do not need to create these users as OWB users; the upgrade process handles this automatically.</p> <p>The import operation is described in section <a href="#CIAGHBEC">"Importing a File into a Repository"</a>. Note that in step <a href="#CIAHDBJA">6</a>, you are entering the credential of the source (remote) database, which contains the repository MDL and log files.</p> </div> <!-- class="sect2" --></div> <!-- class="sect1" --> <a id="CHDJJIGA" name="CHDJJIGA"></a><a id="WBINS07300" name="WBINS07300"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1">Upgrading Locations</h2> <p>To upgrade the locations, use the Oracle Warehouse Browser Location Report and Locations Report in the Oracle Warehouse Browser.</p> <ol> <li> <p>In Oracle Warehouse Builder, select Control Center.</p> <p>Click <span class="bold">Reports</span>.</p> </li> <li> <p>In the Reports window, under Deployment, click <span class="bold">Locations Reports</span>.</p> <img width="424" height="315" src="img/locations_01.gif" alt="Description of locations_01.gif follows" title="Description of locations_01.gif follows" longdesc="img_text/locations_01.htm" /><br /> <a id="sthref248" name="sthref248" href="img_text/locations_01.htm">Description of the illustration locations_01.gif</a><br /> <br /></li> <li><a id="CIADGDEB" name="CIADGDEB"></a> <p>On the Locations Report, under Logical Details, in the Validation column of the table, click <span class="bold">Unknown</span>.</p> <img width="457" height="133" src="img/locations_02.gif" alt="Description of locations_02.gif follows" title="Description of locations_02.gif follows" longdesc="img_text/locations_02.htm" /><br /> <a id="sthref249" name="sthref249" href="img_text/locations_02.htm">Description of the illustration locations_02.gif</a><br /> <br /></li> <li> <p>Under Connection details, because the status is Unknown, enter the Password and click <span class="bold">Get Status</span>.</p> <img width="418" height="134" src="img/locations_03.gif" alt="Description of locations_03.gif follows" title="Description of locations_03.gif follows" longdesc="img_text/locations_03.htm" /><br /> <a id="sthref250" name="sthref250" href="img_text/locations_03.htm">Description of the illustration locations_03.gif</a><br /> <br /> <p>Note that the Current Status is Invalid.</p> </li> <li><a id="CIAGABFD" name="CIAGABFD"></a> <p>Under Location Status, click <span class="bold">Upgrade</span>.</p> <img width="418" height="149" src="img/locations_04.gif" alt="Description of locations_04.gif follows" title="Description of locations_04.gif follows" longdesc="img_text/locations_04.htm" /><br /> <a id="sthref251" name="sthref251" href="img_text/locations_04.htm">Description of the illustration locations_04.gif</a><br /> <br /> <p>Note that the Current Status is Valid.</p> </li> <li> <p>Repeat steps <a href="#CIADGDEB">3</a> through <a href="#CIAGABFD">5</a> for all installations.</p> </li> <li> <p>Once you are finished, notice that the Validation column shows Tested locations</p> <img width="457" height="133" src="img/locations_05.gif" alt="Description of locations_05.gif follows" title="Description of locations_05.gif follows" longdesc="img_text/locations_05.htm" /><br /> <a id="sthref252" name="sthref252" href="img_text/locations_05.htm">Description of the illustration locations_05.gif</a><br /> <br /></li> </ol> </div> <!-- class="sect1" --></div> <!-- class="ind" --> <div class="footer"> <hr /> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="33%" /> <col width="*" /> <col width="33%" /> <tr> <td align="left"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="98"> <tr> <td align="center" valign="top"><a href="uninstall.htm"><img width="24" height="24" src="../../dcommon/gifs/leftnav.gif" alt="Go to previous page" /><br /> <span class="icon">Previous</span></a></td> <td align="center" valign="top"><a href="components.htm"><img width="24" height="24" src="../../dcommon/gifs/rightnav.gif" alt="Go to next page" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </td> <td style="font-size: 90%" align="center" class="copyrightlogo"><img width="144" height="18" src="../../dcommon/gifs/oracle.gif" alt="Oracle" /><br /> Copyright © 2000, 2009, Oracle and/or its affiliates. All rights reserved.<br /> <a href="../../dcommon/html/cpyr.htm">Legal Notices</a></td> <td align="right"> <table class="icons oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="245"> <tr> <td align="center" valign="top"><a href="../../index.htm"><img width="24" height="24" src="../../dcommon/gifs/doclib.gif" alt="Go to Documentation Home" /><br /> <span class="icon">Home</span></a></td> <td align="center" valign="top"><a href="../../nav/portal_booklist.htm"><img width="24" height="24" src="../../dcommon/gifs/booklist.gif" alt="Go to Book List" /><br /> <span class="icon">Book List</span></a></td> <td align="center" valign="top"><a href="toc.htm"><img width="24" height="24" src="../../dcommon/gifs/toc.gif" alt="Go to Table of Contents" /><br /> <span class="icon">Contents</span></a></td> <td align="center" valign="top"><a href="index.htm"><img width="24" height="24" src="../../dcommon/gifs/index.gif" alt="Go to Index" /><br /> <span class="icon">Index</span></a></td> <td align="center" valign="top"><a href="../../dcommon/html/feedback.htm"><img width="24" height="24" src="../../dcommon/gifs/feedbck2.gif" alt="Go to Feedback page" /><br /> <span class="icon">Contact Us</span></a></td> </tr> </table> </td> </tr> </table> </div> <noscript> <p>Scripting on this page enhances content navigation, but does not change the content in any way.</p> </noscript> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de