To ensure the integration of Oracle Enterprise Manager with Warehouse Builder, follow these configuration steps:. This wizard helps you create the Enterprise Manager repository in the Warehouse Builder repository instance. Password: Password of the schema where the Enterprise Manager Repository will be installed.
From the Select Repository User Tablespace page, you can choose to create a new tablespace or accept the default.
Click Next. On the database where you installed the Warehouse Builder runtime, start the Oracle Agent service. This server manages the job library. If you are newly configuring the service, the Add Management Server dialog box appears. Type the host name of the Warehouse Builder repository server. Administrator: sysman initial Enterprise Manager Console login user name.
Select Nodes from the navigation tree. Right-click and select Discover Nodes from the pop-up menu. In the Discover Wizard Specify Nodes page, type the name of the computer on which the Warehouse Builder target warehouse resides and click Next to view the results.
Click OK. Windows inserts the new user name into the list of user names. The User Rights panel displays. Select the Logon as a Batch Job option from the drop-down list in the Right field. Click Show Users and select the name of the new Enterprise Manager user you just created. Enterprise Manager schedules jobs on the system that hosts the Warehouse Builder runtime schema.
Increase this parameter value by 2 for every additional 8 CPUs. Optimal setting is This setting increases the timeout for performing checkpoints from the default 3 minutes to 5 minutes. This is only required when installing on Oracle RAC systems.
You may specify a higher value if you start multiple sessions or if you run multiple or complicated mappings in one session. Set this parameter for Oracle9 i or Oracle8 i databases only. This is MB. If you perform frequent sorting and aggregation, then you can increase this value. Oracle strongly recommends creating a resource plan for managing resource usages for Warehouse Builder runtime. Refer to the Oracle Database Administration Guide for information on resource plans.
In that case, follow the recommendations on sizing the preceding four parameters. If you want to specify individual directories, then repeat this parameter on contiguous lines for each directory.
If you use flat file targets in Warehouse Builder, then set this parameter to the directory where you want to create the flat file target so that your database engine has access to it. When installing client components on Linux, you must specify the environmental variable for the Oracle home. When installing the standalone software, Oracle Warehouse Builder utilizes the Oracle Universal Installer to install components and to configure environment variables.
The installer guides you through each step of the installation process. Oracle home is the top-level directory into which you install Oracle software. Some Oracle products enable you to share the same Oracle home. Or you can create separate homes and assign names to each home as you install each product. Warehouse Builder, however, cannot share its home directory with any other Oracle product. When the Oracle Universal Installer prompts you to specify a home directory for Oracle Warehouse Builder, specify a directory different from the Oracle Database or any other Oracle product.
This separate directory is designated by the term owb home in the Warehouse Builder documentation. When the software installation completes successfully, you can continue with the next step in General Steps for Installing Warehouse Builder.
This section contains additional points to address before launching the Universal Installer:. If your computer supports the autorun feature, then the autorun window launches the Oracle Warehouse Builder installation. If your computer does not support the autorun feature, then locate the executable setup. Start the installer by launching the setup. For the sake of brevity, the directory you specify in this step is referred to as the owb home throughout this guide.
For example, log in as the oracle user. If you choose to log in as the oracle user, you must configure the user environment by setting the default file mode creation mask umask to in the shell startup file. Be sure you are not logged in as the root user when you start the Oracle Universal Installer.
If you are, then only the root user would have permissions to manage Oracle Warehouse Builder. As the installation proceeds, the Oracle Universal Installer prompts you to run several scripts. You need to switch users and run the script as root.
After you complete the installation, you can start the Warehouse Builder components listed in Table The components in Table are listed in the order that you are likely to use the components directly after installation:.
The first time you invoke this listener, select and re-confirm a password for an oc4jadmin account. Is the scripting utility that enables to perform all operations available in the graphical user interfaces.
To host a Warehouse Builder 11 g repository on Oracle Database 10 g Release 2, complete the following steps:. For additional considerations for hosting the repository on Oracle 10 g Database, refer to "Preparing the Oracle Database". To create a Warehouse Builder repository on an Oracle 10 g Release 2 Database, complete the following steps:.
For example:. For example, type the following:. The script creates the repository and sets up the required roles and privileges on the 10 g Release 2 Database. Use this script to ensure that the Control Center runs correctly from the Warehouse Builder When prompted for the owb home, type the directory carefully.
The entry is case-sensitive, does not accept a trailing slash, and requires forwards slashes only, regardless of the operating system. For example, for Windows, if the owb home is. Warehouse Builder 11g clients connect to workspaces on an Oracle 11 g Database by default.
To access workspaces on an Oracle 10 g Release 2 Database, you must take additional steps. If the file does not exist, you can create it based on the example file Preference. Edit Preference. After you save the file, the client can access repositories stored in Oracle Database 10 g Release 2. However, there are a few specific details to observe as noted in the following instructions:. For each computer to host Warehouse Builder components, configure the tnsnames.
Also configure tnsnames. If you fail to configure tnsnames. If the Warehouse Builder repository is hosted on Oracle Database 11 g and you do not intend to integrate with Oracle Discoverer, skip to the next step. 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. If the software is installed on separate disks, copy rtrepos. Installing and Enabling Optional Components Optional. Consider performing the optional step "Configuring Repository Browser Environments".
The Repository Browser lets you nominate a node and register other nodes. Repeat "Installing the Warehouse Builder Software" for each computer to be used as a client. Because you can connect to Warehouse Builder repositories using a net service name, you can embed Oracle RAC properties into the connect string to utilize Oracle RAC capabilities such as connect time failover, load balancing on server and load balancing of connections.
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, you must manually ensure the availability. 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. The installed location must be the same directory path if using separate owb home installed disks, that is, local physical disks on each server.
If your computer supports the autorun feature, the autorun window will automatically start the Oracle Warehouse Builder installation. If your computer does not support the autorun feature, locate the executable setup. If you select local node, then you must install Warehouse Builder separately for each system unless installing to a shared disk. For the sake of brevity, the path you specify in this step is referred to as owb home throughout this guide.
If you are, then only the root user will have permissions to manage Oracle Warehouse Builder. The resulting service name is instn. For example, if the instance name is owbrac1,then the service name could be owbrac1. For a given instance, instn, verify the service is running with the following command:.
Skip Headers. Starting and Stopping the Browser Listener In previous releases, Windows users could start and stop the Browser Listener from the program group. Oracle Workflow Embedded within Warehouse Builder Previously, if you wanted to utilize Oracle Workflow to manage job dependencies or if you wanted to deploy process flows, it was necessary to install Oracle Workflow. Warehouse Builder Architecture and Components Oracle Warehouse Builder is an information integration tool that leverages the Oracle Database to transform data into high-quality information.
Design Center The Design Center provides the graphical interface for defining sources, designing targets, and designing ETL and other data transformation processes. Target Schema The target schema is the target to which you load your data and the data objects that you designed in the Design Center such as cubes, dimensions, views, and mappings.
Warehouse Builder Repository The repository schema stores metadata definitions for all the sources, targets, and ETL processes that constitute your design metadata. About Workspaces In defining the repository, you create one or more workspaces with each workspace corresponding to a set of users working on related projects.
Repository Browser The Repository Browser is a web browser interface for reporting on the repository. Implementation Strategies This section provides an overview of the various choices and considerations for implementing Warehouse Builder. Separate Design and Runtime Environments Implementation In an implementation such as shown in Figure , one repository stores the metadata necessary for designing in Warehouse Builder.
Development, Test, and Production Environments Organizations typically maintain separate environments for developing and testing prior to releasing a project into a production environment. Remote Runtime Environment Implementation The Control Center Service is the Warehouse Builder server component that governs the deployment of objects to target schemas.
To begin a new installation: Determine your implementation strategy. Setting the Security Policy for the Repository When you install a repository, Warehouse Builder enforces a default metadata security policy. Installing and Enabling Optional Components Optional See Chapter 5 for instructions on enabling optional components such as browsers, third party tools, and related Oracle products.
Install the Warehouse Builder software on the client computers. Understanding the Installation Requirements Refer to this section as you develop your implementation strategy. Required Components Table lists the components required in an Oracle Warehouse Builder environment. See "Preparing the Server". Client computer Client computers must have either a Windows or a Linux operating system.
See "Preparing Client Computers". Be sure to specify a separate home directory for Warehouse Builder. For an overview, see "Warehouse Builder Architecture and Components". Oracle Workflow You can use Oracle Workflow to manage job dependencies. Preparing the Server If you have yet to install an Oracle Database on the server, then consult the Oracle Database Installation Guide for your operating system. All other UNIX platforms require more disk space. Available Memory MB for Linux. If you log in as root user when you start Oracle Universal Installer, then only the root user has permissions to manage Oracle Warehouse Builder.
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 Oracle Warehouse Builder". The resulting service name is instn.
For example, if the instance name is abcdef1 , then the service name could be abcdef1. For a given instance, instn, verify the service is running with the following command:. 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.
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:. See Also: Oracle Database Installation Guide for information on preinstallation requirements for the proper installation of Oracle Database. For running the Oracle Warehouse Builder For installing Oracle Warehouse Builder On Linux: choose the Linux x86 option.
This includes 1. Click the setup. Click Next. Do not use any spaces in the directory path. See Also: Note ID Close all other open applications.
When prompted to specify the cluster node, you can select all hosts or the local node. Follow the on screen instructions. Log in as the operating system user of the Oracle Database.
0コメント