Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How does one set up multi-master replication?

April 26, 2017multi-master replication

0

Posted

How does one set up multi-master replication?

1 Answer

0

Posted

Steps for setting up multi-master replication: • Run ?/rdbms/admin/catrep.sql as user SYS AS SYSDBA (or INTERNAL). • The SID for each database must be unique. • INIT.ORA parameters JOB_QUEUE_PROCESSES and JOB_QUEUE_INTERVAL need to be set if you want to schedule replication automatically. • GLOBAL_NAMES must be set to TRUE if you are using the Oracle Replication Manager GUI. • One can use the OEM Replication Manager to configure replication or by issuing PL/SQL API calls. Sample scripts are available here.