| 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
Chris,
Yes, we are on 9.0.3. Currently, we can't deploy Oracle 9i on the Sun Cluster, where the data warehouse lives, so we are stuck with 9.0.3. Hopefully, later this year we will be able to upgrade. I haven't looked into the 9.2 installation, so I wasn't aware of the server-side portion of it. I'm sure I have plenty to look forward to. We do want to go with workflow, if it is better than previous versions. Right now, we run everything via cron.
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 Chris Stephens
Sent: Friday, February 20, 2004 2:23 PM
To: 'oracle-l_at_freelists.org'
Subject: 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. =20
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. =20
chris
-----Original Message-----
From: Scott Canaan [mailto:srcdco_at_rit.edu]=20
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
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
 |
 |