Oracle-L: RE: Distributed Option

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Fri, 27 Dec 2002 13:18:46 -0800
Message-ID: <F001.005235ED.20021227131846@fatcity.com>

Michael

By distributed, I assume you mean "replication"? From what I can tell, basic replication is included with Standard Edition and advanced replication is included with Enterprise Edition.

I think you run a script, something like "catrep.sql" in rdbms/admin, so you should be able to get the pieces installed.

Replicating between different Oracle versions could be challenging, but doable. Others on the list can probably offer specific advice on pitfalls.

We haven't implemented replication here, just studied. From what I can tell, planning for replication is everything. I have only been able to find 2 books on it. The prize is Marie Buretta's Database Replication. http://www.amazon.com/exec/obidos/ASIN/0471157546/qid%3D1041023613/sr%3D11-1 /ref%3Dsr%5F11%5F1/102-1511927-6720101
It really tells you everything you need as an organization to prepare for replication. Replication takes a lot of administration so it should be a gold mine since you are consulting.

The other book is Oracle Distributed Systems by Charles Dye http://www.amazon.com/exec/obidos/ASIN/0471157546/qid%3D1041023613/sr%3D11-1 /ref%3Dsr%5F11%5F1/102-1511927-6720101

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Friday, December 27, 2002 2:39 PM
To: Multiple recipients of list ORACLE-L

I've got a client that needs "distributed option" installed on several databases,
versions 7.3.4, 8.0.5, and 8.1.7...

Problem may be I'm not sure we'll have all the CD's as vendors of applications did most of the installs and we think we'll
find that they took the CD's with them.
After all, if it's up and running and
vendor supported(or was), why would the
client need the CD?

Anyhow, is it just a "free" option that will need to be selected with the Oracle installer, or is it an "add on" that one is supposed to contact Oracle on? Or perhaps it just involves running one of those all but undocumented packages.

There are many ways to work around this if we have to, but would like to know what all is involved if we can get the distributed option installed on all of their databases.

It's on my Personal Oracle, but seems to be part of a general set of things that
get installed.

Kline's Consulting
Michael Alan Kline, Sr., Owner
13308 Thornridge Court; Midlothian, VA 23112, USA.

Work: 804-744-1545     Cell: 804-314-6262 
Pager: 877-705-1155     ICQ: 1009605, 975313

mkline1_at_comcast.net; maklinesr_at_earthlink.net;
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Michael Kline
INET: mkline1_at_comcast.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------