Skip Headers
Oracle® Warehouse Builder Installation and Administration Guide
11g Release 2 (11.2) for Windows and Linux

Part Number E17130-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

2 Installing Oracle Warehouse Builder on the Server

This section discusses how to install Oracle Warehouse Builder on Windows platforms.

This section includes the following topics:

Installing 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 Warehouse Builder repository metadata, and the OWBSYS_AUDIT schema is used by the Warehouse Builder Control Center Agent to access the heterogeneous execution audit tables of the OWBSYS schema.

Managing Optional Features for Warehouse Builder Installations

Although many features in Warehouse Builder are included in Oracle Database licenses, there are features that 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 a 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 workspace 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 Warehouse Builder users.

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

Note:

For more information about each option, refer to the appropriate Oracle licensing information guide, listed on Oracle Technology Network at http://www.oracle.com/technology/products/warehouse/htdocs/licensing.html

Working with the Warehouse Builder Standalone Install Package

There are several situations when you must download and install the OWB 11g Release 2 Standalone Install Package:

To obtain Oracle Warehouse Builder standalone software:

  1. Navigate the browser to the following URL:

    http://www.oracle.com/technology/products/warehouse/
    
  2. On the right side of the page, click All Releases and Platforms.

    Description of download_01.gif follows
    Description of the illustration download_01.gif

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

    Description of download_03.gif follows
    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.

    For Windows: choose the Microsoft Windows option.

    For Linux: choose the Linux x86 option.

    Description of download_04.gif follows
    Description of the illustration download_04.gif

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

    For Windows: use C:\temp\OWB.

    For 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 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 install_01.gif follows
    Description of the illustration install_01.gif

  3. On the Welcome screen, click Next.

    Description of install_02.gif follows
    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 install_03.gif follows
    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 install_08.gif follows
    Description of the illustration install_08.gif

  6. On the Summary screen, click Install.

    Description of install_04.gif follows
    Description of the illustration install_04.gif

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

    Description of install_05.gif follows
    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 install_06.gif follows
    Description of the illustration install_06.gif

  9. In the Exit message, click Yes.

    Description of install_07.gif follows
    Description of the illustration install_07.gif

Installing 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 Warehouse Builder for Oracle RAC:

  1. Create the Oracle RAC environment as described in the 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:

  3. Prepare the host computers.

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

  4. Configure tnsnames.ora for each Oracle Database server to be a 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.

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

  6. Define users and an owner for the 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 Warehouse Builder, Administration, and then Repository Assistant.

    To start the Repository Assistant on UNIX, locate OWB_ORACLE_HOME/owb/bin/ 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_ORACLE_HOME/owb/bin/admin/rtrepos.properties from the primary node to each node in the cluster.

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

    Repeat the procedure in "Installing 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 Warehouse Builder components.

    Because you can connect to 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.

Installing Warehouse Builder on Each Node of a Cluster

Whether you are installing Warehouse Builder components onto a server or a client computer, you use the Oracle Universal Installer to install Warehouse Builder components.

For Oracle RAC, it is recommended that you install the Warehouse Builder components on each node of the cluster. The Control Center Service is required on to each node of the Oracle RAC cluster.You can achieve this in a single installation of the Warehouse Builder software if you install on a shared disk such as an OCFS or NTS shared disk.

Before launching Oracle Universal Installer, review and complete the "Checklist: Before Using the Universal Installer in an Oracle RAC Environment".

Checklist: Before Using the Universal Installer in an Oracle RAC Environment

This section contains additional points to address before launching the Universal Installer:

  • If you have not done so, review the latest Oracle Warehouse Builder Release Notes at http://www.oracle.com/technology/.

  • The installed location must be the same directory path if using separate OWB_ORACLE_HOME installed disks, that is, local physical disks on each server.

  • Close all other open applications.

For Windows Users Installing in an Oracle RAC Environment

To run the Oracle Universal Installer in an Oracle RAC environment:

  1. Ensure that you are logged on to your system as a member of the Administrators group.

  2. Insert the Oracle Warehouse Builder CD-ROM.

  3. If your computer supports the autorun feature, then the autorun window automatically starts the Oracle Warehouse Builder installation.

    If your computer does not support the autorun feature, locate the executable setup.exe in the root directory of the CD-ROM or downloaded software. Start the installer by launching the setup.exe program.

  4. When prompted to specify the cluster node, you can select all hosts or the local node.

    If you select local node, then you must install Warehouse Builder separately for each system unless installing to a shared disk.

  5. When prompted, specify a home directory to be used only for the Warehouse Builder installation.

    For example, specify a path such as C:\oracle\owb11_1.

    For the sake of brevity, the path you specify in this step is referred to as OWB_ORACLE_HOME throughout this guide.

  6. Follow the on screen instructions.

When the software installation completes successfully, you can continue with the next step in "Installing Warehouse Builder in Oracle RAC Environments".

For UNIX Users Installing in an Oracle RAC Environment

You can run Oracle Universal Installer from the CD-ROM. Do not run the Installer while the CD-ROM directory is the current directory because you cannot later unmount the next CD-ROM when prompted to do so.

To run the Oracle Universal Installer in an Oracle RAC environment:

  1. To enable clusterware installation, ensure that you run an interactive secure shell such as /bin/ssh and have host user equivalency to all nodes.

  2. Log in as the operating system user of the Oracle Database.

    For example, log in as the oracle user.

    Be sure you are not logged in as the root user when you start the Oracle Universal Installer (OUI). If you log in as root user when you start OUI, then only the root user has permissions to manage Oracle Warehouse Builder.

  3. Start the installer by entering the following at the prompt:

    cd mount_point

    ./runInstaller

  4. When prompted to specify the cluster node, you can select all hosts or the local node.

    If you select local node, then you must install Warehouse Builder separately for each system unless installing to a shared disk.

  5. As the installation proceeds, the Oracle Universal Installer prompts you to run several scripts. You must switch users and run the script as root.

When the software installation completes successfully, you can continue with the next step in "Installing Warehouse Builder on Oracle Database 11g Release 2".

Ensuring the Availability of Service Names for Oracle RAC Nodes

  1. List all of the instance or node names in the cluster. Issue the following command:

    srvctl config database -d dbname

    where dbname is the unique database name as specified by the initialization parameter db_name.

  2. For a given instance, instn, add a service with the following command:

    srvctl add service -d dbname -s instn -r instn

    The resulting service name is instn.clusterdomainname. For example, if the instance name is owbrac1,then the service name could be owbrac1.us.oracle.com.

  3. For a given instance, instn, start the service with the following command:

    srvctl start service -d dbname -s instn

  4. For a given instance, instn, verify the service is running with the following command:

    srvctl status service -d dbname -s instn

  5. Complete steps 2 through 4 for each node.

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 Warehouse Builder 

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

Once 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".