Edit D:\rfid\database\database\doc\owb.112\e10579\setup_linux.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:20Z" /> <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="setup_windows.htm" title="Previous" type="text/html" /> <link rel="Next" href="uninstall.htm" title="Next" type="text/html" /> <link rel="alternate" href="../e10579.pdf" title="PDF version" type="application/pdf" /> <title>Configuring Oracle Warehouse Builder for Linux</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="setup_windows.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="uninstall.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="BABBCHHE" name="BABBCHHE"></a><a id="WBINS04000" name="WBINS04000"></a> <h1 class="chapter"><span class="secnum">4</span> <a id="sthref123" name="sthref123"></a>Configuring Oracle Warehouse Builder for Linux</h1> <p>This section discusses how to configure Oracle Warehouse Builder on Linux platforms.</p> <p>This section includes the following topics:</p> <ul> <li> <p><a href="#BABBJHAB">Configuring OWB Installed as Part of Oracle Database 11<span class="italic">g</span> Release 2</a></p> </li> <li> <p><a href="#BABFJDBI">Configuring OWB Installed as a Standalone Instance</a></p> </li> <li> <p><a href="#BABHEIIG">Creating the First Workspace in the Repository</a></p> </li> </ul> <div class="infoboxnote"> <p class="notep1">Note:</p> The initial installation of Oracle Warehouse Builder must be made on the computer that hosts the OWB Repository.</div> <a id="BABBJHAB" name="BABBJHAB"></a><a id="WBINS16034" name="WBINS16034"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1"><a id="sthref124" name="sthref124"></a>Configuring OWB Installed as Part of Oracle Database 11<span class="italic">g</span> Release 2</h2> <p>Oracle Warehouse builder is part of every database installation on hosts running Oracle Database 11<span class="italic">g</span> Release 2.</p> <p>Once Oracle Database 11<span class="italic">g</span> Release 2 is installed, you only have to unlock two accounts: <code>OWBSYS</code> and <code>OWBSYS_AUDIT</code>.</p> <p>There are no additional installation tasks.</p> <a id="WBINS16035" name="WBINS16035"></a> <p class="subhead2"><a id="sthref125" name="sthref125"></a><a id="sthref126" name="sthref126"></a>To unlock OWBSYS and OWBSYS_AUDIT accounts:</p> <ol> <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 13:06:27 2009 Copyright (c) 1982, 2009, Oracle. All rights reserved. </pre></li> <li> <p>When prompted for user name, log in as a user with administrative privileges.</p> <pre xml:space="preserve" class="oac_no_warn">Enter user-name: <span class="bold">sys as sysdba</span> Enter password: <span class="bolditalic">password</span> Connected to: Oracle Database 11g Enterprise Edition Release 11.2 - Production With the Partitioning, OLAP and Data Mining options </pre></li> <li> <p>Unlock the <code>OWBSYS</code> user account, and set its new password:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> <span class="bold">alter user owbsys identified by </span><span class="bolditalic">password</span> <span class="bold">account unlock;</span> User altered. </pre></li> <li> <p>Unlock the <code>OWBSYS_AUDIT</code> user account, and set its new password:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> <span class="bold">alter user owbsys_audit identified by </span><span class="bolditalic">password</span> <span class="bold">account unlock;</span> User altered. </pre></li> </ol> </div> <!-- class="sect1" --> <a id="BABFJDBI" name="BABFJDBI"></a><a id="WBINS16036" name="WBINS16036"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1"><a id="sthref127" name="sthref127"></a>Configuring OWB Installed as a Standalone Instance</h2> <p>This section contains the following topics:</p> <ul> <li> <p><a href="#BABDFFEJ">"About Configuring OWB Installed as a Standalone Instance"</a></p> </li> <li> <p><a href="#BABHIJGB">"Cleaning an Oracle Warehouse Builder Repository"</a></p> </li> <li> <p><a href="#BABECBJG">"Creating an OWBSYS Schema with Repository Objects"</a></p> </li> <li> <p><a href="#BABJGEEB">"Configuring the Control Center Service"</a></p> </li> <li> <p><a href="#BABDJDBJ">"Unlocking the OWBSYS and OWBSYS_AUDIT Accounts"</a></p> </li> </ul> <a id="BABDFFEJ" name="BABDFFEJ"></a><a id="WBINS16037" name="WBINS16037"></a> <div class="sect2"> <h3 class="sect2">About Configuring OWB Installed as a Standalone Instance</h3> <p>To properly configure Oracle Warehouse Builder and its repository on a host that runs an earlier version of the database, such as Oracle Database 10<span class="italic">g</span> Release 2, you must:</p> <ul> <li> <p>Ensure that the database is fully installed and working; if you it is not, see <a class="olink LTDQI" href="http://www.oracle.com/pls/db112/lookup?id=LTDQI"><span class="italic">Oracle Database Quick Installation Guide for Linux x86-64</span></a>.</p> </li> <li> <p>Note of the host name, the port, and Oracle service name of this database. The example here uses the following connection information: <code>localhost:1521:orcl</code>.</p> </li> <li> <p>Ensure that you have username and password for an account with <code>SYSDBA</code> privileges. The <code>SYSDBA</code> role has the necessary privileges for making changes to the basic configuration of Oracle Database, Oracle Warehouse Builder, and OWB Repository.</p> </li> </ul> <p>To create an Oracle Warehouse Builder repository in your database, you must first create an <code>OWBSYS</code> schema, and then install repository objects within it. Oracle Warehouse Builder has command-level scripts to perform this task:</p> <ul> <li> <p>The <code><a id="sthref128" name="sthref128"></a>clean_owbsys.sql</code> script drops the contents of any existing <code>OWBSYS</code> schema installations, but leaves the schema otherwise intact.</p> </li> <li> <p>The <a id="sthref129" name="sthref129"></a><code>cat_owb.sql</code> script checks if an <code>OWBSYS</code> schema exists, and creates it if necessary, and then installs the objects required by Oracle Warehouse Builder 11.2 repository.</p> </li> <li> <p>The <a id="sthref130" name="sthref130"></a><code>reset_owbcc_home.sql</code> script ensures that Oracle Warehouse Builder uses the 11.2 version of the Control Center Service.</p> </li> <li> <p>[Optional] The <code><a id="sthref131" name="sthref131"></a>remote_owb_install.sql</code> script, when executed on the server, ensures that a repository on a remote system can be installed; it sets the <code><span class="codeinlineitalic">REMOTE_OWB_HOME</span></code> variable for authentication by remote systems.</p> </li> </ul> <p>Starting with Oracle Warehouse Builder 11.1, the <a id="sthref132" name="sthref132"></a>metadata repository is stored in the <code>OWBSYS</code> schema, inside a <a id="sthref133" name="sthref133"></a>workspace. This contrasts with the terminology of Oracle Warehouse Builder 10.2, where a workspace corresponds to a repository.</p> <p>Oracle Warehouse Builder repositories for version 11.2 and 11.1 cannot coexist on the same database; creating an 11.2 repository overwrites the contents of the 11.1 repository in the database. Oracle recommends that you back up the older OWB repositories before installing the 11.2 repository or upgrading to the 11.2 repository.</p> </div> <!-- class="sect2" --> <a id="BABHIJGB" name="BABHIJGB"></a><a id="WBINS16038" name="WBINS16038"></a> <div class="sect2"> <h3 class="sect2"><a id="sthref134" name="sthref134"></a><a id="sthref135" name="sthref135"></a>Cleaning an Oracle Warehouse Builder Repository</h3> <a id="WBINS16039" name="WBINS16039"></a> <p class="subhead2">To clean an existing Oracle Warehouse Builder repository:</p> <ol> <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 13:14:43 2009 Copyright (c) 1982, 2009, Oracle. All rights reserved. </pre></li> <li> <p>When prompted for user name, log in as <code>OWBSYS</code> user.</p> <pre xml:space="preserve" class="oac_no_warn">Enter user-name: <span class="bold">owbsys</span> Enter password: <span class="bolditalic">password</span> Connected to: Oracle Database 11g Enterprise Edition Release 11.2 - Production With the Partitioning, OLAP and Data Mining options </pre></li> <li> <p><a id="sthref136" name="sthref136"></a>Stop Oracle Warehouse Builder Control Center service.</p> <pre xml:space="preserve" class="oac_no_warn">SQL> <span class="bold">@OWB112/owb/rtp/sql/stop_service.sql</span> </pre> <p>See <a href="control_ctr_mgmt.htm#CJABCGHG">"stop_service"</a> for more information.</p> </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>Run the <a id="sthref137" name="sthref137"></a><code>clean_owbsys.sql</code> script to drop all the objects in the existing <code>OWBSYS</code> schema:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> <span class="bold">@OWB112/owb/UnifiedRepos/clean_owbsys.sql</span> </pre></li> </ol> </div> <!-- class="sect2" --> <a id="BABECBJG" name="BABECBJG"></a><a id="WBINS16040" name="WBINS16040"></a> <div class="sect2"> <h3 class="sect2">Creating an <a id="sthref138" name="sthref138"></a><a id="sthref139" name="sthref139"></a>OWBSYS Schema with<a id="sthref140" name="sthref140"></a> Repository Objects</h3> <p>The process of creating (or refreshing) an <code>OWBSYS</code> schema generates the corresponding locked user account within the specified tablespace. In this example, the tablespace is <a id="sthref141" name="sthref141"></a><code>USERS</code>. When the script completes, you have to unlock the account and set its password; the instructions in <a href="#BABBJHAB">"Configuring OWB Installed as Part of Oracle Database 11<span class="italic">g</span> Release 2"</a> show how to unlock <code>OWBSYS</code> and <code>OWBSYS_AUDIT</code> accounts. Note that the <code>OWBSYS</code> schema is populated only when you run the <a id="sthref142" name="sthref142"></a><a id="sthref143" name="sthref143"></a>Repository Assistant for the first time and create the first workspace in the repository.</p> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <a href="appendix_troubleshooting.htm#CHDEDEHC">"Configuring OWB for RAC"</a></div> <a id="WBINS16041" name="WBINS16041"></a> <p class="subhead2">To set-up an OWBSYS schema with repository objects:</p> <ol> <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 13:22:11 2009 Copyright (c) 1982, 2009, Oracle. All rights reserved. </pre></li> <li> <p>When prompted for user name, log in as a user with administrative privileges.</p> <pre xml:space="preserve" class="oac_no_warn">Enter user-name: <span class="bold">sys as sysdba</span> Enter password: <span class="bolditalic">password</span> Connected to: Oracle Database 11g Enterprise Edition Release 11.2 - Production With the Partitioning, OLAP and Data Mining options </pre></li> <li> <p><a id="sthref144" name="sthref144"></a>Run the <code>cat_owb.sql</code> script to set up <code>OWBSYS</code> in a tablespace in your database. For example, this command sets up <code>OWBSYS</code> in the <code>USERS</code> tablespace:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> <span class="bold">@OWB112/owb/UnifiedRepos/cat_owb.sql USERS</span> </pre></li> </ol> </div> <!-- class="sect2" --> <a id="BABJGEEB" name="BABJGEEB"></a><a id="WBINS16042" name="WBINS16042"></a> <div class="sect2"> <h3 class="sect2"><a id="sthref145" name="sthref145"></a><a id="sthref146" name="sthref146"></a>Configuring the Control Center Service</h3> <p>If you are installing OWB 11.2 on an older Oracle Database release, or if you integrating OWB with Oracle Business Intelligence Standard Edition (Oracle Discoverer), you must run the <code>reset_owbcc_home.sql</code> script to ensure that the Control Center Service functions correctly.</p> <a id="WBINS16043" name="WBINS16043"></a> <p class="subhead2">To configure the Control Center service:</p> <ol> <li> <p>Confirm the correct Oracle Home path, paying particular attention to capitalization. In this example, the path is <code>OWB112</code>.</p> <p>The path entered in the next steps must be an exact match to the Oracle Warehouse Builder home directory, including letter case match.</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 13:47:31 2009 Copyright (c) 1982, 2009, Oracle. All rights reserved. </pre></li> <li> <p>When prompted for user name, log in as a user with administrative privileges.</p> <pre xml:space="preserve" class="oac_no_warn">Enter user-name: <span class="bold">sys as sysdba</span> Enter password: <span class="bolditalic">password</span> Connected to: Oracle Database 11g Enterprise Edition Release 11.2 - Production With the Partitioning, OLAP and Data Mining options </pre></li> <li> <p>Run the <code><a id="sthref147" name="sthref147"></a><a id="sthref148" name="sthref148"></a>reset_owbcc_home.sql</code> script to force the Control Center Service to run from Oracle Warehouse Builder 11.2 installation:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> <span class="bold">@OWB112/owb/UnifiedRepos/reset_owbcc_home.sql OWB112</span> </pre></li> </ol> </div> <!-- class="sect2" --> <a id="BABDJDBJ" name="BABDJDBJ"></a><a id="WBINS16044" name="WBINS16044"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2"><a id="sthref149" name="sthref149"></a><a id="sthref150" name="sthref150"></a>Unlocking the OWBSYS and OWBSYS_AUDIT Accounts</h3> <a id="WBINS16045" name="WBINS16045"></a> <p class="subhead2">To unlock OWBSYS and OWBSYS_AUDIT accounts:</p> <ol> <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 13:57:03 2009 Copyright (c) 1982, 2009, Oracle. All rights reserved. </pre></li> <li> <p>When prompted for user name, log in as a user with administrative privileges.</p> <pre xml:space="preserve" class="oac_no_warn">Enter user-name: <span class="bold">sys as sysdba</span> Enter password: <span class="bolditalic">password</span> Connected to: Oracle Database 11g Enterprise Edition Release 11.2 - Production With the Partitioning, OLAP and Data Mining options </pre></li> <li> <p>Unlock the <code>OWBSYS</code> user account, and set its new password:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> <span class="bold">alter user owbsys identified by </span><span class="bolditalic">password</span> <span class="bold">account unlock;</span> User altered. </pre></li> <li> <p>Unlock the <code>OWBSYS_AUDIT</code> user account, and set its new password:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> <span class="bold">alter user owbsys_audit identified by </span><span class="bolditalic">password</span> <span class="bold">account unlock;</span> User altered. </pre></li> </ol> </div> <!-- class="sect2" --> <a id="CHDGHFDB" name="CHDGHFDB"></a><a id="WBINS16361" name="WBINS16361"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2"><a id="sthref151" name="sthref151"></a><a id="sthref152" name="sthref152"></a>Setting the OWB Home for Remote Installations</h3> <p>You must create a database directory <code>OWB_REMOTE_ADMIN</code> that is accessed by remote installations, so they can read the server's <code><span class="codeinlineitalic">OWB_HOME</span></code><code>/owb/bin/admin</code> directory.</p> <ol> <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 14:06:12 2009 Copyright (c) 1982, 2009, Oracle. All rights reserved. </pre></li> <li> <p>When prompted for user name, log in as a user with administrative privileges.</p> <pre xml:space="preserve" class="oac_no_warn">Enter user-name: <span class="bold">sys as sysdba</span> Enter password: <span class="bolditalic">password</span> Connected to: Oracle Database 11g Enterprise Edition Release 11.2 - Production With the Partitioning, OLAP and Data Mining options </pre></li> <li> <p>Set the <code><span class="codeinlineitalic">OWB_REMOTE_HOME</span></code> variable using script <code>remote_owb_install.sql</code>:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> <a id="sthref153" name="sthref153"></a><span class="bold">@OWB112/owb/UnifiedRepos/remote_owb_install.sql</span> <span class="codeinlineboldital">OWB_REMOTE_HOME</span> </pre></li> </ol> </div> <!-- class="sect2" --></div> <!-- class="sect1" --> <a id="BABHEIIG" name="BABHEIIG"></a><a id="WBINS16046" name="WBINS16046"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1"><a id="sthref154" name="sthref154"></a><a id="sthref155" name="sthref155"></a>Creating the First Workspace in the Repository</h2> <p>To use a repository, you must define an initial workspace, and the owner of that workspace. The following instructions use the R<a id="sthref156" name="sthref156"></a>epository Assistant.</p> <a id="WBINS16047" name="WBINS16047"></a> <p class="subhead2">To create a workspace:</p> <ol> <li> <p>At the command prompt, navigate to the UNIX <code>bin</code> directory:</p> <pre xml:space="preserve" class="oac_no_warn">% <span class="bold">cd OWB112/owb/bin/unix</span> % <span class="bold">pwd</span> OWB112/owb/bin/unix </pre></li> <li> <p>Start the repository assistant.</p> <pre xml:space="preserve" class="oac_no_warn">% <span class="bold">./reposinst.sh</span> </pre></li> <li> <p>On the Welcome screen of the Repository assistant, click <span class="bold">Next</span>.</p> <img width="694" height="420" src="img/workspace_02.gif" alt="Description of workspace_02.gif follows" title="Description of workspace_02.gif follows" longdesc="img_text/workspace_02.htm" /><br /> <a id="sthref157" name="sthref157" href="img_text/workspace_02.htm">Description of the illustration workspace_02.gif</a><br /> <br /></li> <li> <p>On the Database Information screen, enter the connection information (<a id="sthref158" name="sthref158"></a><a id="sthref159" name="sthref159"></a>Host Name, Port Number, and Oracle Service Name) for the repository database, and click <span class="bold">Next</span>.</p> <img width="692" height="422" src="img/workspace_03.gif" alt="Description of workspace_03.gif follows" title="Description of workspace_03.gif follows" longdesc="img_text/workspace_03.htm" /><br /> <a id="sthref160" name="sthref160" href="img_text/workspace_03.htm">Description of the illustration workspace_03.gif</a><br /> <br /></li> <li> <p>On the Choose Operation screen, select <span class="bold"><a id="sthref161" name="sthref161"></a><a id="sthref162" name="sthref162"></a>Manage Warehouse Builder Workspaces</span>. Click <span class="bold">Next</span>.</p> <img width="554" height="420" src="img/workspace_04.gif" alt="Description of workspace_04.gif follows" title="Description of workspace_04.gif follows" longdesc="img_text/workspace_04.htm" /><br /> <a id="sthref163" name="sthref163" href="img_text/workspace_04.htm">Description of the illustration workspace_04.gif</a><br /> <br /></li> <li> <p>On the Choose Workspace Operations screen, select <span class="bold"><a id="sthref164" name="sthref164"></a><a id="sthref165" name="sthref165"></a>Create a New Warehouse Builder workspace</span>. Click <span class="bold">Next</span>.</p> <img width="698" height="408" src="img/workspace_05.gif" alt="Description of workspace_05.gif follows" title="Description of workspace_05.gif follows" longdesc="img_text/workspace_05.htm" /><br /> <a id="sthref166" name="sthref166" href="img_text/workspace_05.htm">Description of the illustration workspace_05.gif</a><br /> <br /></li> <li> <p>On the New or Existing User screen, select <span class="bold">Create a workspace with a new workspace owner</span>. Click <span class="bold">Next</span>.</p> <img width="698" height="436" src="img/workspace_06.gif" alt="Description of workspace_06.gif follows" title="Description of workspace_06.gif follows" longdesc="img_text/workspace_06.htm" /><br /> <a id="sthref167" name="sthref167" href="img_text/workspace_06.htm">Description of the illustration workspace_06.gif</a><br /> <br /></li> <li> <p>On the DBA Information screen, enter the <span class="bold">User Name</span> of a user with a <code>CREATE USER</code> privilege, and that user's <span class="bold">Password</span>.</p> <p>Click <span class="bold">Next</span>.</p> <img width="698" height="426" src="img/workspace_07.gif" alt="Description of workspace_07.gif follows" title="Description of workspace_07.gif follows" longdesc="img_text/workspace_07.htm" /><br /> <a id="sthref168" name="sthref168" href="img_text/workspace_07.htm">Description of the illustration workspace_07.gif</a><br /> <br /></li> <li> <p>In the Workspace Owner (New) screen, enter the following information:</p> <ul> <li> <p>Workspace Owner's User Name (<code>wks_owner1</code>)</p> </li> <li> <p>Workspace Owner's Password</p> </li> <li> <p>Workspace Owner's Password Confirmation</p> </li> <li> <p>Workspace Name (<code>wks1</code>)</p> </li> </ul> <p>Click <span class="bold">Next</span>.</p> <img width="698" height="435" src="img/workspace_08.gif" alt="Description of workspace_08.gif follows" title="Description of workspace_08.gif follows" longdesc="img_text/workspace_08.htm" /><br /> <a id="sthref169" name="sthref169" href="img_text/workspace_08.htm">Description of the illustration workspace_08.gif</a><br /> <br /></li> <li> <p>In the <code>OWBSYS</code> Information screen, enter the <code>OWBSYS</code> <span class="bold">Password</span>. Click <span class="bold">Next</span>.</p> <p>Note that you need these credentials to seed the <code>OWBSYS</code> schema.</p> <img width="592" height="438" src="img/workspace_09.gif" alt="Description of workspace_09.gif follows" title="Description of workspace_09.gif follows" longdesc="img_text/workspace_09.htm" /><br /> <a id="sthref170" name="sthref170" href="img_text/workspace_09.htm">Description of the illustration workspace_09.gif</a><br /> <br /></li> <li> <p><a id="sthref171" name="sthref171"></a>[Optional] For remote installations (when you the schema is on a remote system), the system performs the verification of versions, and displays the dialog "Found OWB software with the compatible version installed locally on the database server machine with path <code>REMOTE_OWB_HOME</code>."</p> <p>If the version is either incompatible or cannot be found, then the system displays the dialog "OWB software with the compatible version must be installed locally on the database server machine". If it is installed, acquire the DBA user credentials, and run the <code>remote_owb_install.sql</code> script on the Oracle Database server machine, as described in <a href="#CHDGHFDB">"Setting the OWB Home for Remote Installations"</a>.</p> </li> <li> <p>On the <a id="sthref172" name="sthref172"></a>Select Tablespaces screen, enter the following information:</p> <ul> <li> <p>Tablespace for Data (<code>USERS</code>, or the name of the desired tablespace)</p> </li> <li> <p>Tablespace for Indexes (<code>USERS</code>, or the name of the same tablespace)</p> </li> <li> <p>Tablespace for Temporary Data (<code>TEMP</code>)</p> </li> <li> <p>Tablespace for Snapshots (<code>USERS</code>, or the name of the same tablespace)</p> </li> </ul> <p>Click <span class="bold">Next</span>.</p> <p>Note that this step allows you to change the default tablespace details. The OWB repository is stored in the <code>OWBSYS</code> schema, but you must identify what tablespaces are used to store <code>OWBSYS</code> and certain other objects, like snapshots. You may choose tablespaces other than <code>USERS</code>, depending on your storage management strategy.</p> <img width="592" height="432" src="img/workspace_10.gif" alt="Description of workspace_10.gif follows" title="Description of workspace_10.gif follows" longdesc="img_text/workspace_10.htm" /><br /> <a id="sthref173" name="sthref173" href="img_text/workspace_10.htm">Description of the illustration workspace_10.gif</a><br /> <br /></li> <li> <p>On the <a id="sthref174" name="sthref174"></a><a id="sthref175" name="sthref175"></a>Select Languages screen, select the Base Language from the menu.</p> <p>[Optional] You may also select additional Display Languages from the list of Available languages on the left side, and move them to the list of Selected languages on the right side.</p> <p>Click <span class="bold">Next</span>.</p> <img width="652" height="544" src="img/workspace_11.gif" alt="Description of workspace_11.gif follows" title="Description of workspace_11.gif follows" longdesc="img_text/workspace_11.htm" /><br /> <a id="sthref176" name="sthref176" href="img_text/workspace_11.htm">Description of the illustration workspace_11.gif</a><br /> <br /></li> <li> <p>On the <a id="sthref177" name="sthref177"></a><a id="sthref178" name="sthref178"></a>Workspace Users (Optional) screen, select the appropriate existing users from the <span class="bold">Available</span> list add them to the <span class="bold">Selected</span> list.</p> <p>[Optional] Click <span class="bold">Create New User</span> to make new users who can access OWB. This takes you to step <a href="#CHDBDHGJ">15</a>.</p> <p>Click <span class="bold">Next</span>. This takes you to step <a href="#CHDCBHJC">17</a>.</p> <img width="624" height="440" src="img/workspace_12.gif" alt="Description of workspace_12.gif follows" title="Description of workspace_12.gif follows" longdesc="img_text/workspace_12.htm" /><br /> <a id="sthref179" name="sthref179" href="img_text/workspace_12.htm">Description of the illustration workspace_12.gif</a><br /> <br /></li> <li><a id="CHDBDHGJ" name="CHDBDHGJ"></a> <p>[Optional] In the <a id="sthref180" name="sthref180"></a><a id="sthref181" name="sthref181"></a>Create New Database User screen, enter the following:</p> <ul> <li> <p>User Name (<code>demo_user</code>)</p> </li> <li> <p>Password</p> </li> <li> <p>Re-enter Password</p> </li> </ul> <p>Click <span class="bold">OK</span>.</p> <p>Note that DBA User Name (<code>system</code>) and DBA User Password are disabled fields and cannot be edited.</p> <img width="416" height="296" src="img/workspace_13.gif" alt="Description of workspace_13.gif follows" title="Description of workspace_13.gif follows" longdesc="img_text/workspace_13.htm" /><br /> <a id="sthref182" name="sthref182" href="img_text/workspace_13.htm">Description of the illustration workspace_13.gif</a><br /> <br /></li> <li> <p>In the Workspace Users (Optional) screen, click <span class="bold">Next</span>.</p> <img width="662" height="492" src="img/workspace_14.gif" alt="Description of workspace_14.gif follows" title="Description of workspace_14.gif follows" longdesc="img_text/workspace_14.htm" /><br /> <a id="sthref183" name="sthref183" href="img_text/workspace_14.htm">Description of the illustration workspace_14.gif</a><br /> <br /></li> <li><a id="CHDCBHJC" name="CHDCBHJC"></a> <p>On the Summary screen, click <span class="bold">Finish</span>.</p> <img width="536" height="442" src="img/workspace_15.gif" alt="Description of workspace_15.gif follows" title="Description of workspace_15.gif follows" longdesc="img_text/workspace_15.htm" /><br /> <a id="sthref184" name="sthref184" href="img_text/workspace_15.htm">Description of the illustration workspace_15.gif</a><br /> <br /></li> <li> <p>Once the Installation Result screen appears, click <span class="bold">OK</span>.</p> <img width="268" height="146" src="img/workspace_16.gif" alt="Description of workspace_16.gif follows" title="Description of workspace_16.gif follows" longdesc="img_text/workspace_16.htm" /><br /> <a id="sthref185" name="sthref185" href="img_text/workspace_16.htm">Description of the illustration workspace_16.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="setup_windows.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="uninstall.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