Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 7.3 on NT

Re: Oracle 7.3 on NT

From: Miles Thomas <thomasm_at_>
Date: 1997/06/16
Message-ID: <01bc7a3b$cb051ba0$4621ea9e@UKP01436.logica.co.uk>#1/1

Rich Woods <rawoods_at_concentric.net> wrote in article <33A1DF04.4ED5_at_concentric.net>...
> mark_clark_at_ml.com wrote:
> >
> > Hello Folks,
> >
> > A quick question regarding Oracle 7.3.2(+) on NT 3.51/4 ;-
> >
> > Has anyone deployed several of these systems using Symmetric
> > Replication to keep them in sync. I'm interested in feedback
> > regarding problems / gotcha's etc.
> >
> > Thanks
> >
> > Mark Clark
> One of my customer's business units has deployed multiple multi-master,
> asynchronous replication sites across a WAN with considerable success.
> Their biggest headache to date has been a somewhat unreliable network
> connection between FL and AZ. This hasn't been a serious problem as
> their transactions per second aren't excessive, Oracle's distributed
> processing capabilities are robust, and the Replication Manager console
> provides a precise, detailed view of their entire replicated
> environment.
> --
> Rich Woods
> Technical Field Support Specialist, Oracle Corporation, USA
> The above statements and opinions are my own and do not
> necessarily represent those of Oracle Corporation.
>

My current project is planning a single master/multiple snapshot design. We haven't depolyed yet (but will soon).

Most of my problems come from the Replication Manager frontend, which is a bit limited in certain respects. It hangs frequently on NT4 (but is OK on W95). You have to edit the scripts it produces to run with SQL*Plus, since it doesn't include a / after the begin/end sequence. You cannot add or manage uniqueness or delete resolution methods, or user function update resolution methods via the frontend. It can report replication items as status error even when they are not (common problem when registering views which depend on functions or orther views--its does it in arbitrary order, not dependence order!) Its not possible to get it to replicate existing PL/SQL packages without making them into deferred procedures also, which causes needless errors. Its ability to view and manage the underlying statistics and errors from the replication catalogue seems to be limited.

It would also help if it had utilities to generate the function call prototypes for user function resolution procedures. Dropping these into the script file as a comment would be v. helpful.

-- 
Miles Thomas
Logica UK Ltd
thomasm "at" logica "dot" com
The above are personal opinions, and are
not necessarily the opinions of my employer.
Received on Mon Jun 16 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US