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

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

Multi-database topology
WKiom1X5ZvTzDhT0AADBWNaLYDI986.gif

Client, CCS, Server Split topology
WKioL1X5aXmwfNcJAACG3q55ag4878.gif

CCA topology
WKiom1X5Z5iwwbSnAADkCKe8wy4192.gif

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
WKioL1X5Tj3QbTCGAAEnP9Nc5gw043.jpg
Click the setup.bat batch file
WKiom1X5TErRGhZxAAJUHiO985U899.jpg
Click Next
WKiom1X5TJORU1keAAJp24G1GkE152.jpg
Select owb home directory and product name, click Next
WKioL1X5TxfBTN0wAAKf1VG7HRw087.jpg
Cancel the option "I want to receive security updates via My Oracle Support" and click Next.
WKioL1X5T5GCtEQAAAC8bmORyto648.jpg
Click the "Yes" button
WKiom1X5TZvhEa0uAAKw0unp36c282.jpg
Click the Install button
WKiom1X5TkbgYcFlAAIN6FOdGJA619.jpg
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
WKioL1X5bHiBJll6AAKIASVqHlA812.jpg
Click Next
WKioL1X5bPmQSu9sAAHyC7i9YxQ999.jpg
Enter the database connection information and click Next
WKiom1X5avizUJu2AAJMhus1hG8045.jpg
Select Manage Warehouse Builder workspace and click Next
WKioL1X5bYODkx3QAAHClVf_U98067.jpg
Select Create a new Warehouse Builder workspace and click Next
Gt;

Select Create a workspace with a new user and click Next
WKioL1X5bg_DoOyyAAGTsPtN6mc191.jpg

Enter the password for the system user and click Next
WKioL1X5bo_hnZozAAQarL2laao710.jpg
Click Next
WKioL1X5bvnxp2iVAAIyVOZBJuM963.jpg
Create a database user for the workspace, specifying the name of the workspace. Click Next
WKiom1X5bRTwcWGwAAGxwn4MpP4385.jpg
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.
WKiom1X5bc_zKWhzAAFx5WkfdoI470.jpg
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,
WKioL1X5cjLAWjBgAAIJxbM_CiE872.jpg
Select the table space for the OWBSYS user and click Next
Gt;
Click Next
WKioL1X5c-bjmKxwAAJvB6Qph1c709.jpg
Click Create New User
WKioL1X5dDTT2EvMAAEqCrP7qR4196.jpg

Click OK
WKiom1X5ciuhBt53AAKAwhEw-50239.jpg
Click Next
WKiom1X5clSwwANQAAMYJh8yFkE377.jpg
Click Finish
WKiom1X5cqrCmHbhAACeT4wUAsg576.jpg

Gt;

Installed


1 comment:

  1. TheMendix technologywas originally developed at Siemens, where it was used to create business applications. mendix is built upon the application model of the siemensplattform, and the mendix tooling is inspired by siemens’ visual development environment. These days, mendix is the leading platform for developing fast and flexible business applications.

    ReplyDelete