Ray,
Advanced replication definitely does NOT require using
replication manager. Being an anti-gui person, I use
the repapi calls almost exclusively. Starting with
8.1.6 replication manager is java-based and therefore
you should be able to run it from any java-capable
client, although I personally have not tried it from
anything other than a windows client. (Yes, I know it
was java-based in 8.1.5, but it was considered a beta
product until 8.1.6).
Once you're comfortable setting up replication,
setting it up via scripts can be just as quick or
quicker than using replication manager. Since
replication manager incorporates some additional views
behind the scenes for displaying info from the rep
views I prefer to query the views directly.
The biggest problems I've found with using replication
manager are:
- if you don't know what you're doing it's too easy
to click on the wrong buttons and make matters worse.
- logging onto replication manager as a user other
than the registered propagator causes all sorts of
problems if you then attempt to perform rep
operations. While it's possible to do the same thing
from command line, I find one is less likely to log on
as the wrong user.
- if replication manager hangs, the user just kills
the replication manager session and starts a new one
(depending on the stupidity of the user this can be an
endless loop!) so you end up with locks being held by
the original session and everything else backs up
waiting on those locks to be released.
HTH,
- Anita
- Ray Stell <stellr_at_stell.cns.vt.edu> wrote:
>
> I was beginning to think advanced replication looked
> like
> a reasonable solution for an applicaiton. Then I
> read:
>
> Replication environments supporting both multimaster
> and snapshot
> replication can be challenging to configure and
> manage. To help
> administer these replication environments, Oracle
> provides a
> sophisticated management tool called Oracle
> Replication Manager.
>
> Coupled with the absence of a config guide, am I to
> guess
> that Oracle is underpining it's advanced technology
> with a
> toy OS? This would be ironic, pathetic, and
> unacceptable.
> Please tell me I've missed the real config guide.
>
> Ray Stell stellr_at_vt.edu (540) 231-4109
> KE4TJC 28^D
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Ray Stell
> INET: stellr_at_stell.cns.vt.edu
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> 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).
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: A. Bardeen
INET: abardeen1_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).
Received on Mon Jul 02 2001 - 07:25:26 CDT