Location: Oracle Warehouse Builder

Discussion: Major Steps for installing OWB 10gR2 & workflow in Window environmentReported This is a featured thread

Category: Discussion Forum / General Discussion
Showing 1 post
htu
htu
Major Steps for installing OWB 10gR2 & workflow in Window environment
Jul 30 2009, 8:43 AM EDT | Post edited: Jul 30 2009, 8:43 AM EDT
I have not got chance to install OWB 11gR1. I'd like to share the major steps for installing OWB 10gR2. Is there any difference when installing 11gR1? I have all the detailed steps and screen shots. Just have not figured out how to include picture in the posts.

1. Preparation for installation
1) Check and install a loopback adapter if necessary
2) Use a domain account if needed

2. Install Oracle database
1) Install the database server 10.2.0.1 and create a start database
2) Upgrade database server to 10.2.0.3
3) Upgrade the starter database from 10.2.0.1 to 10.2.0.3

3. Install Oracle warehouse builder
1) Install OWB 10.2.0.1
2) Patch OWB to 10.2.0.2
3) Install DST patch

4. Create an OWB repository
1) Create tablespaces to be used for repository, snapshot, index, etc.
2) Run Start->Programs->Oracle OWB Home->Warehouse Builder->Administration->
Repository Assistant
3) Follow instructions to create repository owner and OWB users

5. Install Workflow

1) Backup the database
2) Add tablespace for workflow manager
3) Shutdown the instance
4) Install workflow server from Oracle companion CD in DB home folder
5) Start Oracle instance
6) Create workflow repository - OWF_MGR
7) Install workflow middle tier from Oracle companion CD
8) Install workspace manager patch 10.2.0.4
9) Edit the workflow setup if needed
10) Start workflow manager and service
11) Check workflow manager http://{your-host}:6061/WFMGRWebApp/uix/
12) Add OWF_MGR to owb repository as a location
 Do you find this valuable?    

Sign in to be the first to reply.