Home » Server Options » Replication » Multimaster Replication
Multimaster Replication [message #233830] Fri, 27 April 2007 13:08 Go to next message
Messages: 1
Registered: April 2007
Location: DAKAR
Junior Member

Dear All, I'm not good in english but I will try to decribe my problem.
I want to do replication between to database Oracle
There are scripts given to deal with. I verify that in the both databases parameters are correct.
I execute this script at each database of course I change the database link if need
REM Check if INIT.ORA parameters are OK for replication
select name, value from sys.v_$parameter
where name in ('job_queue_processes', 'shared_pool_size',

REM Assign global name to the current DB
alter database rename global_name to REPLICAT2;
REM -- Change to your DB name + domain

REM Create replication administrator / propagator / receiver
create user repadmin identified by repadmin
default tablespace USERS
temporary tablespace TEMP
quota unlimited on USERS;

REM Grant privs to the propagator, to propagate changes to remote sites
execute dbms_defer_sys.register_propagator(username=>'REPADMIN');

REM Grant privs to the receiver to apply deferred transactions
grant execute any procedure to repadmin;

REM Authorise the administrator to administer replication groups
execute dbms_repcat_admin.grant_admin_any_repgroup('REPADMIN');

REM Authorise the administrator to lock and comment tables
grant lock any table to repadmin;
grant comment any table to repadmin;

connect repadmin/repadmin

REM Create private db links for repadmin
create database link REPLICATDB connect to repadmin identified by repadmin using 'REPLICAT';

REM Schedule job to push transactions to master sites
execute dbms_defer_sys.schedule_push( -
destination => 'REPLICATDB', -
interval => 'sysdate+1/24/60', -
next_date => sysdate+1/24/60, -
stop_on_error => FALSE, -
delay_seconds => 0, -
parallelism => 1);

REM Schedule job to delete successfully replciated transactions
execute dbms_defer_sys.schedule_purge( -
next_date => sysdate+1/24, -
interval => 'sysdate+1/24');

REM Test database link
select global_name from global_name@REPLICATDB;

After this, at one database I execute this script

REM Create replication group for MASTERDEF site
execute dbms_repcat.drop_master_repgroup('FROMORCL1');
execute dbms_repcat.create_master_repgroup('FROMORCL1');

REM Register objects within the group
execute dbms_repcat.create_master_repobject('SCOTT', -
'DEPT', 'TABLE', gname=>'FROMORCL1');
execute dbms_repcat.create_master_repobject('SCOTT', -

REM Add master desination sites
execute dbms_repcat.add_master_database('FROMORCL1', 'REPLICATDB',TRUE,TRUE);

If I want to add_master_database I have the ORA-23375 error
this function is not comptaible at the REPLICATDB

Please I have check all sugguest on the web but theirs did not work

If someone have a solution to these probleme, I will thank him a lot.

I don't know I was so clear. I u don't understand please ask me I will answer soon

Any response will be accept!!
Thank u a lt!!!
Re: Multimaster Replication [message #240886 is a reply to message #233830] Sun, 27 May 2007 03:50 Go to previous message
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
go through

Next Topic: how can i see number of dblinks from the server side
Goto Forum:

Current Time: Wed Aug 17 23:07:35 CDT 2022