Install and configure Oracle Warehouse Builder 11.2.0.3

Install and configure Oracle Warehouse Builder 11.2.0.3

The OWB contains the following components

• The OWB Client (which includes the Design Center and the Control Center Manager)
• The OWB Browser
• Control Center Service
• Control Center Agent
• The Repository

Oracle database 11g release 2 contains all the components of owb.

Depending on your business needs, OWB provides five topologies for installation

1. Single-machine topology
2. The client and the database service separate the topology
3. Multi-database topology
4. Client, control center service, database service separation topology
5. Control Center Agent topology

Single-machine topology

All components of OWB run on a single computer.

Client, service separation topology (client recommended installation of owb11.2 standalone version of the installation)

Multi-database topology

Client, CCS, Server Split topology

CCA topology

This installation configuration to the client server topology in order to.

First, install the client on Windows.

To the official website to download the installation package OWB_11.2.0.3_Windows_x86-64.zip, to extract. as follows

Click the setup.bat batch file

Click Next

Select owb home directory and product name, click Next

Cancel the option "I want to receive security updates via My Oracle Support" and click Next.

Click the "Yes" button

Click the Install button

At this point, the installation is complete, click the Exit button.

Second, install the server-side (Linux)

Database version 11.2.0.4.0, so the server does not need to install OWB, just two users can unlock

1 2 3 4 5 6 7 8 9

SQL> conn / as sysdba Connected. SQL> alter user owbsys identified by owbsys account unlock; User altered. SQL> alter user owbsys_audit identified by owbsys_audit account unlock; User altered.

Third, in the Repository to create the first work area (in the database side)

1 2	[oracle@localhost ~]$ cd $ORACLE_HOME/owb/bin/unix/ [oracle@localhost unix]$ ./reposinst.sh

Click Next

Enter the database connection information and click Next

Select Manage Warehouse Builder workspace and click Next

Select Create a new Warehouse Builder workspace and click Next

Select Create a workspace with a new user and click Next

Enter the password for the system user and click Next

Click Next

Create a database user for the workspace, specifying the name of the workspace. Click Next

Enter the password for the Repository user and click Next.

If the graphical interface is not started on the server locally, the following error will be reported.

Solution

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

[oracle@localhost ~]$ cd /u01/app/oracle/product/11.2.0/db_1/owb/UnifiedRepos/ [oracle@localhost UnifiedRepos]$ sqlplus / as sysdba SQL> @remote_owb_install.sql /u01/app/oracle/product/11.2.0/db_1 Oracle Home for the Remote OWB software installation old   1: CREATE OR REPLACE DIRECTORY OWB_REMOTE_ADMIN AS '&remote_owb_oracle_home/owb/bin/admin' new   1: CREATE OR REPLACE DIRECTORY OWB_REMOTE_ADMIN AS '/u01/app/oracle/product/11.2.0/db_1/owb/bin/admin' Directory created. Grant succeeded. Grant succeeded.

Click Next again,

Select the table space for the OWBSYS user and click Next

Click Next

Click Create New User

Click OK

Click Next

Click Finish

Installed