Humble Trader: Install OWB Client

Introduction:

This procedure installs the OWB Client Side components.

Aim:

Install OWB Client.

Requirements:

Oracle is installed and running. A suitable instance is ready for the OWB repositories.

Procedure:

Log on to the PC.
Go here (OTN - link through here to register), promise - really promise - that you are not a terrorist, and download the following file:

OWB_10.1.0.4.0.zip

Install the software (I have a few problems with this at first. The extraction creates some deep directories. If you download the file to a place that is already fairly deep, Windoze can't create a path with a name that long - because it's crap. I suggest that you download it to something like C:\tmp and unzip it there.):

Right-click the file name.
-Extract All...-
Welcome to the Compressed (zipped) Folders Extraction Wizard:

[Next]

Select a folder to extract files to: Pick a folder.

[Next]

Extraction Complete.
[Finish]
This has created a normal directory called; 'OWB_10.1.0.4.0'. Navigate into this and then burn the entire contents of this directory on to CD.
Put the CD in the drive.
Navigate to the CD and doulbe-click setup.exe
OUI:

Welcome:

[Next]

Specify File Locations:

Source:

Path: D:\stage\products.xml

Destination:

Name: OraOWB10g
Path: C:\oracle\product\10.1.0.4.0\OraOWB10g

[Next]

Available Product Components:

[Next]

Summary:

[Install]

End of Installation:

[Exit]

Exit:

[Yes]

Change the startup script:

The startup script, as it stands, contains some physical parameters as to the sizes of various pieces of memory that OWB uses - but these are not really enough. OWB is memory hungry and, if these are set too low, it ends up doing a lot of swapping and slows down to a crawl. Try these:
Open File Mangler.
Navigate to: C:\oracle\product\10.1.0.4.0\OraOWB10g\owb\bin\win32
Copy owbclient.bat to owbclient.bat.bak
Create a new owbclient.bat containing the following (apologies for the width):

call setowbenv

cd /d ..\admin

..\..\..\jdk\jre\bin\java -Xms300M -Xmx700M -Dlimit=700M -XX:MaxPermSize=500M -DORACLE_HOME="C:\Oracle\product\OracleWB1" -DOCM_HOME="C:\Oracle\product\OracleWB1" -DOCM_ORACLE_HOME="C:\Oracle\product\OracleWB1" -DORCLCWM_META_MODEL_FILE="..\..\bridges\admin\orcl_cwm.xml" -Djava.security.policy="..\..\bridges\admin\policy" -Doracle.cwm.tools.transfer.config=..\..\bridges\admin\TransferConfig_en_US.properties -DMITIENV=%MIMB_JAR% -Xbootclasspath:..\..\..\jdk\jre\lib\jce.jar;..\..\..\lib\vbjorb.jar;..\..\..\lib\vbjapp.jar;..\..\..\jdk\jre\lib\rt.jar;..\..\..\jdk\jre\lib\charsets.jar oracle.wh.ui.framework.StaticLoader

cd /d ..\win32

Save the file and exit.

Log on to OWB:

-Start-
-All Programs-
-Oracle - OraOWB10g-
-Warehouse Builder-
-OWB Client- (Might be a good idea to create a shortcut to this. We will be using it a lot.)
This is the login screen: