| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle Warehouse Builder Install Questions
Scott,
You must be using 903 or an earlier version. With 9.2 (I think), oracle requires server-side components to install. They are mainly used for the name and address cleansing capabilities but you also have to launch the run-time assistant (or one of the assistants) from the local machine in order to complete a setup.
Also...the workflow isn't too bad in 9.2. We've had a few issues with hanging processes but it's easy to create and deploy the things.
We installed the server-side and owf in their own home in production and dev without incidence.
It's been quite a while since I did the installation and haven't worked with the tool much lately.......but imho it is vastly improved from previous versions and it seems to be a product that oracle is investing heavily in.
chris
-----Original Message-----
From: Scott Canaan [mailto:srcdco_at_rit.edu]
Sent: Friday, February 20, 2004 11:47 AM
To: oracle-l_at_freelists.org
Subject: RE: Oracle Warehouse Builder Install Questions
Tom,
We use Oracle Warehouse Builder here. The only thing that was "installed" on the database server was the repository. The OWB software is installed on our pc's and that is the only place that we work with it. Once you install the software on your pc, you can create the repository. I pre-created all of the tablespaces (there are 16 of them). You have to be careful with the repository installation, as I had some trouble with it defaulting ownership of some objects to system.
We don't use Work Flow, as I've heard bad things about it many times, including at last year's IOUG.
Scott Canaan (srcdco_at_rit.edu)
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put
into it." - Tom Lehrer.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Mercadante, Thomas F
Sent: Friday, February 20, 2004 10:51 AM
To: 'oracle-l_at_freelists.org'
Subject: Oracle Warehouse Builder Install Questions
All,
We have installed Oracle Warehouse Builder in a development warehouse environment. We are now being asked to install Oracle Work Flow as OWB wants to interact with OWF.
My concern is mission creep here. Is anyone here using either of these
products? How and where do you install them? On the database server
machine? Application Server? It makes me nervous to keep installing
these
(what I think) are development tools on the Db Server itself. We just
don't
have the experience (nor has *anyone* had any training) with these
tools to
make intelligent decisions regarding the installation infrastructure.
Any help or comments would be appreciated.
thanks
Tom Mercadante
Oracle Certified Professional
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |