Download oracle warehouse builder 11g getting started

The goal of this book is to help you understand the concepts behind Oracle Database. It teaches you how to perform all common administration tasks needed to keep the database operational, including how to perform basic troubleshooting and performance monitoring activities. The primary administrative interface used in this guide is Oracle Enterprise Manager Database Control, featuring all the self-management capabilities introduced in Oracle Database.

The objective is to describe why and when administrative tasks need to be performed. Where appropriate, it describes the concepts necessary to understand and complete a task, assuming the reader has no prior knowledge of the database.

This guide is not an exhaustive discussion of all Oracle Database concepts. For this type of information, see Oracle Database Concepts. Additionally, for a complete discussion of administrative tasks, see Oracle Database Administrator's Guide.

Only minimal basic knowledge of or experience with database management is required, as well as a basic knowledge of computers. In particular, this guide is for the following groups of Oracle users: - Developers who want to acquire basic database administrator DBA skills - Anyone managing database servers - Database administrators managing an Oracle database for a small or medium-sized business This book is equally useful for enterprise DBAs.

It recommends best practices and describes efficient ways of performing administrative tasks with Oracle Enterprise Manager as the primary interface. The OBE steps through all tasks in the chapter and includes annotated screenshots. However, this is generally not necessary because Oracle Warehouse Builder is installed as part of every Oracle Database 11 g Release 2 installation.

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.

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. Repeat the procedure in "Installing Oracle Warehouse Builder" for each computer to be used as a client.

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

Whether you are installing Oracle Warehouse Builder components onto a server or a client computer, you use the Oracle Universal Installer to install Oracle Warehouse Builder components. This section contains additional points to address before starting the Universal Installer:. If your computer supports the autorun feature, then the autorun window automatically starts Oracle Warehouse Builder installation. If your computer does not support the autorun feature, locate the executable setup.

Start the installer by starting the setup. If you select local node, then you must install Oracle Warehouse Builder separately for each system unless installing to a shared disk. When prompted, specify a home directory to be used only for Oracle Warehouse Builder installation. Be sure you are not logged in as the root user when you start Oracle Universal Installer.

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.