Re: Problems with Advanced Replication...

NOrgSPAM_at_mcs-hh.de (Roger) wrote in
<8ctdmj$cv1$1_at_opal.hamburg.cityline.net>:

>I tried to configure a Multi Master Replication in a simple testing
>environment. It consist of one Sun Ultra 5 with Solaris 7 and two
>instances (Oracle 8.1.5.0) on this machine named sid0 and orc0. I tried
>to do it by hand and I tried to use the Replication Manager that is
>installed on my computer (version 1.4.0). No success. The Master Site
>won't leave it's quiesced status, no matter what I do.

These are the key points I've found through trial and mostly error while struggling with replication on 8i. I've got it working now but it takes some patience and understanding of the concepts involved:  

1. Database links MUST work. I can't stress this enough.
2. global_names must be set to TRUE in init.ora. Don't use the basic database copied from the CD. There is something strange about the global_name of that database. Make sure to create a custom database based on your needs. This is good general advice and eliminates part of the global_names problem.
3. shared_pool_size needs to be at least 15 MB for the advanced replication support scripts to run.
4. job_queue_processes must be set to a number greater than 0. For Multimaster replication, Oracle recommends a minimum of 2. This is a very likely the cause of your problem, especially is dba_repcatlog is empty.
5. job_queue_interval should be set to a reasonable interval. This number is in seconds and I've seen default values of 10 and 60 depending of the database creation method.
6. Once you get the environment setup and are waiting for dba_repcatlog to clear out, try pushing the transactions by using DBMS_REPCAT.DO_DEFERRED_REPCAT_ADMIN.
7. Check for errors in deferror and dba_repcatlog. Resolve them.

I wouldn't use the Replication Manager to create your replicated environment. Script everything in a text editor first so you can have a record of what you did and can recreate it quickly when you get the right sequence of events. It will save you a lot of time. This is an iterative process to it may not work the first time. Don't be afraid to start all over. You aren't working on a production machine, are you?

>Is there somewhere a simple step by step instruction that shows how to
>setup Multi-Master Replication with Oracle 8i and what is the current
>version of the Replication manager and where can I get it ?

Try the Replication API Reference (Doc #67793). http://technet.oracle.com/doc/server.815/a67793/toc.htm

The Replication white paper is also helpful (Doc 367791). http://technet.oracle.com/doc/server.815/a67791/toc.htm

You should understand both of these very well if you are going to attempt to create and manage a replicated environment.

Wayne Menzie Received on Mon Apr 10 2000 - 00:00:00 CDT