---Setting PARSKY as mater site in replication environment 1) CREATE USER repadmin IDENTIFIED BY repadmin; 2) EXEC DBMS_REPCAT_ADMIN.GRANT_ADMIN_ANY_SCHEMA (username => 'repadmin'); 3) GRANT COMMENT ANY TABLE TO repadmin; GRANT LOCK ANY TABLE TO repadmin; GRANT SELECT ANY DICTIONARY TO repadmin; 4) EXEC DBMS_DEFER_SYS.REGISTER_PROPAGATOR (username => 'repadmin'); 5) EXEC DBMS_REPCAT_ADMIN.REGISTER_USER_REPGROUP (username => 'repadmin',privilege_type => 'receiver',list_of_gnames => NULL); 6) CONNECT repadmin/repadmin@parsky EXEC DBMS_DEFER_SYS.SCHEDULE_PURGE (next_date => SYSDATE,interval => 'SYSDATE + 1',delay_seconds => 0); ---Setting SKYDUMMY as mater site in replication environment 1) CONNECT sys/sys@skydummy as sysdba CREATE USER repadmin IDENTIFIED BY repadmin; 2) EXEC DBMS_REPCAT_ADMIN.GRANT_ADMIN_ANY_SCHEMA (username => 'repadmin'); 3) GRANT COMMENT ANY TABLE TO repadmin; GRANT LOCK ANY TABLE TO repadmin; GRANT SELECT ANY DICTIONARY TO repadmin; 4) EXEC DBMS_DEFER_SYS.REGISTER_PROPAGATOR (username => 'repadmin'); 5) EXEC DBMS_REPCAT_ADMIN.REGISTER_USER_REPGROUP (username => 'repadmin',privilege_type => 'receiver',list_of_gnames => NULL); 6) CONNECT repadmin/repadmin@skydummy EXEC DBMS_DEFER_SYS.SCHEDULE_PURGE (next_date => SYSDATE,interval => 'SYSDATE + 1',delay_seconds => 0); $$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$$ Creating Scheduled Links Between the Master Sites ---fOR PARSKY SITE 1) CONNECT sys@parsky as sysdba CREATE PUBLIC DATABASE LINK SKYDUMMY USING 'SKYDUMMY'; 2) CREATE DATABASE LINK SKYDUMMY CONNECT TO repadmin IDENTIFIED BY repadmin; ---fOR SKYDUMMY SITE 1) CONNECT sys/SYS@skyDUMMY as sysdba CREATE PUBLIC DATABASE LINK PARSKY USING 'PARSKY'; 2) CREATE DATABASE LINK PARSKY CONNECT TO repadmin IDENTIFIED BY repadmin; ----Define a schedule for each database link to create scheduled links. ---For PARSKY site 1) CONNECT repadmin/repadmin@parsky EXEC DBMS_DEFER_SYS.SCHEDULE_PUSH (destination => 'SKYDUMMY',interval => 'sysdate+1/24/60',next_date => sysdate+1/24/60,stop_on_error => FALSE,parallelism => 1,delay_seconds => 1200); 2) CONNECT repadmin/repadmin@skydummy EXEC DBMS_DEFER_SYS.SCHEDULE_PUSH (destination => 'PARSKY',interval => 'sysdate+1/24/60',next_date => sysdate+1/24/60,stop_on_error => FALSE,parallelism => 1,delay_seconds => 1200); @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ Chapter 2 Creating a Master Group --- For parsky 1) CONNECT repadmin/repadmin@parsky EXEC DBMS_REPCAT.CREATE_MASTER_REPGROUP (gname => 'hr_repg'); 2) EXEC DBMS_REPCAT.CREATE_MASTER_REPOBJECT (gname => 'hr_repg',type => 'TABLE',oname => 'countries',sname => 'hr',use_existing_object => TRUE,copy_rows => TRUE); 3) Add additional master sites. a) exec DBMS_REPCAT.ADD_MASTER_DATABASE (gname => 'hr_repg',master => 'skydummy',use_existing_objects => TRUE,copy_rows => TRUE,propagation_mode => 'ASYNCHRONOUS'); 4) If conflicts are possible, then configure conflict resolution methods. a) exec DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT (sname => 'hr',oname => 'countries',type => 'TABLE',min_communication => TRUE); 5) Resume replication. DBMS_REPCAT.RESUME_MASTER_ACTIVITY (gname => 'hr_repg');