2 Installing Oracle Warehouse Builder on the Server

Installing Oracle Warehouse Builder on Oracle Database 11g Release 2

Oracle Warehouse Builder is part of the standard installation on all hosts running Oracle Database 11g Release 2. When Oracle Database is installed, you must only unlock the OWBSYS and OWBSYS_AUDIT accounts. The OWBSYS schema contains all Oracle Warehouse Builder repository metadata, and the OWBSYS_AUDIT schema is used by the Oracle Warehouse Builder Control Center Agent to access the heterogeneous execution audit tables of the OWBSYS schema.

Managing Optional Features for Oracle Warehouse Builder Installations

Although many features in Oracle Warehouse Builder are included in Oracle Database licenses, some features may require additional licensing. As an administrator, you can assist in managing license compliance by enabling or restricting user access to optional features. The management of optional features as described here is entirely voluntary.

When you first implement an Oracle Warehouse Builder repository, all optional features are enabled by default. You can modify these settings when you create the first workspace for the repository or you can modify the settings at a later time.

To manage the usage of optional features 

1. Start the Repository Assistant. Select Start, Programs, ORACLE_HOME, Warehouse Builder, and then Administration.

2. If you are creating the first workshops for the repository, then the Repository Assistant automatically displays the Enable Optional Features page.

   If you are modifying an existing repository, then on the Choose Operation page, select Manage Optional Features.

3. Select the options you want to make available to Oracle Warehouse Builder users.

   The selections you make are enforced repository-wide and apply to all users. If a user is logged into Oracle Warehouse Builder client when you make changes on the Enable Optional Features page, then the changes are enforced for that user the next time they log in to the client.

Working with Oracle Warehouse Builder Standalone Install Package

There are several situations when you must download and install the Oracle Warehouse Builder 11g Release 2 standalone install package:

• You are installing Oracle Warehouse Builder 11.2 and hosting an Oracle Warehouse Builder Repository on an earlier release:

  Oracle Database 10g Release 1, Oracle Database 10g Release 2,

  or

  Oracle Database 11g Release 1.

• You run the Oracle Warehouse Builder 11.2 Design Client on a developer's computer.

• You are installing Oracle Warehouse Builder 11.2 on a computer that runs the Control Center Agent.

To obtain Oracle Warehouse Builder Standalone Software:

1. Navigate the browser to the following URL:

   http://www.oracle.com/technetwork/developer-tools/warehouse/overview/index.html/
   

2. On the right side of the page, click All Releases and Platforms.

   
   Description of the illustration download_01.gif
   
   

3. Under Oracle Warehouse Builder Downloads, select Accept for the licence agreement.

   
   Description of the illustration download_03.gif
   
   

   The system displays the following message: "Thank you for accepting the OTN License Agreement; you may now download this software."

4. Under the Standalone Software download, click the down arrow beside the platform of your choice to download the zip file that contains Oracle Warehouse Builder.

   On Windows: choose the Microsoft Windows option.

   On Linux: choose the Linux x86 option.

   
   Description of the illustration download_04.gif
   
   

5. When the download is complete, extract the zip file into a temporary directory. For example,

   On Windows: use C:\temp\OWB.

   On Linux: use /temp/OWB.

Installing Oracle Warehouse Builder Through Oracle Universal Installer

After you obtain the standalone installation files for Oracle Warehouse Builder and extract them, you must install the software.

To install Oracle Warehouse Builder using Oracle Universal Installer:

1. In Windows Explorer, navigate to the directory that contains the extracted Oracle Warehouse Builder installation files. In this discussion the sample directory is C:\temp\OWB.

2. Click the setup.bat file to start the Universal Installer.

   
   Description of the illustration install_01.gif
   
   

3. On the Welcome screen, click Next.

   
   Description of the illustration install_02.gif
   
   

4. On the Specify Home Details screen, specify a new Oracle home:

   • Enter the Oracle home Name, for example, OWB112.

   • Enter or browse to Path C:\.

   • Click Next.

   
   Description of the illustration install_03.gif
   
   

   Tip:

   To ensure a successful installation:

   • Do not use an existing Oracle home.

   • Do not use any spaces in the directory path.

5. [Optional] On the Customer Support Email screen, enter the Email and Password for your My Oracle Support account.

   Click Next.

   
   Description of the illustration install_08.gif
   
   

6. On the Summary screen, click Install.

   
   Description of the illustration install_04.gif
   
   

7. The Install screen shows progress during the installation process.

   
   Description of the illustration install_05.gif
   
   

8. At the End of Installation screen, click Exit. The Exit message appears asking if you really want to exit.

   
   Description of the illustration install_06.gif
   
   

9. In the Exit message, click Yes.

   
   Description of the illustration install_07.gif
   
   

Installing Oracle Warehouse Builder in Oracle RAC Environments

The overall process for installing on an Oracle RAC environment is similar to the general process for installing a single-instance database. However, there are a few specific details to observe as noted in this section.

To install and configure Oracle Warehouse Builder for Oracle RAC:

1. Create the Oracle RAC environment as described in Oracle Real Application Clusters Installation Guide specific to your platform. Cross references to generic installation guides are given after the last step of this procedure.

2. If you have not done so, review the most recent Oracle Warehouse Builder Release Notes available with the installation media.

   See Also:

   • Note ID 810394.1 "Oracle RAC and Oracle Clusterware Starter Kit and Best Practices" on My Oracle Support at https://support.oracle.com

   • Oracle Database Release 11.2 documentation library page at http://www.oracle.com/pls/db112/homepage

   • The product download page on at http://www.oracle.com/technetwork/indexes/downloads/index.html

3. Prepare the host computers.

   For each computer to host Oracle Warehouse Builder components, configure the tnsnames.ora file located in the OWB_HOME\owb\network\admin directory.

4. Configure tnsnames.ora for each Oracle Database server to be an Oracle Warehouse Builder data source or target. If you fail to configure tnsnames.ora for any host or database server, then you may encounter a repository connection error.

   See Also:

   "ORA-12154: TNS: Could not resolve service name." for troubleshooting.

5. (Optional.) If necessary, install Oracle Warehouse Builder standalone software. However, this is generally not necessary because Oracle Warehouse Builder is installed as part of every Oracle Database 11g Release 2 installation.

6. Create your first workspace within Oracle Warehouse Builder Repository. The Repository Assistant prompts you and guides you with procedures.

   To start the Repository Assistant on Windows, from the Windows Start menu, select Programs and navigate to the Oracle product group you installed in the previous step. Select Oracle Warehouse Builder, Administration, and then Repository Assistant.

   To start the Repository Assistant on UNIX, locate OWB_HOME/owb/bin/unix and run reposinst.sh.

7. Register each Oracle RAC node.

   For each node, start the Repository Assistant and select the Advanced Set Up option. Connect to the node using Host:Port:Sid, where Host is the physical node name. Select the option for registering the Oracle RAC instance.

8. If the software is installed on separate disks, copy rtrepos.properties to each node in the cluster.

   If you did not install to a shared disk, then you must manually copy the file OWB_HOME/owb/bin/admin/rtrepos.properties from the primary node to each node in the cluster.

9. Install the Oracle Warehouse Builder software on the client computers.

   Repeat the procedure in "Installing Oracle Warehouse Builder on Oracle Database 11g Release 2" for each computer to be used as a client.

10. After completing the installation process, you can start all the Oracle Warehouse Builder components.

    Because you can connect to Oracle Warehouse Builder repositories using a net service name, you can embed Oracle RAC properties into the connect string to use Oracle RAC capabilities such as connect time failover, load balancing on server and load balancing of connections.

11. Refer to, "Ensuring the Availability of Service Names for Oracle RAC Nodes".

    The Control Center Service requires that service names for the individual nodes in the cluster be available. If these are not present after the Oracle RAC installation, then you must manually ensure the availability.

Performing a Silent Install and Using Response Values

An Oracle Universal Installer silent installation runs in the background and does not require input from the user. Instead of prompting the user to select a series of installation options, the software uses a pre-defined set of options stored in a response file or passed on the command line.

A response file specifies the information normally provided by the user to Oracle Universal Installer interface during an interactive installation session. Each answer is stored as a value for a variable identified in the response file. For example, values for Oracle home or install type can be set automatically within the response file.The response file template for the installation of your product can be found on your stage (CD-ROM) under the root_of_CD/response directory, such as:

Products.xml_Location/Response/product.installtype.rsp

To perform a silent installation of Oracle Warehouse Builder 

• Open a Command window and navigate to the directory containing the response file that is used for the silent installation. Use the following command to start the silent installation:

  On Windows, enter setup -responseFile filename optional_parameters

  On Linux, enter runInstaller -responseFile filename optional_parameters

For this procedure, filename represents the name of the response file (including the complete path) and optional_parameters represents the parameters used for the silent installation.

After the Installation is Complete

After Oracle Warehouse Builder software is installed on your computer, you must configure it.

For steps on configuring Oracle Warehouse Builder on Linux, see Chapter 4, "Configuring Oracle Warehouse Builder for Linux".

For steps on configuring Oracle Warehouse Builder on Microsoft Windows, see Chapter 3, "Configuring Oracle Warehouse Builder for Windows".