Re: Replication Option

In article <45lq7c$jt4_at_nimitz.fibr.net>, dcigary_at_tcp.co.uk says...
>
>I would like to hear from anyone that is using the replication option in
>Oracle. We are trying to set it up for a client, and are having a few
>problems with dropping replicated schemas, and schemas not replicating
>correctly. Any help would be appreciated! Please mail to :
>
> dcigary_at_txdirect.net
>
>I'll post a summary if there's enough interest.
>
> Thanks!
>
> --Gary Eckhardt
> Database Consultants, Inc.l
> dcigary_at_txdirect.net

We have set up a simple replication environment in a Sun/Solaris 2.4 environment, with two Database Instances on the same machine. It is only for evaluation at this point, we do not intend to replicate on the same machine.
We are evaluating multi-master replication, and are not using snapshots.
So far, we have created two schemas, Defined the master defintion site, created some tables on the master def site, and then added the second master site. We then "Resumed Replication" and watched the schema be replicated at the second site. We scheduled replication for our dml propagation, and populated a table on one site, again, watching it get replicated. Have also inserted the same pk value at the same time on both nodes and cleaned up the errors. Have not yet defined conflict resolution, but have poked around the triggers, stored procedures, underlying tables, and views to learn more.
We have 7.2.2.3, and are trying to implement a scheme without the REPADMIN account (i.e, we want the schema to manage its own replication, and not have to rely on the REPADMIN superuser). We had problems with read access to the DEFCALL, DEFTRAN, DEFERROR tables from the replication schema so we granted select on those tables to public.

It's fun! We only have online docs, so it's hard to read, and when you print our solaris hplaserjets are configured so that I crash oracle book often. Documentation is scattered and incomplete, the product is young, but we have managed to get it running without any formal training.

Good Luck!
I would also like to hear from others using this product. Steve Received on Sat Oct 14 1995 - 00:00:00 CET