| Multimaster Replication [message #233830] |
Fri, 27 April 2007 13:08  |
|
|
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 10.0.2.0.1
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',
'global_names');
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', -
'TEMPERATURES', 'TABLE', gname=>'FROMORCL1');
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!!!
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
